Troubleshooting
Problem
In High Availability mode, OMNIBus Web GUI synchronizes any configuration item (filter, view, tool, etc.) deemed spurious. If the size of the Web GUI data for any given configuration item type is very large, the update statements Web GUI sends to DB2 might fail with a SQL error -302, thus preventing the synchronization and causing the Web GUI instance to enter an unstable state.
Symptom
The symptom will be a log entry stating a given configuration item could not be synchronized, and the cause will look like the following entry in the trace logs located at either:
- $TIP_HOME/profiles/TIPProfile/logs/ncw: for Web GUI 7.4, where $TIPHOME is the installation directory for Tivoli Integrated Profile (e.g. /opt/IBM/tivoli/tipv2 ), or
- $JAZZ_HOME/profile/logs/ncw: for Web GUI 8.1, where $JAZZ_HOME is the installation directory for JazzSM (e.g. /opt/IBM/JazzSM)
Caused by: <openjpa-1.2.4-SNAPSHOT-r422266:1575445 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null {prepstmnt 1183925905 UPDATE OMNIBUS_WEB_GUI.CONFIG_ITEMS t0 SET t0.VALUE = ?, t0.LAST_UPDATED = CURRENT_TIMESTAMP, t0.CHECKSUM = ? WHERE (t0.CONFIG_ITEM_ID = ?) [params=?, ?, ?]} [code=-302, state=22001]SQLCA OUTPUT[Errp=SQLRI242, Errd=-2146041770, 86, 0, 0, -2812, 0]
DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
FailedObject: UPDATE OMNIBUS_WEB_GUI.CONFIG_ITEMS t0 SET t0.VALUE = ?, t0.LAST_UPDATED = CURRENT_TIMESTAMP, t0.CHECKSUM = ? WHERE (t0.CONFIG_ITEM_ID = ?) [java.lang.String]
[{"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Web GUI","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","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.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21986941
Manage My Notification Subscriptions