IBM Support

IT16269: ANR0102E ERROR GENERATED WHEN QUERYING THE EVENTS TABLE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Issuing a select statement against the EVENTS table may produce
    the following error:
    ANR0102E admsql.c(5794): Error 1202 inserting row in table
    "EVENTS.SQL".
    When a select statement is issued against the EVENTS table, the
    output from the QUERY EVENT command is inserted into the
    EVENTS.SQL table. If the QUERY EVENT command displays duplicate
    records it will result in the ANR0102E error seen above.
    | MDVREGR 7.1.6.0 |
    IBM Spectrum Protect Versions Affected:
    7.1.6.0 server on all platforms
    Initial Impact:
    Medium
    Additional Keywords:
    TSM
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager Server Users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in levels 7.1.7. Note that this is     *
    * subject to change at the discretion of IBM.                  *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms: AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT16269

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-22

  • Closed date

    2016-08-08

  • Last modified date

    2016-08-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

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT16269

Modified date: 15 August 2016