ORA-00001, Unique Constraint PK_OBLOB while loading an RA solution

Document ID : KB000084401
Last Modified Date : 14/04/2018
Show Technical Document Details
Error Message :
U00038150 A database error occurred: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00001: Unique Constraint (UC4.PK_OBLOB) violated'.

While loading a RA Solution to an Oracle Database using DB Load, the load fails with error:
U00038150 A database error occurred:  'OCIStmtExecute', 'ERROR   ', '', 'ORA-00001: Unique Constraint (UC4.PK_OBLOB) violated'.
OS Version: N/A
Cause type:
Root Cause: The ECC-AE-SHEET-name line in the UC_ECC_PLUGINs file for the RA Agent needs to be deleted in order to the load to work.
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
AE Server and Initialdata
Automation Engine 12.0.0 - Available
Additional Information:
Workaround :
  1. Log in to Client 0 and open an Explorer window
  2. Navigate to folder STORAGE.
  3. Open the Storage-object UC_ECC_PLUGINS for editing.
  4. Find the line for the RA Solution you are trying to load. For each loaded RA solution there is a line ECC-AE-SHEET-name where name is the RA solution. I.e. for RA FTP it is ECC-AE-SHEET-RA-FTP.
  5. Now stop the according RA Agent(s)
  6. Delete the line for the solution to load.
  7. Save and close the storage-object.
  8. Load the solution with DB Load.
  9. Start the agent(s) again.