It's all about the answers!

Ask a question

Quality Management job keep failing on QM 4.0


Qaiser Islam (31286974) | asked Sep 19 '12, 7:59 a.m.
Hi,

I have setup RTC/RQM 4.0 on windows 2k3 64 bit with DB2 9.7. the problem is that Quality Management job is keep failing. the remaining two jobs (Common and Work Items) are running fine.I checked the log and the error is java.sql.SQLException: CRRRE1202E: No row is selected.

below is the few lines from log file



2012-09-19 11:37:37,873 [             WebContainer : 20]  INFO com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQM4CustomAttributeETL:execute AQXRE0001I Executing Java ETL Info: Total Records Selected = 0
2012-09-19 11:37:37,873 [             WebContainer : 20]  INFO com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQM4CustomAttributeETL:execute AQXRE0001I Executing Java ETL Info: Total Records Inserted into DataWarehouse = 0
2012-09-19 11:37:37,873 [             WebContainer : 20]  INFO com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQM4CustomAttributeETL:execute AQXRE0001I Executing Java ETL Info: Total Records Updated in DataWarehouse = 0
2012-09-19 11:37:37,873 [             WebContainer : 20]  INFO com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQM4CustomAttributeETL:execute AQXRE0001I Executing Java ETL Info: Total Records Ignoted in DataWarehouse = 0
2012-09-19 11:37:37,873 [             WebContainer : 20]  INFO com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQM4CustomAttributeETL:execute AQXRE0001I Executing Java ETL Info: ***********End to execute the Java ETL of com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQM4CustomAttributeETL*****  Of ****** QM002_JKEBankingQualityManagement::_grQbwv2dEeGgl_qGtZzJxA********************
2012-09-19 11:37:37,873 [             WebContainer : 20]  INFO com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.RemoteRQMSnapshotService:updateSnapshot AQXRE0001I Executing Java ETL Info: ******com.ibm.team.datawarehouse.service.rqm.internal.RemoteRQMSnapshotService*****The job com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQM4CustomAttributeETL has failed.
2012-09-19 11:37:37,873 [             WebContainer : 20]  INFO com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQMTestCaseRelaLookupETL:execute AQXRE0001I Executing Java ETL Info: ***********Start to execute the Java ETL of com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQMTestCaseRelaLookupETL*****  Of ****** QM002_JKEBankingQualityManagement::_grQbwv2dEeGgl_qGtZzJxA********************
2012-09-19 11:37:55,810 [             WebContainer : 20] ERROR com.ibm.team.datawarehouse.service.rqm              - class com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQMTestCaseRelaLookupETL:execute AQXRE5002E Artifact data was not pulled into the reporting data warehouse because of the following exception: CRRRE1202E: No row is selected.
java.sql.SQLException: CRRRE1202E: No row is selected.
    at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.findColumn(BaseRDSResultSet.java:222)
    at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.getString(BaseRDSResultSet.java:1203)
    at com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.RQMTestCaseRelaLookupETL.execute(RQMTestCaseRelaLookupETL.java:105)
    at com.ibm.team.datawarehouse.service.rqm.internal.RemoteRQMSnapshotService.updateSnapshot(RemoteRQMSnapshotService.java:467)
    at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:211)
    at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$5.run(RemoteDatabaseService.java:254)
    at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:381)
    at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:244)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:600)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy8745.write(Unknown Source)
    at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)
    at sun.reflect.GeneratedMethodAccessor642.invoke(Unknown Source)
   

5 answers



permanent link
Mark Victory (26635) | answered Sep 19 '12, 8:20 a.m.
JAZZ DEVELOPER
HI,

Where and how are you running the Data Collection jobs?
From JTS/Admin Reports?

Comments
Seth Packham commented Sep 19 '12, 9:04 a.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER

Hi Mark, when not answering the question, it is a good practice to use the "comment" mechanism, rather than "answer" mechanism, so the questions doesn't appear to have been answered in the question list.


