Full Data Collection Job error

Ivan Bogovic (93●1●14●11) | asked Nov 27 '12, 6:50 a.m.
edited Nov 27 '12, 6:53 a.m.

RTC Version:3.0.1.2

Error running WorkItems full data collection Job. Its seems like something is wrong in ccm configuration ("Connection to https://rtc01.zbo refused" from ccm-etl.log).

Can you please advice us how to fix this issue.

Regards,

Ivan

Log entry:

2012-11-21 14:47:46,029 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Finished Build WorkItemHistory at 21.11.12. 14:47. The build was successful***

2012-11-21 14:47:46,029 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Started Build WorkItemPreviousHistory at 21.11.12. 14:47***

2012-11-21 14:49:16,348 [ WebContainer : 8] ERROR e.workitem.internal.WorkItemsRemoteSnapshotService - com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: org.apache.http.conn.HttpHostConnectException: Connection to https://rtc01.zbo refused

java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: org.apache.http.conn.HttpHostConnectException: Connection to https://rtc01.zbo refused

at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2098)

at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next(BaseRDSResultSet.java:1469)

at com.ibm.team.datawarehouse.service.XdcResultSet.next(XdcResultSet.java:139)

at com.ibm.team.datawarehouse.service.workitem.internal.etlbuild.WorkItemPreviousHistory.execute(WorkItemPreviousHistory.java:83)

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

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

at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$4.run(RemoteDatabaseService.java:206)

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

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

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

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

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

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

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

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

at $Proxy86.write(Unknown Source)

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

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

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

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

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

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

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

at $Proxy1134.write(Unknown Source)

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

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

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

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

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

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

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

at $Proxy648.updateData(Unknown Source)

at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$5.run(InternalDataWarehouseService.java:696)

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

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

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

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

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

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

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

at $Proxy611.runAs(Unknown Source)

at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateSnapshotData(InternalDataWarehouseService.java:686)

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

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

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

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

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

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

at $Proxy612.updateSnapshotData(Unknown Source)

at com.ibm.team.reports.service.internal.ReportRestService.postUpdateSnapshotData(ReportRestService.java:1310)

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

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

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

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

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

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

at $Proxy954.postUpdateSnapshotData(Unknown Source)

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

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

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

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:504)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1869)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1725)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1634)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

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:831)

at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)

at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:76)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)

at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3935)

at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:931)

at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)

at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Selected: 3000

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Inserted: 0

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Records Updated: 3000

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Inserting: 0ms

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Updating: Less than 1ms

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Looking Up: 2 seconds

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Fetching Data: 1 minute 5 seconds

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: Time Running: 1 minute 30 seconds

2012-11-21 14:49:16,411 [ WebContainer : 8] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: ***Finished Build WorkItemPreviousHistory at 21.11.12. 14:49. The build was unsuccessful***

2012-11-21 14:49:16,413 [ WebContainer : 8] INFO e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: *****Finished Job Work Items at 21.11.12. 14:49. The job was unsuccessful.*****

2012-11-21 14:49:16,413 [ WebContainer : 8] INFO

e.workitem.internal.WorkItemsRemoteSnapshotService - ETL: *****Finished Job Work Items at 21.11.12. 14:49. The job was unsuccessful.*****

Symptoms:

Comments

Rafik Jaouani commented Dec 04 '12, 10:35 a.m. | edited Mar 27 '13, 1:02 a.m.

JAZZ DEVELOPER

Please check the ccm log file. Does the ETL fail always during WorkItemPreviousHistory Build?

Jhon Valderrama commented Mar 26 '13, 6:46 p.m.

Sorry i have the same problem do you resolved the problem?

One answer

Most liked answers ↓|Newest answers|Oldest answers

permanent link

Lauren Hayward Schaefer (3.3k●1●17●27) | answered Nov 28 '12, 7:11 a.m.
JAZZ DEVELOPER

Hi Ivan,

I'm not familiar with this error, but there are a couple of things you can check. First, be sure that you have the correct username and password entered in the Data Collection Jobs page. Second, be sure that your user has the Data Collector license assigned. Using the correct username and password with the Data Collector license assigned, you should be able to login.

I also found https://jazz.net/library/article/731/. I'm not sure if you're using that configuration? I looked at the work item, and the problem is now fixed.

Comments

Ivan Bogovic commented Dec 03 '12, 5:25 a.m.

HI, Lauren

Thank you for your answer. We have tried to run Full Data Collection job from Jazz admin account (Data collector license), and that didn't fix the problem. All other Full data collection jobs working fine accept Work Items.

Can you be more specific about "correct username and password entered in the Data Collection Jobs page".

Regards,

Ivan

Lauren Hayward Schaefer commented Dec 26 '12, 7:46 a.m.

JAZZ DEVELOPER

Hi Ivan,
To check the correct username and password are being used, log in to your server https://yourserver/ccm/web. Click the gear icon in the upper-right corner and select Manage Reports. The Data Collection Jobs page should then load. Be sure that the correct username and password are typed in the Work Items row.

Jhon Valderrama commented Mar 26 '13, 6:43 p.m.

https://jazz.net/library/article/731/ this article dont exists

Geoffrey Clemm commented Mar 27 '13, 1:03 a.m.

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Delete the trailing characters from the URL ... i.e. it should be:
https://jazz.net/library/article/731

Lauren Hayward Schaefer commented Mar 27 '13, 6:35 a.m.

JAZZ DEVELOPER

https://jazz.net/library/article/731/

Your answer

Register or log in 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.

It's all about the answers!

Related questions

Full Data Collection Job error

One answer

Your answer