APAR status
Closed as program error.
Error description
The IBM Storage Insights Notification panel and Advisor panel do not load and display the data for their events. When the SQL SELECT_CALL_HOME_EVENTS_AND_DETAILS_BASE is invoked, the LISTAGG function reports an error due to overflow. This is shown in traceWebServer_error.log: [Default Executor-thread-3094] [SupportServiceImpl.getEvents] [ERROR] <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: The length resulting from "LISTAGG" is greater than "4000".. SQLCODE=-137, SQLSTATE=54006, DRIVER=4.19.49 {prepstmnt 1048413167 <...SQL snipped...> } [code=-137, state=54006]SQLCA OUTPUT[Errp=SQLRI0BA, Errd=-2145779603, 0, 0, 0, -20, 0] The length resulting from "LISTAGG" is greater than "4000".. SQLCODE=-137, SQLSTATE=54006, DRIVER=4.19.49
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Storage Insights users viewing the Notification or * * Advisor panels * **************************************************************** * PROBLEM DESCRIPTION: * * The IBM Storage Insights Notification panel and Advisor * * panel * * do not load, and do not display the data for their events. * * * * When the SQL statement is invoked, the LISTAGG function * * reports an error due to overflow. This is shown in * * traceWebServer_error.log: * * * * <openjpa-2.2.2-r422266:1468616 fatal general error> * * org.apache.openjpa.persistence.PersistenceException: The * * length * * resulting from "LISTAGG" is greater than "4000".. * * SQLCODE=-137, * * SQLSTATE=54006, DRIVER=4.19.49 {prepstmnt 1048413167 * * ... * * The length resulting from "LISTAGG" is greater than "4000".. * * SQLCODE=-137, SQLSTATE=54006, DRIVER=4.19.49 * * * * * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following release: IBM Storage Insights 1Q21 [ 5.4.2-IBM-SI-Patch ] ( release target 1Q 2021 / March ) The target dates for future releases do not represent a formal commitment by IBM. The dates are subject to change without notice.
Temporary fix
Comments
APAR Information
APAR number
IT34541
Reported component name
STORAGE INSIGHT
Reported component ID
5608TPCSI
Reported release
540
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-10-14
Closed date
2020-10-23
Last modified date
2021-02-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
STORAGE INSIGHT
Fixed component ID
5608TPCSI
Applicable component levels
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSQRB8","label":"IBM Storage Insights"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"540"}]
Document Information
Modified date:
08 February 2022