It's all about the answers!

Ask a question

Data collection jobs failing for CLM, JAZZ, QM with Oauth issue


Vishnu Kumar (2621421) | asked Jun 18 '13, 10:55 a.m.
retagged Jun 18 '13, 12:04 p.m. by Amy Laird (16514)
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...

Comments
Piotr Aniola commented Jun 18 '13, 11:46 a.m.

Are there any errors in any of the <app>-etl.log files?


Vishnu Kumar commented 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


3 answers



permanent link
Abraham Sweiss (2.4k930) | answered Jun 18 '13, 11:56 a.m.
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.



Comments
Vishnu Kumar commented Jun 19 '13, 5:29 a.m.

Hi Abraham,
                   When you say each application, you mean /jts/admin, /ccm/admin, /qm/admin and checking Dataware connection there...

For all the applications, we are using the same report user name and same user for Data collection...

Regards
Vishnu Kumar



permanent link
Abraham Sweiss (2.4k930) | answered Jun 19 '13, 8:46 a.m.
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.


permanent link
Kot T. (1.5k11219) | answered Jun 19 '13, 5:12 p.m.
JAZZ DEVELOPER
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'.

Your answer


Register or to post your answer.