Fixes are available
APAR status
Closed as program error.
Error description
There are two issues that need to be addressed: 1) After Business Process Manager is upgraded from Version 8.0 to Version 8.0.1 (via V8.0 Refresh Pack 1), the My Performance scoreboard in Process Portal fails to display any data. No error messages are displayed in Process Portal, but errors similar to the following are written to SystemOut.log (in the server or cluster where Process Portal is deployed): Trace: 2012/10/31 15:45:32.206 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: org.springframework.jdbc.core.JdbcTemplate.execute ExtendedMessage: Executing prepared SQL statement ? select usr_attr_def.name as name, attrs.attr_value as value, usr_attr_def_values.value as defvalue from LSW_USR_ATTR attrs left join LSW_RT_USER_ATTRIBUTE_DEF rt_usr_attr_def on attrs.user_attr_def_id = rt_usr_attr_def.user_attribute_id left join LSW_USER_ATTRIBUTE_DEF usr_attr_def on rt_usr_attr_def.user_attribute_id = usr_attr_def.user_attribute_id left join LSW_USER_ATTR_DEF_VALUES usr_attr_def_values on usr_attr_def_values.user_attr_def_value_id = attrs.user_attr_def_value_id and usr_attr_def_values.user_attribute_def _id = usr_attr_def.user_attribute_id where attrs.user_id = ? and rt_usr_attr_def.name = ? order by rt_usr_attr_def.last_modified ? Trace: 2012/10/31 15:45:32.207 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: org.springframework.jdbc.core.StatementCreatorUtils.setParameter ValueInternal ExtendedMessage: Setting SQL statement parameter value: column index 1, parameter value ?9?, value class ?java.lang.Long?, SQL typ e unknown Trace: 2012/10/31 15:45:32.209 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: org.springframework.jdbc.core.StatementCreatorUtils.setParameter ValueInternal ExtendedMessage: Setting SQL statement parameter value: column index 2, parameter value ?Locale?, value class ?java.lang.String?, SQL type unknown Trace: 2012/10/31 15:45:32.229 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: WLE.wle ExtendedMessage: CWLLG0373E: An error occurred while initializing the report chart instance. The chart instance did not initializ e. Error: ?TeamworksException name='Transformation: 'PM_Task Ids by Status', Chart: 'Task Status'', message='Internal Script error : com.lombardisoftware.server.eai.core.ConnectorException: DB2 SQL Error: SQLCODE=-199, SQLSTATE=42601, SQLERRMC=FROM;, ), DRIVER=3. 62.57', line=31, pos=0 nested=<none>?. ?TeamworksException name='Transformation: 'PM_Task Ids by Status', Chart: 'Task Status'', mes sage='Internal Script error: com.lombardisoftware.server.eai.core.ConnectorException: DB2 SQL Error: SQLCODE=-199, SQLSTATE=42601, S QLERRMC=FROM;, ), DRIVER=3.62.57', line=31, pos=0 nested=<none>? at com.lombardisoftware.core.script.js.JavaScriptRunner.execute(Jav aScriptRunner.java:307) at com.lombardisoftware.core.script.js.JavaScriptRunner.evalExpress ion(JavaScriptRunner.java:371) Trace: 2012/10/31 15:45:32.080 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: org.springframework.jdbc.core.JdbcTemplate.execute ExtendedMessage: Executing prepared SQL statement ?select FAVORITE_ID,NAME,EFFECTIVE_DATE,ITEM_TYPE,ITEM_ID,EXPOSED_SERVIC E_TYPE,E XPOSED_PROCESS_TYPE,CACHED_PROCESS_VERSION_ID,CACHED_BPD_VERSION _ID,CACHED_REPORT_VERSION_ID,CACHED_SCBD_VERSION_ID,CACHED_EPV_V ERSI ON_ID,CACHED_UCA_VERSION_ID,CACHED_WS_VERSION_ID,CACHED_SLA_VERS ION_ID,CACHED_EVENT_SUB_VERSION_ID,EVENT_SOURCE_ID,GROUP_ID,SNAP SHOT _ID,BRANCH_ID,ITEM_REF,TIP,ENABLED from LSW_FAVORITE where FAVORITE_ID = ?? Trace: 2012/10/31 15:45:32.081 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: org.springframework.jdbc.core.StatementCreatorUtils.setParameter ValueInternal ExtendedMessage: Setting SQL statement parameter value: column index 1, parameter value ?468?, value class ?java.math.BigDecimal?, SQL type unknown Trace: 2012/10/31 15:45:32.084 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: WLE.wle ExtendedMessage: CWLLG0381I: Oldreport is org.mozilla.javascript.UniqueTag@f2ab3853: NOT_FOUND. Trace: 2012/10/31 15:45:32.203 02 t=9BABE0 c=UNK key=P8 tag= (13007004) SourceId: WLE.wle ExtendedMessage: CWLLG2015E: An unexpected runtime exception occurred. See exception for more details. Error: Wrapped com.lombar disoftware.server.eai.core.ConnectorException: DB2 SQL Error: SQLCODE=-199, SQLSTATE=42601, SQLERRMC=FROM;, ), DRIVER=3.62.57 (<JSSc ript>#31).org.mozilla.javascript.WrappedException: Wrapped com.lombardisoftware.server.eai.core.ConnectorException: DB2 SQL Error: S QLCODE=-199, SQLSTATE=42601, SQLERRMC=FROM;, ), DRIVER=3.62.57 (<JSScript>#31) at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.ja va:1773) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:183) 2) In V8.0.1 (new or upgraded installation), the ability to correctly apply future maintenance (interim fixes, fix packs, or refresh packs) may be compromised. LOCAL FIX/WORKAROUND: None.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Business Process Manager V8.0.1 * * (all editions). * **************************************************************** * PROBLEM DESCRIPTION: There are two issues that need to be * * addressed: * * 1) After Business Process Manager is * * upgraded from Version 8.0 to Version * * 8.0.1 (via V8.0 Refresh Pack 1), the * * My Performance scoreboard in Process * * Portal fails to display any data. No * * error messages are displayed in * * Process Portal, but errors similar to * * the following are written to * * SystemOut.log (in the server or * * cluster where Process Portal is * * deployed): * * Trace: 2012/10/31 15:45:32.206 02 * * t=9BABE0 c=UNK key=P8 tag= * * (13007004) * * SourceId: * * org.springframework.jdbc.core.JdbcTempl * * ate.execute * * ExtendedMessage: Executing prepared * * SQL statement ? * * select usr_attr_def.name as name, * * attrs.attr_value as value, * * usr_attr_def_values.value as defvalue * * from LSW_USR_ATTR * * attrs * * left join LSW_RT_USER_ATTRIBUTE_DEF * * rt_usr_attr_def on * * attrs.user_attr_def_id = * * rt_usr_attr_def.user_attribute_id * * left join LSW_USER_ATTRIBUTE_DEF * * usr_attr_def on * * rt_usr_attr_def.user_attribute_id = * * usr_attr_def.user_attribute_id * * left join LSW_USER_ATTR_DEF_VALUES * * usr_attr_def_values on * * usr_attr_def_values.user_attr_def_value * * _id = * * attrs.user_attr_def_value_id and * * usr_attr_def_values.user_attribute_def * * _id = usr_attr_def.user_attribute_id * * where attrs.user_id = ? and * * rt_usr_attr_def.name * * = ? * * order by rt_usr_attr_def.last_modified * * ? * * Trace: 2012/10/31 15:45:32.207 02 * * t=9BABE0 c=UNK key=P8 tag= * * (13007004) * * SourceId: * * org.springframework.jdbc.core.Statement * * CreatorUtils.setParameter * * ValueInternal * * ExtendedMessage: Setting SQL * * statement parameter value: column * * index 1, parameter value ?9?, value * * class ?java.lang.Long?, SQL * * typ * * e unknown * * Trace: 2012/10/31 15:45:32.209 02 * * t=9BABE0 c=UNK key=P8 tag= * * (13007004) * * SourceId: * * org.springframework.jdbc.core.Statement * * CreatorUtils.setParameter * * ValueInternal * * ExtendedMessage: Setting SQL * * statement parameter value: column * * index 2, parameter value ?Locale?, * * value class * * ?java.lang.String?, * * SQL type unknown * * Trace: 2012/10/31 15:45:32.229 02 * * t=9BABE0 c=UNK key=P8 tag= * * (13007004) * * SourceId: WLE.wle * * ExtendedMessage: CWLLG0373E: An error * * occurred while * * initializing the report chart * * instance. The chart instance did * * not initializ * * e. Error: ?TeamworksException * * name='Transformation: 'PM_Task * * Ids by Status', Chart: 'Task * * Status'', message='Internal Script * * error * * : * * com.lombardisoftware.server.eai.core.Co * * nnectorException: DB2 * * SQL Error: SQLCODE=-199, * * SQLSTATE=42601, SQLERRMC=FROM;, ), * * DRIVER=3. * * 62.57', line=31, pos=0 * * nested=<none>?. ?TeamworksException * * name='Transformation: 'PM_Task Ids by * * Status', Chart: 'Task * * Status'', mes * * sage='Internal Script error: * * com.lombardisoftware.server.eai.core.Co * * nnectorException: DB2 SQL * * Error: SQLCODE=-199, SQLSTATE=42601, S * * QLERRMC=FROM;, ), DRIVER=3.62.57', * * line=31, pos=0 nested=<none>? * * at * * com.lombardisoftware.core.script.js.Jav * * aScriptRunner.execute(Jav * * aScriptRunner.java:307) * * at * * com.lombardisoftware.core.script.js.Jav * * aScriptRunner.evalExpress * * ion(JavaScriptRunner.java:371) * * Trace: 2012/10/31 15:45:32.080 02 * * t=9BABE0 c=UNK key=P8 tag= * * (13007004) * * SourceId: * * org.springframework.jdbc.core.JdbcTempl * * ate.execute * * ExtendedMessage: Executing prepared * * SQL statement ?select * * FAVORITE_ID,NAME,EFFECTIVE_DATE,ITEM_TY * * PE,ITEM_ID,EXPOSED_SERVIC * * E_TYPE,E * * XPOSED_PROCESS_TYPE,CACHED_PROCESS_VERS * * ION_ID,CACHED_BPD_VERSION * * _ID,CACHED_REPORT_VERSION_ID,CACHED_SCB * * D_VERSION_ID,CACHED_EPV_V * * ERSI * * ON_ID,CACHED_UCA_VERSION_ID,CACHED_WS_V * * ERSION_ID,CACHED_SLA_VERS * * ION_ID,CACHED_EVENT_SUB_VERSION_ID,EVEN * * T_SOURCE_ID,GROUP_ID,SNAP * * SHOT * * _ID,BRANCH_ID,ITEM_REF,TIP,ENABLED * * from LSW_FAVORITE where * * FAVORITE_ID = ?? * * Trace: 2012/10/31 15:45:32.081 02 * * t=9BABE0 c=UNK key=P8 tag= * * (13007004) * * SourceId: * * org.springframework.jdbc.core.Statement * * CreatorUtils.setParameter * * ValueInternal * * ExtendedMessage: Setting SQL * * statement parameter value: column * * index 1, parameter value ?468?, value * * class * * ?java.math.BigDecimal?, * * SQL type unknown * * Trace: 2012/10/31 15:45:32.084 02 * * t=9BABE0 c=UNK key=P8 tag= * * (13007004) * * SourceId: WLE.wle * * ExtendedMessage: CWLLG0381I: * * Oldreport is * * org.mozilla.javascript.UniqueTag@f2ab38 * * 53: NOT_FOUND. * * Trace: 2012/10/31 15:45:32.203 02 * * t=9BABE0 c=UNK key=P8 tag=(13007004) * * SourceId: WLE.wle * * ExtendedMessage: CWLLG2015E: An * * unexpected runtime exception * * occurred. See exception for more * * details. Error: Wrapped * * com.lombardisoftware.server.eai.core.Co * * nnectorExc * * eption: DB2 SQL Error: * * SQLCODE=-199, SQLSTATE=42601, * * SQLERRMC=FROM;, ), DRIVER=3.62.57 * * (<JSScript>#31).org.mozilla.javascript. * * WrappedException: Wrapped * * com.lombardisoftware.server.eai.core.Co * * nnectorException: DB2 SQL Error: * * SQLCODE=-199, SQLSTATE=42601, * * SQLERRMC=FROM;, ), DRIVER=3.62.57 * * (<JSScript>#31) * * at * * org.mozilla.javascript.Context.throwAsS * * criptRuntimeEx(Context.java:1773) * * at * * org.mozilla.javascript.MemberBox.invoke * * (MemberBox.java:183) * * 2) In V8.0.1 (new or upgraded * * installation), the ability * * to correctly apply future maintenance * * (interim fixes, fix * * packs, or refresh packs) may be * * compromised. * **************************************************************** * RECOMMENDATION: * **************************************************************** There is an issue with version identifiers in the database, introduced with Version 8.0.1.
Problem conclusion
The version identifiers have been corrected in an interim fix that is mandatory for Version 8.0.1. - If you are installing Business Process Manager Version 8.0.1 (new Business Process Manager installation), you must install the interim fix prior to bootstrapping the database. - If you are upgrading Business Process Manager from Version 8.0 to Version 8.0.1 (via Version 8.0 Refresh Pack 1 (http://www.ibm.com/support/docview.wss?uid=swg24033777)), you must install the interim fix concurrently with Version 8.0 Refresh Pack 1. Failure to install the interim fix at the appropriate time may prevent proper installation of future interim fixes, fix packs, and refresh packs. The interim fix is available on Fix Central. Note that if you install Version 8.0 Refresh Pack 1 via the internet (Installation Manager finds the repository for Version 8.0.1 after you select Update from the main panel), this interim fix will automatically be selected for installation, and you do not need to separately download and unpack this interim fix.
Temporary fix
Comments
APAR Information
APAR number
JR44669
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-11-07
Closed date
2012-11-21
Last modified date
2012-11-21
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
R800 PSY
UP
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1"}]
Document Information
Modified date:
06 October 2021