IZ36922: SQLEXCEPTION: DB2 SQL ERROR SQLCODE: -302 SQLSTATE= 22001 WHEN TRYING TO UPDATE TABLE WIN_USER_RIGHTS_V2.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The win.any.UserRightsV2 collector gets the error.
    .
     SqlException:  DB2 SQL Error  SQLCODE: -302 SQLSTATE= 22001
    .
    This error occurs because the data being returned exceeds the
    length allocated to the privilege column.
    

Local fix

  • Increase the length of the privilege column from 50 to
    around 100.
    

Problem summary

  • The error DB2 SQLCODE -302 SQLSTATE 22001 when updating table
    WIN_USER_RGHTS_V2 during update of the win.any.UserRightsV2
    collector version 2.
    

Problem conclusion

  • The problem is caused by improper parsing of internal executable
    output. Sometime the data with name of user is stored to
    PRIVILEGE
    column in the collector table, and if the length of it is too
    big,
    the error occurs. The fix changed data separator in internal
    executable output, what was a reason of such behavior.
    
    The release of fixed collector: 3
    
    The fix for this APAR is a part of maintenance package:
     fix pack 5.1.1.-TIV-SCM-FP0024
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ36922

  • Reported component name

    TIV SEC COMPL M

  • Reported component ID

    5724SCM51

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-07

  • Closed date

    2008-12-19

  • Last modified date

    2008-12-19

  • 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

    TIV SEC COMPL M

  • Fixed component ID

    5724SCM51

Applicable component levels

  • R510 PSY

       UP

  • R511 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Security Compliance Manager

Software version:

510

Reference #:

IZ36922

Modified date:

2008-12-19

Translate my page

Machine Translation

Content navigation