We have intermittently seen the following error in the jazz.log
on a RTC 2002 ifix6 installed on a Websphere 7.0.0.15
It started happening after we installed a db2 9.7 with Fixpack 4

One of the symptoms of this problem in RTC is , we cannot import custom/or predefined templates.

here is the error we get in RTC when we try to deploy predefined templates

Error deploying predefined process templates to the repository.

CRJAZ0475I Failed to claim content: com.ibm.team.repository.common.model.impl.ContentImpl@58db58db (internalId: ) (deltaPredecessor: null, contentId: , contentLength: 54781, characterEncoding: UTF-8, contentType: application/xml, checksum: 1734556543, lineDelimiterSetting: 0, lineDelimiterCount: <unset



Looks like a db2 problem.

We searched for other occurrences to this problem

found a couple

https://www-304.ibm.com/support/docview.wss?uid=swg1IC67562

This one claims problem was fixed in Db2 9.7 FP1, so we are not sure if thats the case.









So far this problem has happened on 2 installations but has not happened on 1 other install. We have seen it in FP 4 & 5

WORKAROUND:
So far our only workaround is to goto

<WAS>\profiles\<profileName>\cells\config\cellName\nodes\nodeName\servers\server1\resources.xml

Locate the RTC datasource

edit the property 'deferPrepares', change its value from 'true' to 'false'

Restart the application server.

we are not sure why this fixes the problem
If there is any other workaround please suggest.



2011-07-22 17:08:07,234 ERROR com.ibm.team.repository - CRJAZ0852I An exception occurred while executing the task "ItemCleanupTask", contributed by component "com.ibm.team.repository". The task will be removed from the schedule.
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0212I Internal error.
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cleanupUnclaimedContent(RdbRepositoryDataMediator.java:1213)
at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanup.doAllPendingItemCleanup(ItemCleanup.java:230)
at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanupService$1.run(ItemCleanupService.java:117)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:331)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy32.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:79)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy75.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanupService.completePartialItemDeletions(ItemCleanupService.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy84.completePartialItemDeletions(Unknown Source)
at com.ibm.team.repository.service.internal.ItemCleanupTask.runTask(ItemCleanupTask.java:20)
at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:88)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy142.executeTask(Unknown Source)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:118)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:92)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.db2.jcc.am.SqlException: A processing error occurred on the server which resulted in an unrecoverable error.
Please set deferPrepares property to false and re-establish the connection. If the problem still persists, please contact support. ERRORCODE=-4225, SQLSTATE=24514
at com.ibm.db2.jcc.am.fd.a(fd.java:679)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:120)
at com.ibm.db2.jcc.am.jn.a(jn.java:2135)
at com.ibm.db2.jcc.t4.cb.m(cb.java:809)
at com.ibm.db2.jcc.t4.cb.i(cb.java:253)
at com.ibm.db2.jcc.t4.cb.c(cb.java:55)
at com.ibm.db2.jcc.t4.q.c(q.java:44)
at com.ibm.db2.jcc.t4.rb.j(rb.java:147)
at com.ibm.db2.jcc.am.jn.ib(jn.java:2116)
at com.ibm.db2.jcc.am.kn.b(kn.java:4058)
at com.ibm.db2.jcc.am.kn.cc(kn.java:709)
at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:683)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:720)
at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.selectKeys(AbstractBackgroundDeleter.java:234)
at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.doIt(AbstractBackgroundDeleter.java:110)
at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.run(AbstractBackgroundDeleter.java:66)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cleanupUnclaimedContent(RdbRepositoryDataMediator.java:1211)
-------- chained exception -------
com.ibm.db2.jcc.am.SqlSyntaxErrorException: The data types of the operands for the operation "=" are not compatible or comparable.. SQLCODE=-401, SQLSTATE=42818, DRIVER=3.62.56
at com.ibm.db2.jcc.am.fd.a(fd.java:676)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:127)
at com.ibm.db2.jcc.am.jn.c(jn.java:2614)
at com.ibm.db2.jcc.am.jn.d(jn.java:2602)
at com.ibm.db2.jcc.am.kn.a(kn.java:3110)
at com.ibm.db2.jcc.t4.cb.a(cb.java:190)
at com.ibm.db2.jcc.t4.cb.b(cb.java:84)
at com.ibm.db2.jcc.t4.q.b(q.java:69)
at com.ibm.db2.jcc.t4.sb.c(sb.java:244)
at com.ibm.db2.jcc.am.kn.mc(kn.java:3101)
at com.ibm.db2.jcc.am.kn.pc(kn.java:3215)
at com.ibm.db2.jcc.am.kn.b(kn.java:3999)
at com.ibm.db2.jcc.am.kn.cc(kn.java:709)
at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:683)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:720)
at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.selectKeys(AbstractBackgroundDeleter.java:234)
at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.doIt(AbstractBackgroundDeleter.java:110)
at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.run(AbstractBackgroundDeleter.java:66)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cleanupUnclaimedContent(RdbRepositoryDataMediator.java:1211)
at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanup.doAllPendingItemCleanup(ItemCleanup.java:230)
at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanupService$1.run(ItemCleanupService.java:117)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:331)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(


IntrospectDepth set from:3 to: 4
Other related data. If null, nothing was passed in:null
IntrospectDepth reset to:3
IntrospectDepth set from:3 to: 5
The Objects' instance variables are printed below recursively 2 levels deep BEGIN:com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement@25692569
_______________________________________________________________________

First Failure Data Capture information for
com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement@25692569
_______________________________________________________________________

com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement@25692569

Underlying Statement: com.ibm.db2.jcc.am.kn@24102410
com.ibm.db2.jcc.am.kn@24102410

Statement properties have changed? true

Poolability hint: POOLABLE

key:
PSTMT: SELECT UUID FROM REPOSITORY.CONTENT_STORAGE WHERE CLAIMED = ? AND MODIFIED < ? 1003 1007 2 0 1

sql:
SELECT UUID FROM REPOSITORY.CONTENT_STORAGE WHERE CLAIMED = ? AND MODIFIED < ?

Wrapper State: