IBM Support

A "value too large for column" SQL exception occurs for the LSW_USR_GRP_XREF table for IBM Business Process Manager (BPM)

Troubleshooting


Problem

After upgrading from IBM Business Process Manager V7.5.1 Fix Pack 1 to Fix Paxck 2, you receive an error message. The message indicates that a value for the GROUP_NAME column in the LSW_USR_GRP_XREF table is too large when it tries to create a snapshot for an application.

Symptom

You see an error message that is similar to the following text. The following example is seen with an Oracle database. Error messages for other databases might differ slightly.

[7/122/14 15:14:29:281 CEST] 0000208a wle           E   Exception while creating the snapshot   com.lombardisoftware.client.delegate.  
BusinessDelegateException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into LSW_USR_GRP_XREF (GROUP_ID,GROUP_NAME, DISPLAY_NAME,GROUP_TYPE,DESCRIPTION,GROUP_STATE,PARENT_GROUP_ID) values (?,?,?,?,?,?,?)]; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "BPMDB"."LSW_USR_GRP_XREF"."GROUP_NAME" (actual: 102, maximum: 101) ; nested exception is java.sql.SQLException: ORA-12899: value too large for column "BPMDB"."LSW_USR_GRP_XREF"."GROUP_NAME" (actual: 102, maximum: 101)

[{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Upgrade","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1.1;7.5.1.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSFTBX","label":"IBM Business Process Manager Express"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Upgrade","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1.2;7.5.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Upgrade","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1.2;7.5.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data 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:
28 April 2025

UID

swg21679722

Page Feedback