New errors and warning in jazz.log
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.
Paul Sims
IBM WebSphere Commerce
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)
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
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
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
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)
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
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
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
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.
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
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?
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?