APAR status
Closed as program error.
Error description
A Mapping node with a Graphical Data Map can fail to deploy, due to a map generation internal error. This can occur if the mapping includes the use of If/Else transforms to a database column as part of an insert or update transform. A product trace of the deploy failure will show the root cause error of the form: Error: Map <name> could not generate the xquery transformation. ErrorCode: 4 Location: 'Insert table <name> column <name> Message: 'Missing input value'
Local fix
It might be possible to avoid the issue by replacing nested If/Else transform logic with a Custom XPath transform.
Problem summary
**************************************************************** USERS AFFECTED: All users of IBM Integration Bus V10.0 who use the Mapping node with Graphical Data Maps that include Insert or Update with If/Else mappings. Platforms affected: z/OS, MultiPlatform **************************************************************** PROBLEM DESCRIPTION: A Mapping node with a Graphical Data Map can fail to deploy, due to a map generation internal error. This can occur if the mapping includes the use of If/Else transforms to a database column as part of an insert or update transform. A product trace of the deploy failure will show the root cause error of the form: Error: Map <name> could not generate the xquery transformation. ErrorCode: 4 Location: 'Insert table <name> column <name> Message: 'Missing input value' 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
Problem conclusion
The Graphical Data Map internal generation from the .map file is corrected to ensure that If/Else transforms to database columns inside a Database Insert or Update are correctly processed. --------------------------------------------------------------- The fix is targeted for delivery in the following PTFs: Version Maintenance Level v10.0 10.0.0.8 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
IT18694
Reported component name
INTEGRATION BUS
Reported component ID
5724J0540
Reported release
A00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-06
Closed date
2017-03-16
Last modified date
2017-03-16
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
5724J0540
Applicable component levels
RA00 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":"10.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
23 March 2020