IBM Support

IC71570: ANR0102E ADMSQL.C(5177): ERROR 1 INSERTING ROW IN TABLE "EVENTS.SQL"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When issuing a SELECT statement against the Tivoli Storage
    Manager Server "events" table using command " SELECT * from
    Events",  The command can fail with the following error logged
    in activity log:
    .
      ANR0102E admsql.c(5299): Error 1 inserting row in table
    "EVENTS.SQL".
    .
    .
    Customer/L2 Diagnostics:
    
    The error condition can happen if  there are duplicated  event
    records and the NODE_NAME field is NULL:
    
    for example,
    
    A trace on the failed command with flags "ADDMSG ADM DB DBEXEC
    SQL SCHED" shows
    
    13:32:30.229
    [148][tbcli.c][10226][TraceSetInputParameters]:key=2,
    name=NODE_NAME, type=STRING, value=(0)addr-0x11108d4c4
    ...
    13:32:31.130
    [148][tbcli.c][10226][TraceSetInputParameters]:key=2,
    name=NODE_NAME, type=STRING, value=(0)addr-0x11108d4c4
    
    
    Tivoli Storage Manager Versions Affected:
    All 6.1 and 6.2 Tivoli Storage Manager Servers.
    .
    Additional Keywords:
    ZZ62 ZZ61 SELECT EVENTS ANR0102E  IC69139
    .
    

Local fix

  • Use the QUERY EVENT command (type=client & type=admin).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager server users      *
    *                 performing a SELECT from the Events table.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: See error description.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in levels 6.1.4.3, 6.1.5, and 6.2.2. Note    *
    *                 that this is subject to change at the        *
    *                 discretion of IBM.                           *
    ****************************************************************
    *
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IC71570

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-09-29

  • Closed date

    2010-11-05

  • Last modified date

    2010-11-05

  • 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

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

  • R62W PSY

       UP

[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61A"}]

Document Information

Modified date:
17 September 2021