Mark Victory commented Sep 19 '12, 9:07 a.m.
JAZZ DEVELOPER

Thanks Seth. I didn't even realize there was a Comment vs Answer section. I will use Comments in the future.


permanent link
Qaiser Islam (31286974) | answered Sep 19 '12, 8:23 a.m.
i have tried both ..from JTS/Admin Reports and QA/Admin Reports. Same result

permanent link
Mark Victory (26635) | answered Sep 19 '12, 8:30 a.m.
JAZZ DEVELOPER
Are there any errors in the JTS jobs or only in the QM job?

permanent link
Qaiser Islam (31286974) | answered Sep 19 '12, 8:36 a.m.
All the JTS jobs are running fine, also one CCM job (Build) is also failing, the log says


2012-09-19 14:34:07,937 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2012-09-19 14:34:07,937 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Running: Less than 1ms
2012-09-19 14:34:07,937 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: ***Finished Build JUnitEventsBulkMove at 9/19/12 2:34 PM. The build was successful***
2012-09-19 14:34:07,937 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: ***Started Build JUnitResultsBulkMove at 9/19/12 2:34 PM***
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Records Selected: 0
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Records Inserted: 0
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Records Updated: 0
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Inserting: 0ms
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Updating: 0ms
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Looking Up: 0ms
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Fetching Data: 0ms
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Running: Less than 1ms
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: ***Finished Build JUnitResultsBulkMove at 9/19/12 2:34 PM. The build was successful***
2012-09-19 14:34:08,031 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: ***Started Build BuildResult at 9/19/12 2:34 PM***
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Records Selected: 14
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Records Inserted: 0
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Records Updated: 14
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Inserting: 0ms
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Updating: Less than 1ms
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Looking Up: Less than 1ms
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: Time Running: Less than 1ms
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: ***Finished Build BuildResult at 9/19/12 2:34 PM. The build was successful***
2012-09-19 14:34:08,718 [             WebContainer : 22] DEBUG .service.build.internal.BuildRemoteSnapshotService  - ETL: ***Started Build CompilationResult at 9/19/12 2:34 PM***
2012-09-19 14:34:33,453 [             WebContainer : 22] ERROR .service.build.internal.BuildRemoteSnapshotService  - com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '500' and the message is 'Internal Server Error'.
java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '500' and the message is 'Internal Server Error'.
    at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2101)
    at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next(BaseRDSResultSet.java:1472)
    at com.ibm.team.datawarehouse.service.XdcResultSet.next(XdcResultSet.java:176)
    at com.ibm.team.datawarehouse.service.build.internal.etlbuild.CompilationResult.execute(CompilationResult.java:94)
    at com.ibm.team.datawarehouse.service.build.internal.BuildRemoteSnapshotService.updateSnapshot(BuildRemoteSnapshotService.java:101)
    at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:211)


Comments
Mark Victory commented Sep 19 '12, 9:39 a.m.
JAZZ DEVELOPER

The CCM AUthenticationException typically means that the user/password for the job is incorrect. Are there any AuthenticationException errors in the qm-etl.log?


Qaiser Islam commented Sep 19 '12, 11:13 a.m.

no i could not find any authentication exception in qm-etl.log. moreover while i was setting up the DW, i left the user id and password field blank and let the setup to create the required user. so presumably same authentication parameters are being used for all the jobs. as rest of the job running fine, is there any special consideration for Quality Management and Build job?


permanent link
Qaiser Islam (31286974) | answered Sep 21 '12, 10:41 a.m.
seems the problem has been resolved by assigning data collection license to data collection user. While setting up the DW i did not provide the userid/pwd for data collection user. i think it was mentioned that if you dont provide anything setup will automatically create the user and assign the appropriate CAL. but in my case it did not happen. Is it defect or i misunderstood the instruction?

Your answer


Register or to post your answer.