CTGDJE051E Could not store the synchronization state in the System Store

[rnvubwi]

Hi,
I have TDI 7 fixpack 5 on win 2003
I am having a intermittent issue with my TDI assembly lines where It
runs fine for week then sometime i get these messages below :

2010-10-28 13:52:10,713 INFO [AssemblyLine.AssemblyLines/
SyncDominotoLDAP.1] [DominoDCLCon] CTGDJE051E Could not store the
synchronization state in the System Store. Exception occurred:
java.sql.SQLException: You cannot invoke other java.sql.Clob/
java.sql.Blob methods after calling the free() method or after the
Blob/Clob's transaction has been committed or rolled back.
2010-10-28 13:52:10,729 ERROR [AssemblyLine.AssemblyLines/
SyncDominotoLDAP.1] - CTGDIS266E Error in EndCycle. Exception
occurred: java.sql.SQLException: You cannot invoke other java.sql.Clob/
java.sql.Blob methods after calling the free() method or after the
Blob/Clob's transaction has been committed or rolled back.
java.sql.SQLException: You cannot invoke other java.sql.Clob/
java.sql.Blob methods after calling the free() method or after the
Blob/Clob's transaction has been committed or rolled back.
at
org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.Blob.getBytes(Unknown Source)
at com.ibm.di.store.StoreFactory.deserializeObject(StoreFactory.java:
633)
at com.ibm.di.store.PropertyStore.getProperty(PropertyStore.java:224)
at com.ibm.di.store.PropertyStore.setProperty(PropertyStore.java:128)
at
com.ibm.di.connector.DominoChangeDetectionConnector.storeSynchronizationState(DominoChangeDetectionConnector.java:
1802)
at
com.ibm.di.connector.DominoChangeDetectionConnector.saveStateKey(DominoChangeDetectionConnector.java:
2355)
at com.ibm.di.server.AssemblyLine.msEndCycle(AssemblyLine.java:3822)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:
3177)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:
2818)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:
2801)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2770)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1275)
Caused by: org.apache.derby.client.am.SqlException: You cannot invoke
other java.sql.Clob/java.sql.Blob methods after calling the free()
method or after the Blob/Clob's transaction has been committed or
rolled back.
at
org.apache.derby.client.am.CallableLocatorProcedures.handleInvalidLocator(Unknown
Source)
at
org.apache.derby.client.am.CallableLocatorProcedures.blobGetBytes(Unknown
Source)
at org.apache.derby.client.am.Blob.getBytesX(Unknown Source)
... 12 more
Caused by: org.apache.derby.client.am.SqlException: The exception
'java.sql.SQLException: The locator that was supplied for this CLOB/
BLOB is invalid' was thrown while evaluating an expression.
at org.apache.derby.client.am.Statement.completeExecute(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown
Source)
at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown
Source)
at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown
Source)
at org.apache.derby.client.am.Statement.readExecuteCall(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeX(Unknown
Source)
... 14 more
Caused by: org.apache.derby.client.am.SqlException: The locator that
was supplied for this CLOB/BLOB is invalid
at org.apache.derby.client.am.SqlException.<init>(Unknown Source)
at org.apache.derby.client.am.SqlException.<init>(Unknown Source)

Thank's for your help

[Eddie Hartman]

I've never seen this one before...
Suggest you open a PMR with our L2 support wizards.

-Eddie