It's all about the answers!

Ask a question

Full Data Collection Job error


Ivan Bogovic (931211) | 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



permanent link
Lauren Hayward Schaefer (3.3k11127) | 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 to post your answer.