IBM Support

The DB field PROCESSLOG.NEW_DATA is too small for large number of accounts

Troubleshooting


Problem

During password change with password-sync enabled, you see the following errors: - CTGIMV405E in UI - transaction rollback in trace.log - "field too small" with JDBC tracing catching SQLCODE=-302, SQLSTATE=22001

Symptom

During password change with password-sync enabled, each involved account is written using an XML string into the DB field PROCESSLOG.NEW_DATA:

INSERT INTO PROCESSLOG (ID, PROCESS_ID, ACTIVITY_ID, CREATED, EVENTTYPE, OLD_PARTICIPANT_TYPE, OLD_PARTICIPANT_ID, NEW_PARTICIPANT_TYPE, NEW_PARTICIPANT_ID, REQUESTOR_TYPE, REQUESTOR, REQUESTOR_DN, OLD_STATE, NEW_STATE, DATA_ID, SMALL_NEW_DATA, NEW_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)


The more accounts the person has, the larger the value gets. Approximately 3000 accounts uses all defined 10 MB (column length is 10485760) of the CLOB field NEW_DATA.

[{"Product":{"code":"SSRMWJ","label":"IBM Security Identity Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg22008977

Page Feedback