APAR status
Closed as program error.
Error description
After application of IT06286 if an ESQL function exists in 2 different schemas that are both deployed at the same time then a BIP4190 exception is thrown during deployment or flow start up.
Local fix
<html>None </html>
Problem summary
**************************************************************** USERS AFFECTED: All users of IBM Integration Bus version 9 or version 10 using ESQL. Platforms affected: z/OS, MultiPlatform **************************************************************** PROBLEM DESCRIPTION: After application of IT06286 if an ESQL function exists in 2 different schemas that are both deployed at the same time then a BIP4190 exception is thrown during deployment or flow start up. <i>There are a number of resource name changes between WebSphere Message Broker and IBM Integration Bus Version 9.0. For details visit http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.e tools.mft.doc/bb23814_.htm</i>
Problem conclusion
An error is no longer thrown when multiple schemas contain the same function name. Additionally the resolution order is now well defined where a function exists in multiple schemas. If there is ambiguity where 2 possible schemas may be called the following search order is used, in descending order of priority: -The fully qualified schema path, if present -The schema of the calling code (the current schema) -The schemas on the path, in order -The default schema In order to maintain compatibility it is possible to alter the position of the default schema in the search resolution order. If the environment variable MQSI_ESQL_V9_PATH_RESOLUTION is set to any value then the resolution order is, in descending order or priority: -The fully qualified schema path (if present) -The schema of the calling code (current schema) -The default schema -The schemas on the path, in order --------------------------------------------------------------- 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 number
IT10062
Reported component name
INTEGRATION BUS
Reported component ID
5724J0530
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-07-14
Closed date
2016-01-06
Last modified date
2016-03-29
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
23 March 2020