Quality Management job in DCC fails
![]()
Hello,
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
![]()
It is likely you are hitting the defect:
https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=132924 The best way is to contact client support in order to collect further log files and test result to determine if it is the same issue or not. |
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.
Comments
Did this ever get resolved? I am experiencing the same issue in my RQM instance.
Same problem here.