SQL Error - Any Ideas?

[Andreas S. Rath (teddius)]

Hi OpenAnzo Group,

Follwing client side error appeared when I do a updateRepository()
call:
--------------------------------------------------
org.openanzo.services.UpdateServerException: ErrorCode[1024:32785]
[CLIENT_ERROR] Errors updating server. ErrorCode[256:262181]
[RDB_ERROR] Failed to execute an sql operation:
[insertUncommittedReferences] SQL:[INSERT INTO {1} (ID,TRANSACTIONID)
SELECT {0}.ID,{2} FROM {0} WHERE {0}.TYPE IN( 1,3)] Params:[null]
Templates:
[bulkResolutionTableName=SESSION.ID_TMP,lockedIdsTable=ANZO_USED_IDS,transactionId=476857680542916072]


On the server the exception looks like the following:
--------------------------------------------------------------------------
C:\openanzo\openanzo-3.1.0-SNAPSHOT_20081013\bin>startAnzo.bat

Welcome to OpenAnzo running in Felix.
=========================================

-> All Currently Registered OpenAnzo services started.
2008-10-13 16:03:42,228 16 [ERROR] [http://openanzo.org/
service/CombusUpdateServiceListener] [OpName=update]
[OpId=32099089-4172-403e-81a1-6a737d5a9765]
[OpUser=ldap://uid=arath,ou=users,dc=openanzo,dc=org] [RunAs=]
[UserDesc=] org.openanzo.datasource.update.ServerUpdatesProcessor -
Error Processing Update:
org.openanzo.exceptions.AnzoException: ErrorCode[256:259] [RDB_ERROR]
Failed executing batch operation:[{0}] Root Cause:
com.ibm.db2.jcc.b.em [jcc][t4][102][100
40][3.50.152] Non-atomic batch failure. The batch was submitted, but
at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
145)
at
org.openanzo.datasource.nodecentric.DispatchingDeltaQuadStore.update(DispatchingDeltaQuadStore.java:
378)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransactionEnd(ServerUpdatesProcessor.java:
405)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransaction(ServerUpdatesProcessor.java:
311)
at org.openanzo.datasource.update.ServerUpdatesProcessor
$1.handleTransaction(ServerUpdatesProcessor.java:251)
at
org.openanzo.services.serialization.XMLUpdatesReader.parseUpdateTransactions(XMLUpdatesReader.java:
149)
at
org.openanzo.services.serialization.XMLUpdatesReader.read(XMLUpdatesReader.java:
82)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.read(ServerUpdatesProcessor.java:
246)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.update(ServerUpdatesProcessor.java:
201)
at
org.openanzo.datasource.nodecentric.NodeCentricUpdateService.updateInternal(NodeCentricUpdateService.java:
88)
at
org.openanzo.datasource.services.BaseUpdateService.update(BaseUpdateService.java:
135)
at
org.openanzo.combus.listener.CombusUpdateServiceListener.handleMessage(CombusUpdateServiceListener.java:
133)
at
org.openanzo.combus.endpoint.BaseServiceListener.processMessage(BaseServiceListener.java:
319)
at org.openanzo.combus.endpoint.BaseServiceListener.access
$000(BaseServiceListener.java:57)
at org.openanzo.combus.endpoint.BaseServiceListener
$ProcessThread.run(BaseServiceListener.java:262)
Caused by: com.ibm.db2.jcc.b.em: [jcc][t4][102][10040][3.50.152] Non-
atomic batch failure. The batch was submitted, but at least one
exception occurred on an i
ndividual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at com.ibm.db2.jcc.b.wc.a(wc.java:365)
at com.ibm.db2.jcc.b.p.a(p.java:318)
at com.ibm.db2.jcc.b.uk.a(uk.java:3511)
at com.ibm.db2.jcc.b.uk.b(uk.java:3340)
at com.ibm.db2.jcc.b.uk.executeBatch(uk.java:1944)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
140)
... 14 more
2008-10-13 16:04:19,493 37281 [ERROR] [http://openanzo.org/
service/CombusUpdateServiceListener] [OpName=update]
[OpId=bbbd995e-9779-42ab-9397-51fc78ddc1c3]
[OpUser=ldap://uid=arath,ou=users,dc=openanzo,dc=org] [RunAs=]
[UserDesc=] org.openanzo.datasource.update.ServerUpdatesProcessor -
Error Processing Update:
org.openanzo.exceptions.AnzoException: ErrorCode[256:259] [RDB_ERROR]
Failed executing batch operation:[{0}] Root Cause:
com.ibm.db2.jcc.b.em [jcc][t4][102][100
40][3.50.152] Non-atomic batch failure. The batch was submitted, but
at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
145)
at
org.openanzo.datasource.nodecentric.DispatchingDeltaQuadStore.update(DispatchingDeltaQuadStore.java:
378)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransactionEnd(ServerUpdatesProcessor.java:
405)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransaction(ServerUpdatesProcessor.java:
311)
at org.openanzo.datasource.update.ServerUpdatesProcessor
$1.handleTransaction(ServerUpdatesProcessor.java:251)
at
org.openanzo.services.serialization.XMLUpdatesReader.parseUpdateTransactions(XMLUpdatesReader.java:
149)
at
org.openanzo.services.serialization.XMLUpdatesReader.read(XMLUpdatesReader.java:
82)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.read(ServerUpdatesProcessor.java:
246)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.update(ServerUpdatesProcessor.java:
201)
at
org.openanzo.datasource.nodecentric.NodeCentricUpdateService.updateInternal(NodeCentricUpdateService.java:
88)
at
org.openanzo.datasource.services.BaseUpdateService.update(BaseUpdateService.java:
135)
at
org.openanzo.combus.listener.CombusUpdateServiceListener.handleMessage(CombusUpdateServiceListener.java:
133)
at
org.openanzo.combus.endpoint.BaseServiceListener.processMessage(BaseServiceListener.java:
319)
at org.openanzo.combus.endpoint.BaseServiceListener.access
$000(BaseServiceListener.java:57)
at org.openanzo.combus.endpoint.BaseServiceListener
$ProcessThread.run(BaseServiceListener.java:262)
Caused by: com.ibm.db2.jcc.b.em: [jcc][t4][102][10040][3.50.152] Non-
atomic batch failure. The batch was submitted, but at least one
exception occurred on an i
ndividual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at com.ibm.db2.jcc.b.wc.a(wc.java:365)
at com.ibm.db2.jcc.b.p.a(p.java:318)
at com.ibm.db2.jcc.b.uk.a(uk.java:3511)
at com.ibm.db2.jcc.b.uk.b(uk.java:3340)
at com.ibm.db2.jcc.b.uk.executeBatch(uk.java:1944)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
140)
... 14 more
2008-10-13 16:16:03,618 741406 [ERROR] [http://openanzo.org/
service/CombusUpdateServiceListener] [OpName=update] [OpId=a46fa95f-
bb57-4784-b953-fbd82eaa7497]
[OpUser=ldap://uid=arath,ou=users,dc=openanzo,dc=org] [RunAs=]
[UserDesc=] org.openanzo.datasource.update.ServerUpdatesProcessor -
Error Processing Update:
org.openanzo.exceptions.AnzoException: ErrorCode[256:259] [RDB_ERROR]
Failed executing batch operation:[{0}] Root Cause:
com.ibm.db2.jcc.b.em [jcc][t4][102][100
40][3.50.152] Non-atomic batch failure. The batch was submitted, but
at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
145)
at
org.openanzo.datasource.nodecentric.DispatchingDeltaQuadStore.update(DispatchingDeltaQuadStore.java:
378)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransactionEnd(ServerUpdatesProcessor.java:
405)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransaction(ServerUpdatesProcessor.java:
311)
at org.openanzo.datasource.update.ServerUpdatesProcessor
$1.handleTransaction(ServerUpdatesProcessor.java:251)
at
org.openanzo.services.serialization.XMLUpdatesReader.parseUpdateTransactions(XMLUpdatesReader.java:
149)
at
org.openanzo.services.serialization.XMLUpdatesReader.read(XMLUpdatesReader.java:
82)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.read(ServerUpdatesProcessor.java:
246)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.update(ServerUpdatesProcessor.java:
201)
at
org.openanzo.datasource.nodecentric.NodeCentricUpdateService.updateInternal(NodeCentricUpdateService.java:
88)
at
org.openanzo.datasource.services.BaseUpdateService.update(BaseUpdateService.java:
135)
at
org.openanzo.combus.listener.CombusUpdateServiceListener.handleMessage(CombusUpdateServiceListener.java:
133)
at
org.openanzo.combus.endpoint.BaseServiceListener.processMessage(BaseServiceListener.java:
319)
at org.openanzo.combus.endpoint.BaseServiceListener.access
$000(BaseServiceListener.java:57)
at org.openanzo.combus.endpoint.BaseServiceListener
$ProcessThread.run(BaseServiceListener.java:262)
Caused by: com.ibm.db2.jcc.b.em: [jcc][t4][102][10040][3.50.152] Non-
atomic batch failure. The batch was submitted, but at least one
exception occurred on an i
ndividual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at com.ibm.db2.jcc.b.wc.a(wc.java:365)
at com.ibm.db2.jcc.b.p.a(p.java:318)
at com.ibm.db2.jcc.b.uk.a(uk.java:3511)
at com.ibm.db2.jcc.b.uk.b(uk.java:3340)
at com.ibm.db2.jcc.b.uk.executeBatch(uk.java:1944)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
140)
... 14 more
2008-10-13 16:16:45,868 783656 [ERROR] [http://openanzo.org/
service/CombusUpdateServiceListener] [OpName=update]
[OpId=a30de295-9bc9-484e-8a9a-579f99c678f7]
[OpUser=ldap://uid=arath,ou=users,dc=openanzo,dc=org] [RunAs=]
[UserDesc=] org.openanzo.datasource.update.ServerUpdatesProcessor -
Error Processing Update:
org.openanzo.exceptions.AnzoException: ErrorCode[256:259] [RDB_ERROR]
Failed executing batch operation:[{0}] Root Cause:
com.ibm.db2.jcc.b.em [jcc][t4][102][100
40][3.50.152] Non-atomic batch failure. The batch was submitted, but
at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
145)
at
org.openanzo.datasource.nodecentric.DispatchingDeltaQuadStore.update(DispatchingDeltaQuadStore.java:
378)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransactionEnd(ServerUpdatesProcessor.java:
405)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.handleTransaction(ServerUpdatesProcessor.java:
311)
at org.openanzo.datasource.update.ServerUpdatesProcessor
$1.handleTransaction(ServerUpdatesProcessor.java:251)
at
org.openanzo.services.serialization.XMLUpdatesReader.parseUpdateTransactions(XMLUpdatesReader.java:
149)
at
org.openanzo.services.serialization.XMLUpdatesReader.read(XMLUpdatesReader.java:
82)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.read(ServerUpdatesProcessor.java:
246)
at
org.openanzo.datasource.update.ServerUpdatesProcessor.update(ServerUpdatesProcessor.java:
201)
at
org.openanzo.datasource.nodecentric.NodeCentricUpdateService.updateInternal(NodeCentricUpdateService.java:
88)
at
org.openanzo.datasource.services.BaseUpdateService.update(BaseUpdateService.java:
135)
at
org.openanzo.combus.listener.CombusUpdateServiceListener.handleMessage(CombusUpdateServiceListener.java:
133)
at
org.openanzo.combus.endpoint.BaseServiceListener.processMessage(BaseServiceListener.java:
319)
at org.openanzo.combus.endpoint.BaseServiceListener.access
$000(BaseServiceListener.java:57)
at org.openanzo.combus.endpoint.BaseServiceListener
$ProcessThread.run(BaseServiceListener.java:262)
Caused by: com.ibm.db2.jcc.b.em: [jcc][t4][102][10040][3.50.152] Non-
atomic batch failure. The batch was submitted, but at least one
exception occurred on an i
ndividual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched
elements. ERRORCODE=-4228, SQLSTATE=null
at com.ibm.db2.jcc.b.wc.a(wc.java:365)
at com.ibm.db2.jcc.b.p.a(p.java:318)
at com.ibm.db2.jcc.b.uk.a(uk.java:3511)
at com.ibm.db2.jcc.b.uk.b(uk.java:3340)
at com.ibm.db2.jcc.b.uk.executeBatch(uk.java:1944)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:
297)
at
org.openanzo.datasource.nodecentric.NodeCentricServerQuadStore.executeNamedGraphsUpdates(NodeCentricServerQuadStore.java:
140)
... 14 more



The same exception keeps returning everytime I do a
updateRepository(). The only way to get rid of this exception is to
restart the openanzo server.

Thanks,
Andreas