MQSeries.net :: View topic

Subha

We are doing transformation using mapping node. Source has three fields and we are using fn:count() to populate them with some condition 1,2,3 for each fields.

So for the first field when condition 1 is not met , we expect field2 and field3 to have count value.

We are able to get the result when field 1 is mapped. If field1 has no value to be mapped and field 2 and 3 are mapped, it throws error after completing mapping.

It looks like fn:count() keeps some stack which creates problem when first field does not have any value to be mapped.

It would be great if you could give some insight.
thanks!

Here is the error we got in mqsi Trace
------------------------------------------------
See the following messages for details of the error.
RecoverableException BIP2488E: ('Test_MsgFlow', '3754.2') Error detected whilst executing the SQL statement ''PROPAGATE FINALIZE DEFAULT DELETE DEFAULT;''.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.

See the following messages for details of the error.
RecoverableException BIP2112E: Message broker internal error: diagnostic information '', '{1}'.
An internal software error has occurred in the message broker. Further messages will indicate the effect of this error on the broker's transactions.

Shutdown and restart the message broker. If the problem continues to occur, then restart the system. If the problem still continues to occur contact your IBM support center.
_________________
Subh