IT24730: OPERATIONS CENTER 8.1.5 "SECURITY NOTIFICATIONS" MAY RETURN "CANNOT RETRIEVE DATA"

IBM Spectrum Protect Server V8.1.5.X interim fix downloads

APAR status

• Closed as program error.

Error description

• Using the Operations Center, in the "Security Notifications"
  panel when clicking on one of the notifications,  a hyperlink
  with the message "Cannot retrieve data" appears on the right
  side and no data is reported.
  Also the following errors are shown in the server activity log:
  
  
  ANRG0091E The syntax of the following command is not valid:
  SELECT ANR0162W Supplemental database diagnostic information:
  -1:22012:-801([IBM][CLI Driver][DB2/AIX64] SQL0801N Division by
  zero was attempted.SQLSTATE=22012~).
  
  ANR0516E SQL processing for statement select avg ( BYTES ) as
  AVG_BYTES, avg ( DEDUP_PCT ) as AVG_DEDUP_PCT from ( select
  BYTES , ( (coalesce ( DEDUP_SAVINGS , 0 ) * 1.0 ) /coalesce (
  BYTES_PROTECTED , 0 )) *100
  as DEDUP_PCT from summary_extended where activity = 'BACKUP' AND
  ACTIVITY_TYPE = 'SESSION_END' AND ENTITY = 'E-DUMITRACHE' AND
  START_TIME < ( select max ( START_TIME ) from summary_extended
  where activity = 'BACKUP' AND ACTIVITY_TYPE = 'SESSION_END' AND
  ENTITY = 'E-DUMITRACHE' AND INCIDENT_TYPE is not null ) AND
  START_TIME > (select coalesce ( max ( START_TIME ) , timestamp
  ( '1970-01-01 00:00:00' ) )
  from summary_extended where activity = 'BACKUP' AND
  ACTIVITY_TYPE = 'SESSION_END' AND ENTITY = 'E-DUMITRACHE' AND
  INCIDENT_TYPE is not null
  AND ACKNOWLEDGE = 2 ) ORDER BY START_TIME DESC FETCH FIRST 5
  ROWS ONLY ) failed.
  
  
  
  IBM Spectrum Protect versions affected:
  Server 8.1.5.000 on supported platforms
  (note: this feature has been added only from this OC/server
  version)
  
  
  Initial Impact:
  Medium
  
  
  Additional Keywords:
  TSM "Spectrum Protect" ANR0516E ANRG0091E "cannot retrieve data"
  "security notifications" OC "operations center"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Spectrum Protect Operations Center users viewing         *
  * security notifications triggered by a  backup from a legacy  *
  * storage  pool.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  

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 SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R81A PSY

     UP

• R81L PSY

     UP

• R81W PSY

     UP