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.
Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Log into SQLPlus as the Applications Manager Oracle user and run the following two SQL statements: