Data collection jobs failing for CLM, JAZZ, QM with Oauth issue
Vishnu Kumar (26●2●15●26)
| asked Jun 18 '13, 10:55 a.m.
retagged Jun 18 '13, 12:04 p.m. by Amy Laird (165●1●4)
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... |
3 answers
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'. |
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. |
Comments
Are there any errors in any of the <app>-etl.log files?
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