Technote (troubleshooting)
Problem(Abstract)
When using Tivoli Common Reporting to try to view reports in the ISC/Admin Center, a failure occurs with CTGTRV014E and CTGTRV011E error messages.
Symptom
When viewing the report link, you see:
+ Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Failed to get connection.
SQL error #1: [ibm][db2][jcc][t4][2013][11249] Connection authorization failure occurred. Reason: User ID or Password invalid.
Cause
ITMUSER password is not correct or the account is locked/disabled.
Diagnosing the problem
To diagnose the issue, in the Admin Center click on the report to view it.
Click on the https link when you see:
CTGTRV014E The report can not be successfully formatted because it completed with errors, reference ID [REPORTID_34_OBJECTID_513d513d]. Click on the following link to view the report with the errors.
CTGTRV011E See the Tivoli Common Reporting log files for more information. https://ipaddress:port/TCR/Reports/view
Resolving the problem
There are three known reasons for this issue: A. IBM Tivoli Monitoring account is locked or disabled B. Warehouse Proxy’s ITMUSER password is incorrect C. Tivoli Common Reporting datasource’s ITMUSER password is incorrect Resolutions: A. Unlock/enable the ITMUSER account. 1. Right click on My Computer and click on Manager 2. Expand System Tools and Local Users and Groups and click on Users 3. Right click on ITMUser and click Properties 4. On the General tab, verify that the account is not disabled or locked B. Re-enter the correct password for the Warehouse Proxy’s ITMUSER account 1. In Tivoli Enterprise Monitoring Services, right click Warehouse Proxy and choose Reconfigure 2. Go through all the windows until you get to “Configure DB2 Data Source for Warehouse Proxy” 3. Retype in the correct password for the ITMUSER C. Re-enter the correct password for the Tivoli Common Reporting datasource’s ITMUSER account 1. In ISC, right click on a report that is failing and click “Data Sources…” 2. Click the Edit button 3. Retype in the correct password for the ITMUSER in the password box. If the ITMUSER password is not known, see the following technote to change it and reconfigure the necessary services. http://www-01.ibm.com/support/docview.wss?uid=swg21472841
Product Alias/Synonym
TSM TCR ITM
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.