Troubleshooting
Problem
Sterling B2B Integrator is stable for some time and then the ORA-00001 error is repeated many times in a short period (26000 occurrences of the Error occurred in a 7 minute period)
Symptom
SQL Error Code: 1
SQL State: 23000
java.sql.BatchUpdateException: ORA-00001: unique constraint (GISMAIN.SCI_IDX_49_2) violated
[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF012","label":"IBM i"},{"code":"PF010","label":"HP-UX"},{"code":"PF002","label":"AIX"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
NFX10403
Was this topic helpful?
Document Information
Modified date:
04 March 2019
UID
swg21557744