IT41141: OPERATIONS CENTER REPORTING FAILS TO LOAD WITH WARNING ANR0162W AND ERROR ANR0516E.

APAR status

• Closed as program error.

Error description

• Operations Center reporting fails to load with warning ANR0162W
  and error ANR0516E.
  
  
  This problem may occur when a large number ? in this case over
  700 ? of spokes are added over a period of time to a single hub.
  
  IBM Spectrum Protect Server QUERY ACT command will show:
  
  ANR0162W Supplemental database diagnostic information:
  -1:54006:-137
  ([IBM][CLI Driver][DB2/LINUXX8664] SQL0137N The length resulting
  from "LISTAGG" is greater than "4000". SQLSTATE=54006~)
  
  ANR0516E SQL processing for statement select name from ( SELECT
  * FROM ( SELECT CAST ( MINOR as INT) as ID ,
  max ( decode ( SUBJECT , 'DATASET' , DATA ) ) as DATASET , max (
  decode ( SUBJECT , 'RECIPIENTS' , DATA ) )
  as RECIPIENTS , max ( decode ( SUBJECT , 'REPORTBUILDERCONFIG' ,
  DATA ) ) as REPORTBUILDERCONFIG ,
  max ( decode ( SUBJECT , 'NAME' , DATA ) ) as NAME , max (
  decode ( SUBJECT , 'LASTSTATUS' , DATA ) )
  as LASTSTATUS , max ( decode ( SUBJECT , 'BUILDER' , DATA ) ) as
  BUILDER , max ( decode ( SUBJECT ,
  'LASTSENDDATE' , DATA ) ) as LASTSENDDATE , COALESCE ( max (
  decode ( SUBJECT , 'INCLUDEDATE' , DATA ) ) , 'false' ) as
  INCLUDEDATE , COALESCE ( max ( decode ( SUBJECT , 'ENABLED' ,
  DATA ) ) , 'false' ) as ENABLED , max ( decode ( SUBJECT ,
  'SCHEDULE' , DATA ) ) as SCHEDULE , max ( decode ( SUBJECT ,
  'TYPE' , DATA ) ) as TYPE , max ( decode ( SUBJECT ,
  'SERVERS' , DATA ) ) as SERVERS FROM ( SELECT MINOR , SUBJECT ,
  LISTAGG ( DATA ) WITHIN GROUP ( ORDER BY LINE )
  as DATA FROM SCRATCHPAD WHERE MAJOR = 'OC_REPORTS' GROUP BY
  MINOR , SUBJECT ) GROUP BY MINOR )
  ORDER BY ID ASC ) failed.
  
  IBM Operations Center tsm_opscntr.log will show:
  
  Caused by: com.ibm.tsm.command.TsmCmdException: TSM Command
  Exception, Error code:4
  at
  com.ibm.tsm.command.facade.BaseCmdsProcessor.getJSONData(BaseCmd
  sProcessor.java:386)
  at
  com.ibm.tsm.command.facade.BaseCmdsProcessor.getJSONData(BaseCmd
  sProcessor.java:364)
  at com.ibm.tsm.persistance.Table.query(Table.java:218)
  at
  com.ibm.tsm.command.reports.ReportsTable.getReportNames(ReportsT
  able.java:64)
  at
  com.ibm.tsm.gui.rpc.handlers.ReportsRPC.getReportsInfo(ReportsRP
  C.java:83)
  
  
  The below SQL statement will check  with a value (size) greater
  than 4000 in the ACTLOG.
  select SUM(LENGTH(DATA)) as SIZE from ( SELECT MINOR , SUBJECT ,
  LISTAGG ( CAST(DATA as CLOB) ) WITHIN GROUP ( ORDER BY LINE ) as
  DATA FROM SCRATCHPAD WHERE MAJOR = 'OC_REPORTS' GROUP BY MINOR ,
  SUBJECT )
  
  SIZE
  12,245
  
  
  
  IBM Spectrum Protect Versions Affected:
  IBM Spectrum Protect Operations Center versions 8.1.13.0 and
  later
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect Operations Center users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level to the Operations Center when available.  *
  * This problem is currently projected to be fixed in level     *
  * 8.1.16. Note that this is subject to change at the           *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, Linux, and
  Windows.
  Platforms fixed: AIX, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

• 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

  TSM OPERATIONS

• Fixed component ID

  5608E01UI

Applicable component levels