IT16269: ANR0102E ERROR GENERATED WHEN QUERYING THE EVENTS TABLE

7.1.7.000-TIV-TSMSRV-SolarisSPARC
7.1.7.000-TIV-TSMSRV-Linuxs390x
7.1.7.000-TIV-TSMSRV-Linuxppc64
7.1.7.000-TIV-TSMSRV-WIN
7.1.7.000-TIV-TSMSRV-Linuxx86_64
7.1.7.000-TIV-TSMSRV-HP-UX
7.1.7.000-TIV-TSMSRV-AIX
IBM Spectrum Protect Server V7.1 Fix Pack 7 (7.1.7.000) Downloads

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