Adding and saving a Component to a new Process Flow results in a 'Duplicate' error

Article Id: 84501
Status: Published
Updated On: 15-04-2018 08:00
Legacy Id: 000013691
Products:
CA Automic Applications Manager (AM)
Issue/Introduction:

Error Message :
ErrorMsg: AwE-5001 Database Query Error (8/14/17 10:28 AM)
Details: null
java.sql.SQLException: ORA-20034: Could not Add "" - duplicate
ORA-06512: at "AM9.AWAPI2", line 477
ORA-06512: at "AM9.AWAPI2", line 450
ORA-06512: at "AM9.AWAPI", line 112
ORA-06512: at "AM9.AWAPI", line 1390
ORA-06512: at "AM9.AW_WEB_API", line 181
ORA-06512: at line 1

When creating a new Process Flow, adding components and selecting the 'Apply' between components will result in an 'ORA-20034 duplicate' error.

Investigation

  1. Open Process Flow Selector
  2. Select New
  3. Define items in General tab
  4. Open Components tab
  5. Add a TEST_JOB
  6. Apply (don't click ok to close)
  7. Add another TEST_JOB
  8. Apply or OK will throw the error.

Cause:

Cause type:
Defect
Root Cause: Cllicking 'Apply' between adding components to a new Process flow results in a 'Duplicate' error. This is a bug.

Environment:

OS Version: N/A

Resolution:

Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Applications Manager 9.2.1 - Available

Additional Information:

Workaround :
This only occurs the first time a second Component is added to a Process Flow and Apply/OK is selected. Closing/reopening or continuing to build Process Flow will not be met with the same error.