IBM Support

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.

Subscribe

You can track all active APARs for this component.

 

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 number

    JR42957

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-31

  • Closed date

    2012-08-08

  • Last modified date

    2012-08-08

  • 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

[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1"}]

Document Information

Modified date:
07 October 2021