IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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



Document information

More support for: Tivoli Storage Manager

Software version: 81W

Reference #: IT24730

Modified date: 14 May 2018


Translate this page: