Common ETL jobs fail with CRRRE1404E: The user or password is invalid

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 the data collection jobs are run, 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, so that change and configuration management (CCM) is not able to authenticate the LDAP user ID used to run 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
  • The following error is seen 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

An internal functional ID can be used 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. Re-run the Common job successfully.

    Doing this has the following benefits:
    • LDAP is no longer used 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.
Refer to technote 1319600 for details and links.


Rate this page:

(0 users)Average rating

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

Machine Translation

Content navigation