Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Seeing errors logged in the ccm-etl.log file for. Which user is throwing this error? There is not user mentioned.

Questions
Tags
Users
Badges
Der M
(61●2●14●18) Jun 21 '12, 6:46 a.m.

Hello world!!

 

I am seeing errors in my ccm-etl.log file.  I am not sure which user is throwing this error message.

 

Would anyone have an idea what is throwing this error message?  There are two users setup as far as I know.  etl-user and a RPTUSER.  Which of these is this would you think?

 

Also what is an easy method to check that my data warehouse is working correctly???


2012-05-25 00:01:24,527 [ ccm: AsynchronousTaskRunner-4] 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.
 at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2098)
 at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next(BaseRDSResultSet.java:1469)
 at com.ibm.team.datawarehouse.service.XdcResultSet.next(XdcResultSet.java:139)
 at com.ibm.team.datawarehouse.service.internal.common.etlbuild.ProjectArea.execute(ProjectArea.java:93)
 at com.ibm.team.datawarehouse.service.internal.common.CommonRemoteSnapshotService.updateSnapshot(CommonRemoteSnapshotService.java:81)
 at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:193)
 at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$4.run(RemoteDatabaseService.java:208)
 at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
 at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:198)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 

Thanks in advance.

0 votes

3 answers
5,715 views
0 votes

Accepted answer

Permanent link
James Moody
JAZZ DEVELOPER (3.3k●2●4) Jun 21 '12, 2:15 p.m.
I think Ralph is on the right track. (Valli: I believe this is only with respect to CLM, not Insight, so the job status isn't in the Insight jobs page).

To see the status of the jobs, go to your application's admin page and click on Reports, then select "Data Collection Jobs Status". This will give you a list of jobs and whether each one passed or failed on the last run. If it failed, then the information is in the log file as you have already located.

With respect to this specific error, the user it is talking about is the special "Data Collection Jobs" user that you configured when you ran the application setup. (I've often seen it called etl_user or dw_user). Each ETL is configured to use this username, and the associated password, when it runs. Please go to the "Data Collection Jobs" section in the Reports page in the admin page, and confirm that the username is correct for each of the jobs; re-enter the password just to ensure it's correct.

If this still doesn't work, you may have the authentication type (form/basic) set up incorrectly. In that case, go to the Admin page for CCM, go to the "Advanced Properties" section under "Application", and find the property named "XDC Authentication Type" under "com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService". Valid values are "Basic" and "Form" and should match the authentication type your application is configured to use.

Please let us know if this solves your problem.

james

Der M selected this answer as the correct answer

1 vote

2 other answers

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.7k●3●36●48) Jun 21 '12, 11:05 a.m.
I would assume the user is the one that you configure for the ETL Jobs during setup and on the repots page.

1 vote

Permanent link
VK L
(817●7●157●159) Jun 21 '12, 11:58 a.m.
Hi,
     You can check the jobs status from the insight jobs page itself...and you should be able to change its configuration as well...

Thanks.

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jun 21 '12, 6:46 a.m.

Question was seen: 5,715 times

Last updated: Jun 21 '12, 2:15 p.m.

Confirmation Cancel Confirm