ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 84401

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

While loading an 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'.

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.

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution

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 the name is the RA solution. I.e. for RA FTP it is ECC-AE-SHEET-RA-FTP
  5. Stop the corresponding RA Agent(s)
  6. Delete the line for the solution to load from the Storage-Object UC_ECC_PLUGINS. I.e. for RA-FTP the line with ECC-AE-SHEET-RA-FTP
  7. Save and close the storage-object
  8. Load the solution with DB Load
  9. Start the agent(s) again
Powered by Wolken Software