JR57850: RUNNING THE DBUPGRADE COMMAND FAILS AT THE ADD750USERS STEP WITH THE ERROR "STRING OR BINARY DATA WOULD BE TRUNCATED"

bpm.8570.cf2017.06.delta.repository

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