IBM Support

bcgserver fails to startup after upgrading the database from DB2 9.5 to 9.7

Troubleshooting


Problem

bcgserver fails to startup after upgrading the database from DB2 9.5 to 9.7

Diagnosing The Problem

After upgrading DB2 from 9.5 to 9.7 WPG bcgserver fails to start issuing the following errors in the log:
.
00000012 SibMessage E
[BCGBus:bcgmasCluster.000-BCGBus] CWSIS0002E: The messaging engine
encountered an exception while starting. Exception:
com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The data
source has produced an unexpected exception:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-443,
SQLSTATE=38553, SQLERRMC=SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-727,
DRIVER=3.64.133
.
And
.
FFDC Exception:com.ibm.db2.jcc.am.
SqlTransactionRollbackException SourceId:com.ibm.ws.rsadapter.jdbc.
WSJccCallableStatement.pmiExecute ProbeId:669 Reporter:com.ibm.ws.
rsadapter.jdbc.WSJccCallableStatement@340034
com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error:
SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=3.64.133
.

Resolving The Problem

The problem is with the bcgmas database which is addressed by the following technotes:
http://www-01.ibm.com/support/docview.wss?uid=swg21267119
https://www-304.ibm.com/support/docview.wss?uid=swg21449630

[{"Product":{"code":"SSDKJ8","label":"WebSphere Partner Gateway Enterprise Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

More support for:
WebSphere Partner Gateway Enterprise Edition

Software version:
6.2.1.1

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
263395

Modified date:
16 June 2018

UID

swg21902168

Page Feedback