IBM Support

IC67985: TCR REPORTS FAIL WITH SQLCODE -802 WHEN FIELDS WITHIN THE REPORTS ARE LARGER THAN 2 BILLION

Subscribe

You can track all active APARs for this component.

 

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