Failed to prepare the following query for the data set type error in TCR

Technote (troubleshooting)


Problem(Abstract)

When attempting to view Tivoli Common Reports (TCR), this is failing on the prepare of the query:
Error preparing SQL statement. SQL error #1

Symptom

Server name for each report is only NULL.


Cause

Incorrect data source for Tivoli Common Reporting reports.

Diagnosing the problem

Run the Server Details Report - select NULL server name and press Run.

The following are the errors in Red for the report.

ReportDesign (id = 1):
+ Failed to prepare the following query for the data set type org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet.
[select "VIEWNAME"
from SYSCAT.VIEWDEP
where "VIEWNAME" like KSK_%_%V]
Error preparing SQL statement.
SQL error #1: Table SYSCAT.VIEWDEP does not exist.


+ Failed to prepare the following query for the data set type org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet.
[select "WRITETIME",
"AVG_Current_Size" as "CURRSZ",
"AVG_Total_Space_Used" as "TOTALSZ",
("AVG_Current_Size" - "AVG_Total_Space_Used" ) as "FREESZ"
from KSK_DATABASE_DV
where "WRITETIME"
BETWEEN 1110327000000000 and 1110426235959999
and "Server_Name" = ?
order by "WRITETIME" asc]
Error preparing SQL statement.
SQL error #1: Schema ITMUSER does not exist


+ Failed to prepare the following query for the data set type org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet.
[select "WRITETIME",
( "Backup_Duration" * 60 ) as "TIME",
"Last_BU_Date" as "DATE",
"Backup_Status" as "STATUS",
"Volumes_Used" as "VOLUME"
from KSK_DATABASE
where "WRITETIME"
BETWEEN 1110327000000000 and 1110426235959999
and "Server_Name" = ?
and "Last_BU_Date" > 0
order by "WRITETIME" asc]
Error preparing SQL statement.
SQL error #1: Schema ITMUSER does not exist


Resolving the problem

This particular error is most commonly caused by incorrect JNDI Name in the data source for the Tivoli Common Reporting reports. The correct value should be:


    ibm/tivoli/tsm

Verify the other fields are correct based on the setup of Tivoli Storage Manager for Monitoring and Reporting.
    User ID: ITMUser
    JDBC Driver: com.ibm.db2.jcc.DB2Driver
    JDBC URL: jdbc:db2://<ipaddressWhereTheWarehousDBIs>:50000/WAREHOUS:currentSchema= ITMUSER;
    Display Name: (this can be blank)

Product Alias/Synonym

TSM TCR

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager
Server

Software version:

6.1, 6.2

Operating system(s):

Platform Independent

Reference #:

1497707

Modified date:

2011-05-19

Translate my page

Machine Translation

Content navigation