It's all about the answers!

Ask a question

CCM work items data collection job status not displayed and error on ccm etl log file


marina delunas (711316) | asked Sep 09 '14, 5:02 a.m.
Hello,
I have clm 4.0.3 on Websphere and DB2 environment (linux OS).

On ccm data collection jobs status I not see the work items data collections job and on ccm tl log file I found this error.

Someone can help me? Thanks!!

2014-09-09 01:22:04,415 [ccm: AsynchronousTaskRunner-1 @@ 00:03] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: ***Started Build WorkItemCustomAttr at 9/9/14 1:22 AM***

2014-09-09 01:32:08,021 [ccm: AsynchronousTaskRunner-1 @@ 00:03] ERROR e.workitem.internal.WorkItemsRemoteSnapshotService  - [jcc][t4][2030][11211][4.14.121] A communication error occurred during operations on the connection's underlying socket, socket input stream,

or socket output stream.  Error location: Reply.fill() - socketInputStream.read (-1).  Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001

com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.14.121] A communication error occurred during operations on the connection's underlying socket, socket input stream,

or socket output stream.  Error location: Reply.fill() - socketInputStream.read (-1).  Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001

                at com.ibm.db2.jcc.am.ed.a(ed.java:320)

                at com.ibm.db2.jcc.t4.a.a(a.java:546)

                at com.ibm.db2.jcc.t4.a.a(a.java:541)

                at com.ibm.db2.jcc.t4.x.b(x.java:301)

                at com.ibm.db2.jcc.t4.x.c(x.java:360)

                at com.ibm.db2.jcc.t4.x.c(x.java:473)

                at com.ibm.db2.jcc.t4.x.v(x.java:1241)

                at com.ibm.db2.jcc.t4.ab.d(ab.java:54)

                at com.ibm.db2.jcc.t4.p.c(p.java:44)

                at com.ibm.db2.jcc.t4.qb.j(qb.java:147)

                at com.ibm.db2.jcc.am.oo.kb(oo.java:2158)

                at com.ibm.db2.jcc.am.po.b(po.java:4483)

                at com.ibm.db2.jcc.am.po.hc(po.java:756)

                at com.ibm.db2.jcc.am.po.executeQuery(po.java:725)

                at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:62)

                at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:80)

                at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:59)

                at com.ibm.team.datawarehouse.service.workitem.internal.etlbuild.WorkItemCustomAttr.processRecord(WorkItemCustomAttr.java:234)

                at com.ibm.team.datawarehouse.service.workitem.internal.etlbuild.WorkItemCustomAttr.execute(WorkItemCustomAttr.java:175)

                at com.ibm.team.datawarehouse.service.workitem.internal.WorkItemsRemoteSnapshotService.updateSnapshotWithCheckpoint(WorkItemsRemoteSnapshotService.java:460)

                at com.ibm.team.datawarehouse.service.workitem.internal.WorkItemsRemoteSnapshotService.updateSnapshot(WorkItemsRemoteSnapshotService.java:203)

                at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:199)

                at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$6.run(RemoteDatabaseService.java:523)

                at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:434)

                at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:485)

                at sun.reflect.GeneratedMethodAccessor1771.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

                at java.lang.reflect.Method.invoke(Method.java:611)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

                at $Proxy112.write(Unknown Source)

                at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)

                at sun.reflect.GeneratedMethodAccessor1770.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

                at java.lang.reflect.Method.invoke(Method.java:611)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

                at $Proxy2035.write(Unknown Source)

                at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService.updateData(AbstractRemoteSnapshotService.java:194)

                at sun.reflect.GeneratedMethodAccessor2127.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

                at java.lang.reflect.Method.invoke(Method.java:611)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

                at $Proxy982.updateData(Unknown Source)

                at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$7.run(InternalDataWarehouseService.java:822)

                at com.ibm.team.repository.service.internal.permission.ImpersonationService.runAs(ImpersonationService.java:75)

                at sun.reflect.GeneratedMethodAccessor1883.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

                at java.lang.reflect.Method.invoke(Method.java:611)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

                at $Proxy802.runAs(Unknown Source)

                at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateRemoteSnapshotDataFromTask(InternalDataWarehouseService.java:802)

                at sun.reflect.GeneratedMethodAccessor1882.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

                at java.lang.reflect.Method.invoke(Method.java:611)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

                at $Proxy860.updateRemoteSnapshotDataFromTask(Unknown Source)

                at com.ibm.team.datawarehouse.service.internal.SnapshotRunnerTask.transactionSucceeded(SnapshotRunnerTask.java:58)

                at sun.reflect.GeneratedMethodAccessor909.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

                at java.lang.reflect.Method.invoke(Method.java:611)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)

                at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

                at $Proxy877.transactionSucceeded(Unknown Source)

                at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.transactionSucceeded(AsynchronousTaskSchedulerService.java:972)

                at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.executeTask(AsynchronousTaskSchedulerService.java:981)

                at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:158)

                at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:119)

                at java.lang.Thread.run(Thread.java:769)

Caused by: java.net.SocketException: Connection reset

                at java.net.SocketInputStream.read(SocketInputStream.java:179)

                at com.ibm.db2.jcc.t4.x.b(x.java:208)

                ... 74 more

2014-09-09 01:32:08,022 [ccm: AsynchronousTaskRunner-1 @@ 00:03] ERROR e.workitem.internal.WorkItemsRemoteSnapshotService  - [jcc][t4][10335][10366][4.14.121] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003

com.ibm.team.repository.common.TeamRepositoryException: [jcc][t4][10335][10366][4.14.121] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003

                at com.ibm.team.datawarehouse.service.db2.internal.DB2DataWarehouseDbProvider.updateStatistics(DB2DataWarehouseDbProvider.java:216)


Be the first one to answer this question!


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.