Dear forum members,

I am on ACE 12.0.6.0 and am using a Mapping node to execute some database retrieval using information set up in Environment.Variables. When the Mapping node executes, I am getting an error (from the trace node log):

====>>> Environment
( ['MQROOT' : 0x260e48240f0]
  (0x01000000:Name):Variables = (
    (0x03000000:NameValue):purchaseOrderNumber     = 155258 (INTEGER)
    (0x03000000:NameValue):purchaseOrderLineNumber = 1 (INTEGER)
  )
)

====>>> Exception List
( ['MQROOT' : 0x260e4824ab0]
  (0x01000000:Name):RecoverableException = (
    (0x03000000:NameValue):File                 = 'C:\ci\product-build\WMB\src\DataFlowEngine\PluginInterface\jlinklib\ImbJniNode.cpp' (CHARACTER)
    (0x03000000:NameValue):Line                 = 438 (INTEGER)
    (0x03000000:NameValue):Function             = 'ImbJniNode::evaluate' (CHARACTER)
    (0x03000000:NameValue):Type                 = 'ComIbmMSLMappingNode' (CHARACTER)
    (0x03000000:NameValue):Name                 = 'TEST_APP#FCMComposite_1_3' (CHARACTER)
    (0x03000000:NameValue):Label                = 'TEST_APP.Mapping' (CHARACTER)
    (0x03000000:NameValue):Catalog              = 'BIPmsgs' (CHARACTER)
    (0x03000000:NameValue):Severity             = 3 (INTEGER)
    (0x03000000:NameValue):Number               = 2230 (INTEGER)
    (0x03000000:NameValue):Text                 = 'Caught exception and rethrowing' (CHARACTER)
    (0x01000000:Name     ):Insert               = (
      (0x03000000:NameValue):Type = 14 (INTEGER)
      (0x03000000:NameValue):Text = 'TEST_APP.Mapping' (CHARACTER)
    )
    (0x01000000:Name     ):RecoverableException = (
      (0x03000000:NameValue):File                 = 'MbErrorHandler.java' (CHARACTER)
      (0x03000000:NameValue):Line                 = 151 (INTEGER)
      (0x03000000:NameValue):Function             = 'evaluate' (CHARACTER)
      (0x03000000:NameValue):Type                 = '' (CHARACTER)
      (0x03000000:NameValue):Name                 = '' (CHARACTER)
      (0x03000000:NameValue):Label                = '' (CHARACTER)
      (0x03000000:NameValue):Catalog              = 'BIPmsgs' (CHARACTER)
      (0x03000000:NameValue):Severity             = 3 (INTEGER)
      (0x03000000:NameValue):Number               = 3947 (INTEGER)
      (0x03000000:NameValue):Text                 = 'Caught BrokerXCIDynamicException' (CHARACTER)
      (0x01000000:Name     ):Insert               = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = '{default}:TEST_APP_Mapping' (CHARACTER)
      )
      (0x01000000:Name     ):Insert               = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = 'IXJXE0797E: [ERR 0712][ERR XPST0008] No binding was found for the external variable 'Environment'.' (CHARACTER)
      )

The content of the mapping node is quite simple:

And the select statement for the table (the where clause is generated when double-clicking the appropriate variable inside Environment/Variables):

I can't figure out what I am doing wrong here. 

Any suggestions?

Thanks,
Willem

Does the type integer match the DBType for IKONR and IKRNR ?

Yes, it does. But that is not what the Mapping node complains about. If I put the parameters inside the OutputRoot and use that in the Mapping node, it works as expected. If I put the parameters inside the Enviroment.Variables then the error 

No binding was found for the external variable 'Environment'.

occurs.

Instead of using the Environment variable, have you tried using the LocalEnvironment variable in your xpath expression?

------------------------------
Francois Brandelik
------------------------------

No binding was found for the external variable 'Environment'.

Hi

I was able to create a similar Mapping and successfully deploy and run on ACE v12.0.8.0.

After looking at our Mappings side by side I released the difference .. and when I modified my Map to not have a "Message Assembly" on the input side, I was able to reproduce the same issue, with the failure 

'IXJXE0797E: [ERR 0712][ERR XPST0008] No binding was found for the external variable 'Environment'.

The solution when you do not have anything in the input side message body for a Mapping is to just add the "BLOB" domain, and only map the Properties tree.

This is documented - but maybe needs to be shouted out a bit more.

See topic Input and output messages to a message map  , 

"In a message map, you must define a model for the input message and an output message.
...
BLOB: Use this message model to handle messages in the BLOB domain, or when you do not need to process any message body data."

So if you add "BLOB" as an input to your Map this should sort the issue


Hope this getting you moving forward

------------------------------
Martin Boag
Software Developer
IBM
------------------------------

No binding was found for the external variable 'Environment'.