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 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 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. 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 |
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.
|
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
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.