It's all about the answers!

Ask a question

New errors and warning in jazz.log


Paul Sims (31513421) | asked Nov 20 '08, 8:47 a.m.
I came across new exceptions I haven't seen before when I reviewed jazz.log this morning. How will these manifest themselves to end users? I'm more concerned about the errors that occurred when the data warehouse task ran. I assume these will affect data capture and the burn-down chart. Here are the details.

Paul Sims
IBM WebSphere Commerce

17:47:19,046 ERROR ository.service.internal.RdbRepositoryDataMediator - CRJAZ1033I Failed to fetch content _ehllQLWHEd28oZ7zdbW4wQ.
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0369I Error processing row
row = 1

at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:256)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:199)
at com.ibm.team.repository.service.internal.db.filestorage.ContentStorage.visitContentById(ContentStorage.java:463)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fetchContent(RdbRepositoryDataMediator.java:1060)
at com.ibm.team.repository.service.internal.ContentService.doRetrieveContent(ContentService.java:1141)
at com.ibm.team.repository.service.internal.ContentService.access$8(ContentService.java:1134)
at com.ibm.team.repository.service.internal.ContentService$1.run(ContentService.java:385)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInReadUncommittedTransaction(RepositoryDatabase.java:252)
at com.ibm.team.repository.service.internal.TransactionService.runReadUncommittedTransaction(TransactionService.java:79)
at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy34.runReadUncommittedTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.ContentService.retrieveContent(ContentService.java:382)
at sun.reflect.GeneratedMethodAccessor102.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy55.retrieveContent(Unknown Source)
at com.ibm.team.apt.internal.service.rest.MemberPhotoService.perform_GET(MemberPhotoService.java:68)
at com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:81)
at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy98.service(Unknown Source)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doRestService(AbstractTeamServerServlet.java:836)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1431)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0895I Failed to move the content to an output stream for the content "StoredContent(_ehllQLWHEd28oZ7zdbW4wQ, image/jpeg, 15360, None, HashCode(0x8b0fa02f))".

at com.ibm.team.repository.service.internal.ContentService$ContentDirectToStream.receiveContent(ContentService.java:2054)
at com.ibm.team.repository.service.internal.db.filestorage.ContentStorage$1.processRow(ContentStorage.java:460)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:253)
... 59 more
Caused by:
ClientAbortException: java.net.SocketException: Connection reset by peer: socket write error

at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:366)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:432)
at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:398)
at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:381)
at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:89)
at com.ibm.team.repository.service.internal.ContentService.pump(ContentService.java:1191)
at com.ibm.team.repository.service.internal.ContentService.pumpFromContent(ContentService.java:1247)
at com.ibm.team.repository.service.internal.ContentService.access$2(ContentService.java:1243)
at com.ibm.team.repository.service.internal.ContentService$ContentDirectToStream.receiveContent(ContentService.java:2051)
... 61 more
Caused by:
java.net.SocketException: Connection reset by peer: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:105)
at java.net.SocketOutputStream.write(SocketOutputStream.java:149)
at com.ibm.jsse2.c.a(c.java:44)
at com.ibm.jsse2.c.a(c.java:98)
at com.ibm.jsse2.jc.a(jc.java:559)
at com.ibm.jsse2.j.write(j.java:10)
at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:747)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:432)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:347)
at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:770)
at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:126)
at org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:580)
at org.apache.coyote.Response.doWrite(Response.java:560)
at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:361)
... 69 more
00:00:00,031 WARN sqlExceptionLogger - CRJAZ0250I A violation of the constraint imposed by a unique index or a unique constraint occurred.
SQL: INSERT INTO COMMON_SNAPSHOT.TABLE_TBL (FACT_ID, SNAPSHOT_ID, TABLE_NAME, TOTAL_SIZE, ROW_COUNT) VALUES (?, ?, ?, ?, ?)
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL
SQL State: 23505
Error Code: -803

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL

at com.ibm.db2.jcc.c.kh.b(kh.java:1367)
at com.ibm.db2.jcc.c.kh.c(kh.java:1354)
at com.ibm.db2.jcc.b.db.k(db.java:352)
at com.ibm.db2.jcc.b.db.a(db.java:60)
at com.ibm.db2.jcc.b.t.a(t.java:52)
at com.ibm.db2.jcc.b.tb.b(tb.java:202)
at com.ibm.db2.jcc.c.lh.X(lh.java:1842)
at com.ibm.db2.jcc.c.lh.d(lh.java:2411)
at com.ibm.db2.jcc.c.lh.U(lh.java:1401)
at com.ibm.db2.jcc.c.lh.execute(lh.java:1385)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:742)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.access$1(AbstractSnapshotService.java:675)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService$2.run(AbstractSnapshotService.java:391)
at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService$6.run(DataWarehouseAdminService.java:452)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:241)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy34.runInTransaction(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService.write(DataWarehouseAdminService.java:449)
at sun.reflect.GeneratedMethodAccessor302.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy65.write(Unknown Source)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.write(AbstractSnapshotService.java:263)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:388)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1198)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1182)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateData(AbstractSnapshotService.java:119)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy189.updateData(Unknown Source)
at com.ibm.team.datawarehouse.service.AbstractSnapshotTask.run(AbstractSnapshotTask.java:79)
at com.ibm.team.datawarehouse.service.AbstractExclusiveTask.runTask(AbstractExclusiveTask.java:38)
at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:88)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy190.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:810)
00:00:00,062 ERROR com.ibm.team.datawarehouse - Error inserting in table TABLE
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL

