Error when trying to create output device

book

Article ID: 84838

calendar_today

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.
 

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.

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

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

Additional Information

Workaround :
N/A