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

book

Article ID: 84501

calendar_today

Updated On:

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.