Troubleshooting
Problem
The QM ETL data collection jobs fail with IBM Rational Quality Manager (RQM).
Symptom
You see entries similar to this in qm-etl.log:
RQMPriorityETL:execute AQXRE5002E Artifact data was not pulled into the reporting data warehouse because of the following exception: com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: Content is not allowed in prolog.
java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: Content is not allowed in prolog.
The data collection job "Quality Management" always fails even though the collection user has the QM collection license and the Quality Manager client license, is in JazzAdmins group and is also a member of the QM project. The ID can be used to login qm/admin as well to run jobs.
These 3 jobs are not affected: Common, Repository and Work Items.
Alternatively, the qm-etl.log shows the following error:
2013-01-04 22:02:44,111 [ WebContainer : 12] ERROR com.ibm.team.datawarehouse.service.rqm - RemoteRQMSnapshotService:updateSnapshot AQXRE5002E Artifact data was not pulled into the reporting data warehouse because of the following exception: An exception has occurred during ETL Job execution. ETL job terminating with following error message: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 '401' and the message is 'Unauthorized'. The user may not have privilege to access the project area or the username or password may be incorrect or ETL user does not have Data Collector license or Jazz Admin privilege.
Here is another error that might appear:
2013-09-24 00:03:12,142 [qm: AsynchronousTaskRunner-3 @@ 00:02] ERROR com.ibm.team.datawarehouse.service.rqm - RemoteRQMSnapshotService:runODS AQXRE5002E Artifact data was not pulled into the reporting data warehouse because of the following exception: An exception has occurred during ETL Job execution. ETL job terminating with following error message: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 '403' and the message is 'Forbidden'. The user may not have privilege to access the project area or the username or password may be incorrect or ETL user does not have Data Collector license or Jazz Admin privilege...
at com.ibm.team.datawarehouse.service.rqm.internal.etlbuild.AbstractRQMETLBuild.logDetailsForError(AbstractRQMETLBuild.java:70)
The job might run for other projects.
Cause
The fronting Proxy server configuration with IBM HTTP Server or Apache HTTP is changing the URLs. This was reported as a defect under APAR PM81427.
Environment
- You have configured the ETL jobs to run with oAuth (JTS) authentication.
- You have an HTTP fronting server or reverse proxy such as Apache HTTP or IBM HTTP Server.
To check which server it is, enter the following in a browser:
http://<server_name> or https://<server_name>
Diagnosing The Problem
There is an extra setup step for the QM documentation for the fronting IBM HTTP Server (IHS) for the CLM distributed environments. If you do not perform setup with the required steps, the QM ETL fails. The QM ETL issue is caused by missing the configuration in the IBM HTTP Server as mentioned in this document:
https://jazz.net/forum/questions/98087/qm-401-data-collection-job-quality-management-consistently-fails
Resolving The Problem
Complete these steps with IBM HTTP Server:
- Add "SetEnv websphere-nocanon 1" to httpd.conf
- Put the 'SetEnv websphere-nocanon 1' in the Global section of the httpd.conf file
- Going to the IHS httpd.conf file and add the setting (be sure to restart the HTTP server).
Reference: http://publib.boulder.ibm.com/httpserv/ihsdiag/plugin_questions.html#plugindecode
Complete these steps with Apache Mod Proxy:
- Add a ProxyPass directive "nocanon" for the QM web application URL in the httpd.conf file. The ProxyPass directive applies when Tomcat is used as a reverse proxy.
Reference: http://httpd.apache.org/docs/2.2/mod/mod_proxy.html#proxypass
Note: Please note the proxy server must be restarted for the change to take affect.
Related information
Apache: http://httpd.apache.org/docs/2.2/mod/mod_proxy.html
IHS:
- http://publib.boulder.ibm.com/httpserv/ihsdiag/plugin_questions.html#plugindecode
- http://www.ibm.com/support/docview.wss?uid=swg1PM31189
RQM:
- QM Java ETLs fail in certain environments when using JTS authentication
https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=79350
Workaround:
Use FORM based authentication instead of Jazz Team Server for your ETL.
Related Information
Product Synonym
Rational Quality Manager
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21632841