at com.ibm.db2.jcc.c.kh.b(kh.java:1367)
at com.ibm.db2.jcc.c.kh.c(kh.java:1354)
at com.ibm.db2.jcc.b.db.k(db.java:352)
at com.ibm.db2.jcc.b.db.a(db.java:60)
at com.ibm.db2.jcc.b.t.a(t.java:52)
at com.ibm.db2.jcc.b.tb.b(tb.java:202)
at com.ibm.db2.jcc.c.lh.X(lh.java:1842)
at com.ibm.db2.jcc.c.lh.d(lh.java:2411)
at com.ibm.db2.jcc.c.lh.U(lh.java:1401)
at com.ibm.db2.jcc.c.lh.execute(lh.java:1385)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:742)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.access$1(AbstractSnapshotService.java:675)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService$2.run(AbstractSnapshotService.java:391)
at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService$6.run(DataWarehouseAdminService.java:452)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:241)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy34.runInTransaction(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService.write(DataWarehouseAdminService.java:449)
at sun.reflect.GeneratedMethodAccessor302.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy65.write(Unknown Source)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.write(AbstractSnapshotService.java:263)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:388)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1198)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1182)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateData(AbstractSnapshotService.java:119)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy189.updateData(Unknown Source)
at com.ibm.team.datawarehouse.service.AbstractSnapshotTask.run(AbstractSnapshotTask.java:79)
at com.ibm.team.datawarehouse.service.AbstractExclusiveTask.runTask(AbstractExclusiveTask.java:38)
at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:88)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy190.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:810)
01:02:39,687 INFO ice.internal.userregistry.ldap.LDAPNightlySyncTask - LDAP Nightly Sync Task ran for 160125 ms.
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:742)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.access$1(AbstractSnapshotService.java:675)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService$2.run(AbstractSnapshotService.java:391)
at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService$6.run(DataWarehouseAdminService.java:452)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:241)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy34.runInTransaction(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService.write(DataWarehouseAdminService.java:449)
at sun.reflect.GeneratedMethodAccessor302.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy65.write(Unknown Source)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.write(AbstractSnapshotService.java:263)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:388)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1198)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1182)
at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateData(AbstractSnapshotService.java:119)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy189.updateData(Unknown Source)
at com.ibm.team.datawarehouse.service.AbstractSnapshotTask.run(AbstractSnapshotTask.java:79)
at com.ibm.team.datawarehouse.service.AbstractExclusiveTask.runTask(AbstractExclusiveTask.java:38)
at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:88)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy190.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:810)
01:02:39,687 INFO ice.internal.userregistry.ldap.LDAPNightlySyncTask - LDAP Nightly Sync Task ran for 160125 ms.

4 answers



permanent link
Dmitry Karasik (1.8k11) | answered Nov 20 '08, 8:47 a.m.
JAZZ DEVELOPER
I came across new exceptions I haven't seen before when I reviewed
jazz.log this morning. How will these manifest themselves to end users?

The 1st exception means a client disconnected before the server could
send the entire content to it. It is harmless (at least from the server's
perspective).

- Dmitry

permanent link
Paul Sims (31513421) | answered Nov 20 '08, 9:28 a.m.
About an hour after I posted this thread, the server crashed with no errors in jazz.log. The command prompt window was closed when I connected to the server.

Are there other logs I can check for information about why the server crashed abruptly?

I would also appreciate someone commenting on the DB2 SQL error.

00:00:00,031 WARN sqlExceptionLogger - CRJAZ0250I A violation of the constraint imposed by a unique index or a unique constraint occurred.
SQL: INSERT INTO COMMON_SNAPSHOT.TABLE_TBL (FACT_ID, SNAPSHOT_ID, TABLE_NAME, TOTAL_SIZE, ROW_COUNT) VALUES (?, ?, ?, ?, ?)
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL
SQL State: 23505
Error Code: -803

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL


Paul Sims
IBM WebSphere Commerce

permanent link
Justin Hill (66) | answered Nov 20 '08, 2:52 p.m.
JAZZ DEVELOPER
It the integrity constraint error is caused by the insertion of something with the same primary key twice. It could be caused by a retry.

permanent link
Jan Vogel (21) | answered Jun 06 '11, 10:36 a.m.
While investigation the CCM logs on our servers, the following error popped up, with varying tables and primary keys:

ERROR com.ibm.team.repository - CRJAZ0852I An exception occurred while executing the task "com.ibm.team.scm.monitorScrub", contributed by component "com.ibm.team.repository". The task will be removed from the schedule.
com.ibm.team.repository.common.InternalRepositoryException: Deferred operation failed
Caused by:
com.ibm.team.repository.common.TeamRepositoryException: deferred delete failed
Caused by:
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0343I Executing executeBatch failed. The number of results returned was "128". SQL Message: Violation of PRIMARY KEY constraint 'DELETED_ITEMS_PK'. Cannot insert duplicate key in object 'REPOSITORY.DELETED_ITEMS'.
Caused by:
java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'DELETED_ITEMS_PK'. Cannot insert duplicate key in object 'REPOSITORY.DELETED_ITEMS'.
ERROR ry.jdbcdriver.internal.sqlserver.SqlServerProvider - !SqlServerProvider.StatisticsDisabled!

The above example shows the primary key violation for DELETED_ITEMS_PK in the REPOSITORY.DELETED_ITEMS object, a similar error also appears for index SCM_CNFGRTNCHNGHSTRTMD in the SCM.CONFIGURATION object.

In both cases, the task "com.ibm.team.scm.monitorScrub" is at the start of the error, and in both cases the task is disabled, effectively preventing any new similar errors to appear on the same server.

Now I assume this task is scheduled for a good reason, and errors like this should not happen. Seeing this error twice (similar) appears to be pointing at a generic issue regarding database use by CCM.

We're running CCM 3.0 iFix 1. Has anyone here encountered similar issues and has any clue how to resolve/prevent this from happening?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.