JR58030: SAVING DASHBOARD PREFERENCES CAUSES DATABASE ERROR

bpm.8600.delta.repository

APAR status

• Closed as program error.

Error description

• When you log back in after having changed the dashboard display
  order preference, you notice the changes did not take effect.
  
  PRODUCTS AFFECTED
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  

Local fix

• Limit the amount of dashboards and saved searches for each user.
  

Problem summary

• In IBM Process Portal, when you add, remove, or change the order
  of the favorite dashboards in the launch panel, changes are not
  persisted in the user preferences after the user logs out from
  Process Portal. When Process Portal tries to save the changes, a
  database error is logged in the SystemOut.log file, similar to
  the following example:
  
  [6/19/17 10:41:00:325 EDT] 00000144 UserOrgModule E
  CWLLG1162E: An exception occurred while setting the attribute
  Portal Dashboard Display Order to value <DISPLAY-ORDER-VALUE>
  for user <USER NAME>. Error:
  com.lombardisoftware.client.delegate.BusinessDelegateException:
  PreparedStatementCallback; SQL [insert into LSW_USR_ATTR
  (USER_ATTR_ID,ATTR_VALUE,ATTR_NUMBER_VALUE,USER_ID,USER_ATTR_DEF
  _VALUE_I
  D,USER_ATTR_DEF_ID) values (?,?,?,?,?,?)]; String or binary data
  would
  be truncated.; nested exception is
  java.sql.BatchUpdateException: String
  or binary data would be truncated.
  
  com.lombardisoftware.client.delegate.BusinessDelegateException:
  PreparedStatementCallback; SQL [insert into LSW_USR_ATTR
  (USER_ATTR_ID,ATTR_VALUE,ATTR_NUMBER_VALUE,USER_ID,USER_ATTR_DEF
  _VALUE_I
  D,USER_ATTR_DEF_ID) values (?,?,?,?,?,?)]; String or binary data
  would
  be truncated.; nested exception is
  java.sql.BatchUpdateException: String
  or binary data would be truncated.
  at
  com.lombardisoftware.client.delegate.BusinessDelegateException.a
  sBusines
  sDelegateException(BusinessDelegateException.java:46)
  where the <DISPLAY-ORDER-VALUE> length exceeds 1000.
  
  When the dashboard display order preference is saved, it
  includes the dashboard IDs and saved search IDs of all the
  dashboards and saved searches  that you have access to. They're
  all concatenated into one string and saved in the database. The
  limit of the column is 1000 characters. If you have many items
  and the value exceeds the limit, the dashboard display order
  preference is not saved and the error shown above is logged.
  

Problem conclusion

• A fix will be incorporated into an upcoming release that limits
  the number of persistent IDs when the revised preference is
  saved.
  

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