IT05392: FLOW API DOES NOT CORRECTLY HANDLE THE ESQLMODULE TYPE

WebSphere Message Broker Toolkit Version 8.0 Fix Pack 7
IBM Integration Toolkit version 9.0 Fix Pack 6
WebSphere Message Broker Toolkit Version 8.0 Fix Pack 8
IBM Integration Toolkit version 9.0 Fix Pack 4

APAR status

• Closed as program error.

Error description

• The IBM Integration Bus Message Flow API does not correctly
  recognize the property type "ESQL Module" of the following
  properties:
  -Compute node "ESQL module" property
  -Database node "Statement" property
  -DatabaseInput node "ESQL module" property
  -Filter node "Filter expression" property
  
  This becomes problematic if the "ESQL Module" property is
  promoted in a (sub)flow and the (sub)flow is in turn used as
  a template to a pattern. When the pattern is instantiated, the
  "ESQL Module" property is generated with the incorrect type,
  String, instead of the correct type, EsqlModule. The (sub)flow
  is marked with the error "Property ''
  promoted from node '' does not match original
  property type".
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of WebSphere Message Broker V8.0 or IBM Integration
  Bus V9.0 and V10.0 who use a (sub)flow with a promoted property
  of type "ESQL module" as a template to create a pattern.
  
  
  Platforms affected:
  MultiPlatform, z/OS
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When a node property is promoted, its type is also promoted
  (persisted in the (sub)flow).
  During pattern instantiation, the Message Flow API reads all
  template (sub)flows and then writes them out with any
  refinements the user may have specified.
  The "ESQL module" type was missing from the Message Flow API. As
  a result, when a (sub)flow is generated during pattern
  instantiation, all the properties that are of "ESQL module" type
  are generated as strings. The generated (sub)flow is also marked
  with the error "Property '' promoted from node '' does not match
  original property type".
  
  The properties whose types are "ESQL module" are:
  -Compute node "ESQL module" property
  -Database node "Statement" property
  -DatabaseInput node "ESQL module" property
  -Filter node "Filter expression" property
  

Problem conclusion

• The product now correctly generates the "ESQL module" type.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v8.0       8.0.0.7
  v9.0       9.0.0.4
  v10.0      10.0.0.2
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  INTEGRATION BUS

• Fixed component ID

  5724J0530

Applicable component levels

• R900 PSY

     UP