Historical Data Collection returns "Cannot get the result set metadata"

Technote (troubleshooting)


Problem(Abstract)

Creation of Historical Reports fails with SQL errors.

Symptom

Historical Data Collection within the Reporting and Monitoring feature will return:

+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ITMUSER.KSK_DATABASE_DV
SQL error #2: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE_DV

Note that the ITMUSER.KSK_ value can be different then the above message depending on the report that is being viewed.


Resolving the problem

Product Alias/Synonym

tsm adsm itsm

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager
Server

Software version:

6.1

Operating system(s):

AIX, Linux, Windows

Software edition:

All Editions

Reference #:

1391900

Modified date:

2014-06-18

Translate my page

Machine Translation

Content navigation