Closed as duplicate of another APAR.
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
This is a duplicate of APAR IC67712
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following: