APAR status
Closed as duplicate of another APAR.
Error description
When the fields Total_K_Bytes, Objects Evaluated, and Objects Processed are over 2 billion, several TCR reports fail with CTGTRV014E and CTGTRV011E SQL error #1: DB2 SQL error: SQLCODE: -802, SQLSTATE: 22003, SQLERRMC: null The following reports are affected: Client Activity Details Client Activity History Client Top Activity Server Activity Details Enabling Agent trace will show messages regarding value outside the range of type INTEGER: TSMNodeActivity: Entering collectData as a Historical Request NodeActivity: Exception thrown when querying the derby DB ERROR 22003: The resulting value is outside the range for the data type INTEGER. TSMNodeActivity: Total rows returned from DERBY DB: 301 Enabling TCR trace and clicking on one of these reports with the error should show messages similar to: 00000021 reportLogger 1 com.ibm.tivoli.reporting.reportEngine.impl.BIRTReportLogger /TSMReports/TSM_server_activity_details.rptdesign NOTE ^new parameter is select "Server_Name", "Start_Time", "Node_Name", sum("Elapsed_Time") as "Elapsed_Time", sum("Inspected_Objects") as "Inspected_Objects", sum("Processed_Objects") as "Processed_Objects", sum("Failed_Objects") as "Failed_Objects", sum("Total_K_Bytes") as "Total_Bytes" from KSK_NODE_ACTIVITY where ("Start_Time" BETWEEN '1100308000000000' and '1100407235959999' or "End_Time" BETWEEN '1100308000000000' and '1100407235959999') and "Type" = 5 and "Server_Name" like ? group by "Server_Name", "Start_Time","Node_Name" order by parm_sort_by^n^ 00000021 odaconsumer E org.eclipse.birt.data.engine.odaconsumer.PreparedStatement execute Cannot execute statement. org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. SQL error #1: DB2 SQL error: SQLCODE: -802, SQLSTATE: 22003, SQLERRMC: null The above example states the error is coming from TSM_server_activity_details.rptdesign. That is the Server Activity Details report in TCR. Initial Impact: Low Tivoli Storage Manager Versions Affected: All 6.1/6.2 Additional Keywords: zz61rm TSM ITM RM R&M sqlcode -802
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
This is a duplicate of APAR IC67712
APAR Information
APAR number
IC67985
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61W
Status
CLOSED DUB
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-16
Closed date
2010-04-23
Last modified date
2010-05-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
25 May 2010