Data collection jobs failing for CLM, JAZZ, QM with Oauth issue
Hello All,
It's a fresh CLM (3.0.1.2) setup primarily for testing purpose. We don't even have any project areas in it.
We are also using RRDI which is on a different box.
On the following page, i have updated the data collection details from default to a user who has data collector license and part of all the JAZZ groups. This is an active user in our LDAP directory and is able to login to JAZZ without any problem...Password is also Valid
http://<hostname>/jts/admin#action=com.ibm.team.reportsManagement.configureDataWarehouseConnection
While running the reports, I am getting following message in the log...
(excerpt from jts.log)
============================
2013-06-18 10:08:54,115 [ http-80-Processor22] INFO com.ibm.team.jfs - CRJZS5658I Triple indexer for private applications has started
2013-06-18 10:08:54,240 [ http-80-Processor22] INFO com.ibm.team.jfs - CRJZS5656I Text indexer for private applications has started
2013-06-18 10:20:14,099 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
2013-06-18 10:20:14,239 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
2013-06-18 10:20:14,364 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
2013-06-18 10:20:14,521 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
===========================
From Tomcat Console:
============================
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:172)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.ja
va:393)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:689)
at java.lang.Thread.run(Thread.java:811)
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << HTTP/1.1 500
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Timing] 31ms
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] GET http://dbyclmtst0101
.pbi.global.pvt/rm/publish/linktypes/*?size=1 HTTP/1.1
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] accept-language: en
_US
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] authorization: OAut
h oauth_token_secret="", oauth_nonce="8520172281878136305", oauth_token="", oaut
h_consumer_key="JTSADMIN-s", oauth_signature_method="HMAC-SHA1", oauth_timestamp
="1371562347", oauth_version="1.0", oauth_signature="eO%2BHMrkwjWWvp5EfYt%2FDyKv
40Yg%3D"
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] host: dbyclmtst0101
.pbi.global.pvt:80
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] connection: Keep-Al
ive
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << <no headers>
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR .ibm.rdm.fronting.server.
response.services.Publish - CRRRS4120I << ---No entity-
=======================================
Now if i change Data Collection details to the consumer key and secret assigned for JAZZ Reporting (which comes by default) under Jts/admin >Consumer inbounds, then it works fine...
Waiting for your expert inputs...
It's a fresh CLM (3.0.1.2) setup primarily for testing purpose. We don't even have any project areas in it.
We are also using RRDI which is on a different box.
On the following page, i have updated the data collection details from default to a user who has data collector license and part of all the JAZZ groups. This is an active user in our LDAP directory and is able to login to JAZZ without any problem...Password is also Valid
http://<hostname>/jts/admin#action=com.ibm.team.reportsManagement.configureDataWarehouseConnection
While running the reports, I am getting following message in the log...
(excerpt from jts.log)
============================
2013-06-18 10:08:54,115 [ http-80-Processor22] INFO com.ibm.team.jfs - CRJZS5658I Triple indexer for private applications has started
2013-06-18 10:08:54,240 [ http-80-Processor22] INFO com.ibm.team.jfs - CRJZS5656I Text indexer for private applications has started
2013-06-18 10:20:14,099 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
2013-06-18 10:20:14,239 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
2013-06-18 10:20:14,364 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
2013-06-18 10:20:14,521 [ Thread-185] WARN org.apache.http.impl.client.DefaultHttpClient - Authentication error: Unable to respond to any of these challenges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem="invalid_consumer_key"}
===========================
From Tomcat Console:
============================
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:172)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.ja
va:393)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:689)
at java.lang.Thread.run(Thread.java:811)
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << HTTP/1.1 500
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Timing] 31ms
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] GET http://dbyclmtst0101
.pbi.global.pvt/rm/publish/linktypes/*?size=1 HTTP/1.1
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] accept-language: en
_US
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] authorization: OAut
h oauth_token_secret="", oauth_nonce="8520172281878136305", oauth_token="", oaut
h_consumer_key="JTSADMIN-s", oauth_signature_method="HMAC-SHA1", oauth_timestamp
="1371562347", oauth_version="1.0", oauth_signature="eO%2BHMrkwjWWvp5EfYt%2FDyKv
40Yg%3D"
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] host: dbyclmtst0101
.pbi.global.pvt:80
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << [Request >>] connection: Keep-Al
ive
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR m.ibm.rdm.fronting.server
.headers.services.Publish - CRRRS4120I << <no headers>
2013-06-18 09:32:28,024 RRC [http-80-Processor5] ERROR .ibm.rdm.fronting.server.
response.services.Publish - CRRRS4120I << ---No entity-
=======================================
Now if i change Data Collection details to the consumer key and secret assigned for JAZZ Reporting (which comes by default) under Jts/admin >Consumer inbounds, then it works fine...
Waiting for your expert inputs...
3 answers
Hello Vishna,
I would do the following:
1. validate that the user is synced up with all the applications.
2. For each application go to reports -> Data Warehouse Connection and make sure each application is using the desired userID.
I would do the following:
1. validate that the user is synced up with all the applications.
2. For each application go to reports -> Data Warehouse Connection and make sure each application is using the desired userID.
Hello Vishnu,
Yes, all applications refer to jts/ccm/rm/qu/admin. Okay at this point my understanding is that
1. The user being used for the DW can log into each aplication
2. This user has been assigned the required Data Collector License
The next thing I would try is
1. For each application create a new consumer key and use the userID as the functional ID
2. use this consumer For the dW connection.
3. Save and restart the server.
Yes, all applications refer to jts/ccm/rm/qu/admin. Okay at this point my understanding is that
1. The user being used for the DW can log into each aplication
2. This user has been assigned the required Data Collector License
The next thing I would try is
1. For each application create a new consumer key and use the userID as the functional ID
2. use this consumer For the dW connection.
3. Save and restart the server.
Hi Vishnu,
Based on the error ==> CRRRE1417E: The HTTP status '401' and the message is 'Unauthorized', I would check the "XDC Authentication Type" in the data warehouse connection page. When using consumer key, the type should be 'JTS' and when using the valid LDAP user name and password, the xdc type should be 'Form'.
Based on the error ==> CRRRE1417E: The HTTP status '401' and the message is 'Unauthorized', I would check the "XDC Authentication Type" in the data warehouse connection page. When using consumer key, the type should be 'JTS' and when using the valid LDAP user name and password, the xdc type should be 'Form'.
Comments
Piotr Aniola
Jun 18 '13, 11:46 a.m.Are there any errors in any of the <app>-etl.log files?
Vishnu Kumar
Jun 19 '13, 5:34 a.m.Hi Piotr,
Ran dataware house collection job for ccm application and all of those (Common, scm, build, workitems) failed... Here is the snippet from ccm-etl.log
======
2013-06-19 05:30:31,618 [ http-80-Processor20] ERROR ervice.internal.common.CommonRemoteSnapshotService - 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'.
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 '401' and the message is 'Unauthorized'.
at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2098)
at com.ibm.rational.drivers.jdbc.xml.BaseRDSRes
Is there a way to attach the file here