Transport Case issues

Document ID : KB000089301
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 6.00A

Transport Case issues
Resolution:
Detailed Description and Symptoms
These are two common problems that occur with the Automic Transport Case:
 
1) Can not view the objects in the Transport Case (too many objects) or manually remove (delete) items from the Transport Case
2) Attempting to unload the Transport Case significantly impacts the performance of the OM system (i.e.: the Automic Database and/or AutomationEngine/Server)

Solution

If the Unload is still executing, cancel it and the following SQL command will clear all objects from a Automic Transport Case in a specified Client:

update OH set OH_ExpFlag=0 where OH_ExpFlag=1 and oh_client=<Client Number>

**PLEASE NOTE** - technical support highly recommends seeking the assistance of a qualified DBA before using the above SQL statements.