IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
12 June 2017