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

Cause

This error is seen in version 7.5.1 Fix Pack 1, when the short name of an assigned group exceeds 25 characters.The length of the GROUP_NAME column in the LSW_USR_GRP_XREF table is limited to 101 characters or 404 bytes.

The GROUP_NAMEs are structured as follows:
(Short name of group)_T/S_BPD-ID.Snapshot-ID

The string after the short name of the group consumes 76 characters, which leaves 25 characters for the user to specify for the short name of the group.

In V7.5.1 Fix Pack 2, the length for the GROUP_NAME column is increased to 256 characters, which leaves 180 characters for the user to specify the short name of a group

If you see that the previously mentioned error occurs after migrating to V7.5.1 Fix Pack 2, the post installation database migration script, which is wle_upgradeSchema_ProcessServer.sql, was not run successfully. This script contains a table alteration for the LSW_USR_GRP_XREF.GROUP_NAME. See the following code:
BEGIN
DECLARE
v_isNullable CHAR(1);
 BEGIN
   select nullable into v_isNullable from all_tab_columns where UPPER(owner)=UPPER('perfdbuser') AND UPPER(table_name) = UPPER('LSW_USR_GRP_XREF') AND UPPER(column_name)= UPPER('GROUP_NAME');    
   IF (v_isNullable = 'Y') THEN
     EXECUTE IMMEDIATE  'ALTER TABLE LSW_USR_GRP_XREF MODIFY "GROUP_NAME" NVARCHAR2(256) NOT NULL ENABLE';
   ELSE
  EXECUTE IMMEDIATE  'ALTER TABLE LSW_USR_GRP_XREF MODIFY "GROUP_NAME" NVARCHAR2(256)';
END IF ;
 END ;
END ;

In IBM Business Process Manager V7.5.1 Fix Pack 1, the createTable_ProcessServer.sql statements create a column width of 101 characters for the GROUP_NAME of the LSW_USR_GRP_XREF table.