Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Quality Management job keep failing on QM 4.0

Questions
Tags
Users
Badges
Qaiser Islam
(312●9●70●74) 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)
   

0 votes

5 answers
5,229 views
0 votes

5 answers

Permanent link
Mark Victory
JAZZ DEVELOPER (266●3●5) Sep 19 '12, 8:20 a.m.
HI,

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

0 votes

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

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
JAZZ DEVELOPER Sep 19 '12, 9:07 a.m.

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
(312●9●70●74) Sep 19 '12, 8:23 a.m.
i have tried both ..from JTS/Admin Reports and QA/Admin Reports. Same result

0 votes

Permanent link
Mark Victory
JAZZ DEVELOPER (266●3●5) Sep 19 '12, 8:30 a.m.
Are there any errors in the JTS jobs or only in the QM job?

0 votes

Permanent link
Qaiser Islam
(312●9●70●74) 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)

0 votes

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

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
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
(312●9●70●74) 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?

0 votes

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Sep 19 '12, 7:59 a.m.

Question was seen: 5,229 times

Last updated: Sep 21 '12, 10:41 a.m.

Confirmation Cancel Confirm