Direct link to fix
APAR status
Closed as program error.
Error description
DBUpgrade attempts to create certain user records in the LSW_USR tables based on various config settings. If there is an issue with the length of the user ID then the upgarde can fail with a DB error like this: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated. at ... com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute( SQLServerPreparedStatement.java:332) at com.lombardisoftware.tools.dbupgrade.steps.Add750Users$1. insertUserRows(Add750Users.java:160) at com.lombardisoftware.tools.dbupgrade.steps.Add750Users$1.doInCon nection(Add750Users.java:122) You may notice this when you have a very long user ID set for your user registry's primary admin ID. <userRegistries xmi:type="security:WIMUserRegistry" primaryAdminId="CN=Celladmin_bpm,OU=MyOrg,OU=otherOrg ,OU=Longname,DC=DCName,DC=morenames,DC=us"
Local fix
Ensure primaryAdminID for any user repository is set to a proper short version of the user name.
Problem summary
This exception occurs because the Add750Users step is not needed when the source version is higher than IBM WebSphere Lombardi Edition 7.2.
Problem conclusion
An interim fix for IBM BPM V8.5.7 CF201706 is available that remove the step when the source version is higher than WebSphere Lombardi Edition 7.2.
Temporary fix
Comments
APAR Information
APAR number
JR57850
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
857
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-02
Closed date
2017-06-07
Last modified date
2017-06-12
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
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R857 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 June 2017