Error when trying to create output device
Article ID: 84838
Updated On:
Products
CA Automic Applications Manager (AM)
Issue/Introduction
Error Message :
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPWORX.SO_PRINT_IDX) violated
ORA-06512: at "APPWORX.AWAPI", line 4461
ORA-06512: at "APPWORX.AW_WEB_API", line 2270
ORA-06512: at line 1
When trying to add a new output device through the interface an error is thrown after defining it and hitting Apply.
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPWORX.SO_PRINT_IDX) violated
ORA-06512: at "APPWORX.AWAPI", line 4461
ORA-06512: at "APPWORX.AW_WEB_API", line 2270
ORA-06512: at line 1
When trying to add a new output device through the interface an error is thrown after defining it and hitting Apply.
Environment
Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:
Component:
Cause
Cause type:
Other
Root Cause: This is caused by a mismatch of the sequence number in the so_printers table vs the maximum value in the so_seqs table for the so_printer_seqs value.
Other
Root Cause: This is caused by a mismatch of the sequence number in the so_printers table vs the maximum value in the so_seqs table for the so_printer_seqs value.
Resolution
Log into SQLPlus as the Applications Manager Oracle user and run the following two SQL statements:
If the value from the first statement is greater than the value for so_printer_seq from the second, please contact support.
Fix Status: No Fix
SQL> select MAX(so_printer_seq) "printer seq" from so_printers;
SQL> select * from so_seqs;
SQL> select * from so_seqs;
If the value from the first statement is greater than the value for so_printer_seq from the second, please contact support.
Fix Status: No Fix
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
