IBM Support

Old Statistics records from a Connect:Direct node that was unattached from Control Center for a long time bring down SCC with a DB error

Technote (FAQ)


Question

Sterling Control Center shuts down with a CJDB026E error. The Engine log shows the root error was SQL Exception msg : DB2 SQL Error: SQLCODE=-327, SQLSTATE=22525 trying to insert a record into the database.

Cause

The Connect:Direct server that this statistical record is coming from is many weeks old because the network connection to this node was down for a long time.

Answer

THE ROW CANNOT BE INSERTED BECAUSE IT IS
OUTSIDE THE BOUND OF THE PARTITION RANGE FOR THE LAST PARTITION
.

While Control Center is down go to the directory;
<Control.Center.instance>/conf/services/node
and delete the checkpoint file for the specific node.

Then start Control Center and it will not poll the statistics so far back.

Document information

More support for: IBM Control Center

Software version: 5.3, 5.4

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

Software edition: All Editions

Reference #: 1596389

Modified date: 2013-04-19