IBM Support

IT04858: CREATING, EDITING AND QUERYING THE CLIENT SCHEDULES MAY FAIL IF THESE HAVE A DURATION OF "INDEFINITE"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When creating, editing or querying Tivoli Storage Manager Client
    schedules using Operations Center, the operation may fail with
    the following error:
    
    "ANRG0092E: An internal error occurred on the Tivoli Storage
    Manager Server"
    
    Also, the following exceptions will be logged into the Activity
    Log:
    
    ANR9999D_2215375891 DoTheParmBinds(tbcli.c:8225) Thread<71>:
    Type mismatch 21 != 31 for column 14 for row 000000000D1CC680
    ......
    
     ANR0102E admsql.c(5734): Error 9999 inserting row in table
    "cli_schedt".
    
    
    The problem will also take place when performing select
    against "client_schedules" table using the Tivoli Storage
    Manager Administrative Command Line (dsmadmc).
    This issue will only occur with Client schedules that have a
    "durunits" field set to "indefinite".
    
    | MDVREGR 7.1.1.000-TIV-TSMSRV |
    
    
    
    
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager Operations Center v.7.1.1.000 on all
    supported platforms
    
    
    
    
    Initial Impact:
    Medium
    
    
    
    
    Additional Keywords:
    TSM OC Operations Center  ANRG0092E ANR9999D_2215375891  zz71
    

Local fix

  • The Client schedules with indefinite duration are one time
    schedule only so they only runs once.
    Because of this, if these schedules are not used anymore they
    can be deleted.
    Otherwise use the following steps to identify them and change
    "duration" option to a definite interval:
    
    Use the following DB2 select to find the offending schedules.:
    
    db2 "select domainname,schedname,duration,durunits from
    schedules where duration=0"
    
    
    Then for each of those schedules, issue the following Server
    command to change the duration from indefinite to a definite
    days interval:
    
    "update schedule [domainname] [schedname] duration=999
    durunits=days"
    

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.1.100 and 7.1.3. 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

    IT04858

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-10

  • Closed date

    2014-10-29

  • Last modified date

    2015-07-09

  • 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 #: IT04858

Modified date: 09 July 2015