Common ETL jobs fail with CRRRE1404E error

Technote (troubleshooting)


Problem(Abstract)

Attempts to run Common ETL job result in "CRRRE1404E: The user or password is invalid" when using IBM Rational Team Concert.

Symptom

When you run the data collection, all jobs succeed except for the Common jobs.

Common ETL jobs fail with an error:

CRRRE1404E: The user or password is invalid


Cause

The problem could be due to JTS losing connection to the LDAP server at that time. As a consequence, change and configuration management (CCM) cannot authenticate the LDAP user ID that runs the ETL tasks.

If a proxy server is in place, it could be due to a failing connection between CCM and JTS through the proxy server.

  1. The CCM common job is triggered (by schedule or manually)
  2. CCM sends the request to JTS asking to verify if the lD used to run the ETL task has sufficient permission and CAL to run the job
  3. The request is received by the proxy server and sent to JTS
  4. JTS receives the request and sends a response back to CCM through the proxy

Diagnosing the problem

  • The XDC Authentication Type is set to the default Form
  • An LDAP ID is being used to run the Data Collection Jobs
  • You see the following error in the application server log:


    2012-03-28 00:08:27,885 [ccm0009001: AsynchronousTaskRunner-3] 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: CRRRE1404E: The user or password is invalid.
    java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1404E: The user or password is invalid.

Resolving the problem

Use an internal functional ID to run the ETL Data Collection jobs instead of a real LDAP ID.

  1. Navigate to jts/admin > Server > Consumers. Create and register a new consumers key. Set the etl_user as the function user.

  2. Naviate to jts/admin > Reports > Datawarehouse Connection. Enter the consumer key and secret for the connection properties. Change the XDC Authentication Type from Form to JTS.

  3. Navigate to jts/admin > Reports > Data Collection Jobs. Enter the newly created Consumer Key and secret.

  4. Rerun the Common job successfully.


    Doing this has the following benefits:
    • You no longer use LDAP for authenticating the ETL job. This will eliminate LDAP failures from the picture.

    • No need to worry about ETL user password expiring.
Leverage the Jazz Community

Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
For details and links, see the following document. Leveraging the Jazz Community on Jazz.net

Document information


More support for:

Rational Team Concert
Reports

Software version:

3.0.1.2, 3.0.1.3, 3.0.1.4, 4.0

Operating system(s):

Linux, Solaris, Windows

Reference #:

1609143

Modified date:

2012-08-24

Translate my page

Content navigation