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.
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.
Log into SQLPlus as the Applications Manager Oracle user and run the following two SQL statements:
SQL> select MAX(so_printer_seq) "printer seq" from so_printers;
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