IBM Support

JR44669: MY PERFORMANCE SCOREBOARD DOES NOT DISPLAY ANY DATA AFTER UPGRADE TO VERSION 8.0.1, AND FUTURE MAINTENANCE IMPACTED

Subscribe

You can track all active APARs for this component.

 

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

[{"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":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
21 November 2012