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.

Rate this page:

(0 users)Average rating

Document information


More support for:

Sterling 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

Translate my page

Machine Translation

Content navigation