Direct link to fix
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 number
JR58030
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-06-13
Closed date
2017-08-29
Last modified date
2017-08-29
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:
29 August 2017