Quality Management job in DCC fails
Hello,
My DCC job fails with this error (weird error)
Does someone hava any idea on how to resolve it ?
Thanks for the help
My DCC job fails with this error (weird error)
04/03/2015 13:58:07,264 [dcc_etl_RQM_ODS_RQMResourceGroup0_consumer_0] ERROR CRRCD4602E The real value of the VALUE column of the RQM_Category mapping table and the RIODS."TEST_CATEGORY" database table cannot be retrieved. Check the current incoming row values: {/content/category/categoryType/@href=null : false, /archived=true : false, /purged=true : false, /id=_z7hi4klLEeSAEuuHhdrDFw : false, /content/category/title=null : false}04/03/2015 13:58:07,264 [dcc_etl_RQM_ODS_RQMResourceGroup0_consumer_0] ERROR 04/03/2015 13:58:07,264 [dcc_etl_RQM_ODS_RQMResourceGroup0_resource_0] ERROR CRRCD4302E The RQM_Category_R : /secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/category?etlmode=true&includeArchived=true : /feed/entry resource was retrieved, but not transformed and loaded into the data warehouse.java.util.concurrent.ExecutionException: com.ibm.rational.datacollection.etl.exception.ETLException: CRRCD4600E The retrieved resources could not be processed because of an error. at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:233) at java.util.concurrent.FutureTask.get(FutureTask.java:94) at com.ibm.rational.datacollection.etl.tasks.ETLSubTask.call(ETLSubTask.java:229) at com.ibm.rational.datacollection.etl.tasks.ETLSubTask.call(ETLSubTask.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:314) at java.util.concurrent.FutureTask.run(FutureTask.java:149) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:908) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:931) at java.lang.Thread.run(Thread.java:773)Caused by: com.ibm.rational.datacollection.etl.exception.ETLException: CRRCD4600E The retrieved resources could not be processed because of an error. at com.ibm.rational.datacollection.etl.consumer.DataConsumer.call(DataConsumer.java:326) at com.ibm.rational.datacollection.etl.consumer.DataConsumer.call(DataConsumer.java:1) ... 5 moreCaused by: com.ibm.rational.datacollection.etl.exception.ETLException: at com.ibm.rational.datacollection.etl.utils.ETLExecutionUtil.generateOutRow(ETLExecutionUtil.java:1376) at com.ibm.rational.datacollection.etl.utils.ETLExecutionUtil.executePreparedStatement(ETLExecutionUtil.java:156) at com.ibm.rational.datacollection.etl.consumer.DataConsumer.call(DataConsumer.java:297) ... 6 moreCaused by: java.lang.NullPointerException at com.ibm.rational.datacollection.etl.utils.ETLExecutionUtil.getValueFromLocalTranfomArtifactDeletedIfPurged(ETLExecutionUtil.java:2238) at com.ibm.rational.datacollection.etl.utils.ETLExecutionUtil.getLocalTransformValue(ETLExecutionUtil.java:806) at com.ibm.rational.datacollection.etl.utils.JDBCUtil.getRealValue(JDBCUtil.java:1733) at com.ibm.rational.datacollection.etl.utils.ETLExecutionUtil.generateOutRow(ETLExecutionUtil.java:1360) ... 8 more04/03/2015 13:58:07,491 [dcc_etl_RQM_ODS_RQMResourceGroup0] ERROR CRRCD4309E The java.util.concurrent.ExecutionException: com.ibm.rational.datacollection.etl.exception.ETLException: CRRCD4302E The RQM_Category_R : /secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/category?etlmode=true&includeArchived=true : /feed/entry resource was retrieved, but not transformed and loaded into the data warehouse. resource was retrieved, but cannot be transformed and loaded.04/03/2015 13:58:07,491 [dcc_etl_RQM_ODS_RQMResourceGroup0] INFO CRRCD3100I The fetcher thread pool executor is shut down successfully. 04/03/2015 13:58:07,491 [dcc_etl_RQM_ODS_RQMResourceGroup0] INFO CRRCD3100I The consumer thread pool executor is shut down successfully. 04/03/2015 13:58:07,491 [dcc_etl_RQM_ODS_RQMResourceGroup0] INFO CRRCD3100I The fetcher thread pool executor is shut down successfully. 04/03/2015 13:58:07,491 [dcc_etl_RQM_ODS_RQMResourceGroup0] ERROR com.ibm.rational.datacollection.etl.exception.ETLException: CRRCD4516E This SQL statement cannot be execute: SELECT MODIFIEDSINCE, LOADTYPE FROM CONFIG.DCS_ETL_INFO WHERE RESGROUP_ID='c45567e4bce514030d0dc7174f92f21a' AND RESOURCE_ID='22d5b86e0052a34419b8aaa78969dc82'. at com.ibm.rational.datacollection.etl.utils.JDBCUtil.getResourceModifiedSince(JDBCUtil.java:453) at com.ibm.rational.datacollection.etl.tasks.ETLTask.call(ETLTask.java:103) at com.ibm.rational.datacollection.etl.tasks.ETLTask.call(ETLTask.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:314) at java.util.concurrent.FutureTask.run(FutureTask.java:149) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:908) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:931) at java.lang.Thread.run(Thread.java:773)Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: [jcc][t4][10335][10366][4.17.28] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 at com.ibm.db2.jcc.am.fd.a(fd.java:737) at com.ibm.db2.jcc.am.fd.a(fd.java:66) at com.ibm.db2.jcc.am.fd.a(fd.java:128) at com.ibm.db2.jcc.am.Connection.checkForClosedConnection(Connection.java:5873) at com.ibm.db2.jcc.am.Connection.createStatementX(Connection.java:2281) at com.ibm.db2.jcc.am.Connection.createStatementX(Connection.java:910) at com.ibm.db2.jcc.am.Connection.createStatement(Connection.java:902) at com.ibm.rational.datacollection.etl.utils.JDBCUtil.getResourceModifiedSince(JDBCUtil.java:446) ... 7 more
Does someone hava any idea on how to resolve it ?
Thanks for the help
2 answers
Besides this:
java.lang.Thread.run(Thread.java:773)Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: [jcc][t4][10335][10366][4.17.28] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 at
You might want to check db2 diagnostic log ( db2diag -help for tips ). DB2 server doesn't give an explanation of this error code ( db2 \? SQL4470 for example ).
Beyond that searching the wild-wild-web leads one to think this would be a client side ( DCC ) issue.
java.lang.Thread.run(Thread.java:773)Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: [jcc][t4][10335][10366][4.17.28] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 at
You might want to check db2 diagnostic log ( db2diag -help for tips ). DB2 server doesn't give an explanation of this error code ( db2 \? SQL4470 for example ).
Beyond that searching the wild-wild-web leads one to think this would be a client side ( DCC ) issue.
Comments
Matthew Owenby
Apr 10 '15, 9:22 a.m.Gustavo Reis
May 15 '15, 8:25 a.m.