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

IBM Tivoli Security Compliance Manager, fix pack 5.1.1-TIV-SCM-FP0033
IBM Tivoli Security Compliance Manager, fix pack 5.1.1-TIV-SCM-FP0035
IBM Tivoli Security Compliance Manager, fix pack 5.1.1-TIV-SCM-FP0037
IBM Tivoli Security Compliance Manager, fix pack 5.1.1-TIV-SCM-FP0039
IBM Tivoli Security Compliance Manager, fix pack 5.1.1-TIV-SCM-FP0041
IBM Tivoli Security Compliance Manager, fix pack 5.1.1-ISS-SCM-FP0043
IBM Tivoli Security Compliance Manager, fix pack 5.1.1-ISS-SCM-FP0045

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