IBM Support

Referenced ESQL modules that are compiled as 'in-line ESQL' fail with error BIP3947E

Technote (troubleshooting)


Your IBM Integration Bus or WebSphere Message Broker message flow fails to process a message map, and a BIP3947E error is displayed


A user or service level trace report includes the following:

UserTrace BIP3960I: The Mapping node is adding a new element with name ''<name>'' into the output tree.
RecoverableException BIP3947E: The map processing for QName ''<queue name>'' has failed, with the following details: ''''.


The deployed message map contains a reference to an ESQL module that was compiled as part of the broker archive (BAR) file.

ESQL files that contain referenced ESQL modules must be deployed as "ESQL source".
ESQL modules that are contained in "In-line ESQL" or "compiled message flows" (.cmf files) cannot be identified by a message map.

Diagnosing the problem

A service level trace reports the following error:
ImbESQLEngineInterface::callRoutine , 'Throwing exception',
'/build/slot1/S800_P/src/DataFlowEngine/ImbRdl/ImbESQLEngineInterface.cpp', 408,
'BIP4188', 'routine missing', '#XFORMEVENTNAME'

Resolving the problem

In WebSphere Message Broker V8.0.0.1 and later, there is an option to build a BAR file "as ESQL Source". Use this option when building BAR files that include custom ESQL modules that are called by message maps. Selecting this option allows the message map (.map file) to correctly reference the custom ESQL modules after they are deployed.

Related information

InfoCenter - Custom ESQL

Cross reference information
Segment Product Component Platform Version Edition
Business Integration IBM Integration Bus Deploy AIX, HP-UX, Linux, Solaris, Windows, z/OS 9.0 All Editions

Product Alias/Synonym

WMB MB WebSphere Message Broker IBM Integration Bus IIB IBMIB MQ Integrator WBIMB WBI-MB MQSI WMQI

Document information

More support for: WebSphere Message Broker

Software version: 8.0

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows, z/OS

Reference #: 1611691

Modified date: 05 September 2013