IC65001: SELECT FROM ADMINS ANR0102E ERROR 8 INSERTING TABLE "ADMINST".

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Some query commands concatenate the profile names associated
    with an administrator or schedule together and then store the
    result in a temporary table.  In some cases the combined
    profile names will exceed the maximum allowed length in the
    temporary table.  Here is an example from the ADMINS table
    which used the Adminst temporary table:
    <timestamp> ANR2017I Administrator ADMIN issued command:
    SELECT ADMIN_NAME FROM ADMINS (SESSION: 123)
    <timestamp> ANR0162W Supplemental database diagnostic
     information: -1:22001:-99999 ([IBM][CLI Driver] CLI0109E
     String data right truncation. SQLSTATE=22001). (SESSION: 123)
    <timestamp> ANR0157W Database operation INSERT for table Adminst
    
     failed with result code 8 and tracking ID: 0x19e6f5a8.
     (SESSION: 123)
    <timestamp> ANR0158W Database operation INSERT for table Adminst
     failed with operation code 8 and tracking id 0x19e6f5a8. The
     data for column 0 is: (string, len=8)0x424D434E414C4C59.
     (SESSION: 123)
    <timestamp> ANR0102E admsql.c(5099): Error 8 inserting row in
     table "Adminst". (SESSION: 123)
    This problem can occur with the following tables:
      ADMINS, ADMIN_SCHEDULES, CLIENT_SCHEDULES
    The symptoms may also be seen when using Admin Center to change
    security settings and assign administrator authority. When
    selecting assign owner authority to selected administrator, the
    drop down menu may stay grayed out and the error messages above
    may be seen in the activity log.
    Tivoli Storage Manager Versions Affected:
      All 6.1 Tivoli Storage Manager servers
    Initial Impact:
      Medium
    

Local fix

Problem summary

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

Problem conclusion

  • This problem was fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65001

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-07

  • Closed date

    2009-12-14

  • Last modified date

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

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager

Software version:

61L

Reference #:

IC65001

Modified date:

2009-12-14

Translate my page

Machine Translation

Content navigation