IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IT24730

  • Reported component name

    TSM CLIENT

  • Reported component ID

    5698ISMCL

  • Reported release

    81W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-04-16

  • Closed date

    2018-05-14

  • Last modified date

    2018-05-14

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 81W

Reference #: IT24730

Modified date: 14 May 2018


Translate this page: