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
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. Comments
Sany Maamari
commented Apr 03 '15, 9:34 a.m.
Hi Kevin,
As the error specifically mentions "connection is closed", maybe too many connections were made/attempted versus the database configuration ( MAXAPPLS ). That's where the db2 diagnostics may help.
Sany Maamari
commented Apr 03 '15, 10:43 a.m.
Ok,
Kevin Ramer
commented Apr 03 '15, 11:18 a.m.
Well, I've no DCC installed (yet)... My understanding is that collections are supposed to run at various times (rather than the once / day of the data warehouse jobs), so I'm not much beyond what I've already mentioned.
Sany Maamari
commented Apr 07 '15, 3:38 a.m.
Hi Kevin,
Well yes, all the other jobs succeed, only some of the QM jobs fails (2 out of 3). I think that it is defect in RQM that makes the DCC jobs fail to proceed. From my point of view, the defect in RQM is in removed but undeleted Keywords in test scripts. I'm telling this because for some test scripts that uses Keywords, I'm unable to duplicate them for a reason that I don't understand well.
|
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.