QM ETL Job fails with 401 or 403 error when using HTTP Proxy and OAuth authentication

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.