JR42957: UPGRADE FROM 6.1 to 7.5.x FAILS WHEN A SQL CONNECTOR THAT ALLOWS TO SET THE RETURN TYPE AS A PARAMETER IS BEING USED.

Version 7.5.1 Fix Pack 1 for the IBM Business Process Manager products
Version 8.0 Refresh Pack 1 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• The problem appears when the model contains an SQLConnector,
  which returns some value to Complex Variable. If it is mapped to
  BPD, upgrade fails on instance level, if it is private inside
  the service then upgrade fails on tasks level. This
  problem can be reproduced only when upgrading from TW6.1.
  
  
  Reproduction steps :
  
  (1) Create a Service 'serv1' with SQL Execute Statement
  subservice from System Data.
  (2) Create a Complex Variable Type 'uNamePair' with the
  following parameters:
  -- USER_NAME of String;
  -- FULL_NAME of String.
  (3) For created above service, navigate to Variables type and
  create a new output variable 'outVar' of created above Complex
  Type 'uNamePair'.
  (4) For SQL Execute Statement subservice specify the following
  parameters on Data Mapping tab:
  -- sql: "SELECT USER_NAME, FULL_NAME from LSW_USR"
  -- parameters: leave default
  -- maxRows: 10
  -- returnType: "uNamePair"
  -- dataSourceName: leave default
  -- results: tw.local.outVar
  (5) Create a BPD with the nested service 'serv1', which created
  above.
  (6) Automap the output variable on Data Mapping tab.
  (7) Create one more activity with the default service.
  (8) Save and start few instances of this BPD.
  (9) Perform the upgrade to BPM 7.5.1
  ===> Exception appears:
  TWU-0013: Failed to read serialized form
  java.lang.UnsupportedOperationException
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Users upgrading from Teamworks 6.x to       *
  *                  BPM 7.5.x.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The problem appears when the model      *
  *                      contains an SQLConnector,               *
  *                      which returns some value to Complex     *
  *                      Variable. If it is mapped to            *
  *                      BPD, upgrade fails on instance level,   *
  *                      if it is private inside                 *
  *                      the service then upgrade fails on       *
  *                      tasks level. This                       *
  *                      problem can be reproduced only when     *
  *                      upgrading from TW6.1.                   *
  *                      Reproduction steps :                    *
  *                      (1) Create a Service 'serv1' with SQL   *
  *                      Execute Statement                       *
  *                      subservice from System Data.            *
  *                      (2) Create a Complex Variable Type      *
  *                      'uNamePair' with the                    *
  *                      following parameters:                   *
  *                      -- USER_NAME of String;                 *
  *                      -- FULL_NAME of String.                 *
  *                      (3) For created above service,          *
  *                      navigate to Variables type and          *
  *                      create a new output variable 'outVar'   *
  *                      of created above Complex                *
  *                      Type 'uNamePair'.                       *
  *                      (4) For SQL Execute Statement           *
  *                      subservice specify the following        *
  *                      parameters on Data Mapping tab:         *
  *                      -- sql: "SELECT USER_NAME, FULL_NAME    *
  *                      from LSW_USR"                           *
  *                      -- parameters: leave default            *
  *                      -- maxRows: 10                          *
  *                      -- returnType: "uNamePair"              *
  *                      -- dataSourceName: leave default        *
  *                      -- results: tw.local.outVar             *
  *                      (5) Create a BPD with the nested        *
  *                      service 'serv1', which created          *
  *                      above.                                  *
  *                      (6) Automap the output variable on      *
  *                      Data Mapping tab.                       *
  *                      (7) Create one more activity with the   *
  *                      default service.                        *
  *                      (8) Save and start few instances of     *
  *                      this BPD.                               *
  *                      (9) Perform the upgrade to BPM 7.5.1    *
  *                      ===> Exception appears:                 *
  *                      TWU-0013: Failed to read serialized     *
  *                      form                                    *
  *                      java.lang.UnsupportedOperationException *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The problem appears when the model contains an SQLConnector,
  which returns some value to Complex Variable. If it is mapped
  to
  BPD, upgrade fails on instance level, if it is private inside
  the service then upgrade fails on tasks level. This
  problem can be reproduced only when upgrading from TW6.1.
  Reproduction steps :
  (1) Create a Service 'serv1' with SQL Execute Statement
  subservice from System Data.
  (2) Create a Complex Variable Type 'uNamePair' with the
  following parameters:
  -- USER_NAME of String;
  -- FULL_NAME of String.
  (3) For created above service, navigate to Variables type and
  create a new output variable 'outVar' of created above Complex
  Type 'uNamePair'.
  (4) For SQL Execute Statement subservice specify the following
  parameters on Data Mapping tab:
  -- sql: "SELECT USER_NAME, FULL_NAME from LSW_USR"
  -- parameters: leave default
  -- maxRows: 10
  -- returnType: "uNamePair"
  -- dataSourceName: leave default
  -- results: tw.local.outVar
  (5) Create a BPD with the nested service 'serv1', which created
  above.
  (6) Automap the output variable on Data Mapping tab.
  (7) Create one more activity with the default service.
  (8) Save and start few instances of this BPD.
  (9) Perform the upgrade to BPM 7.5.1
  ===> Exception appears:
  TWU-0013: Failed to read serialized form
  java.lang.UnsupportedOperationException
  

Problem conclusion

• Problem was fixed in an interim fix and in future
  releases/fixpacks.
  

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 STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R750 PSY

     UP