| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Handling no data found in mapping transformation |
« View previous topic :: View next topic » |
| Author |
Message
|
| ajayrana |
 Posted: Wed Jun 04, 2014 12:42 am Post subject: Handling no data found in mapping transformation |
 |
|
Apprentice
Joined: 08 May 2014
Posts: 35
|
Hi,
I am trying to select some database records and pushing them out through an xml. This workflow of mine works well if the data is present for the where clause. In case there is no data I get an XM as below:
| Code: |
<?xml version="1.0" encoding="UTF-8" ?>
<SOAP-ENV:Envelope>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Server</faultcode>
<faultstring>BIP3113E: Exception detected in message flow CardInquiry (broker IB9NODE)</faultstring>
<faultactor>http://localhost:7080/cards</faultactor>
<detail>
<text>Exception. BIP2230E: Error detected whilst processing a message in node 'CardInquiry.Compute'. : /build/slot2/S000_P/src/DataFlowEngine/SQLNodeLibrary/ImbComputeNode.cpp: 497: ImbComputeNode::evaluate: ComIbmComputeNode: CardInquiry#FCMComposite_1_5 BIP2488E: ('.CardInquiry_Compute.Main', '4.6') Error detected whilst executing the SQL statement ''CopyEntireMessage();''. : /build/slot2/S000_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 666: SqlStatementGroup::execute: : BIP2934E: Error detected whilst executing the function or procedure ''CopyEntireMessage''. : /build/slot2/S000_P/src/DataFlowEngine/ImbRdl/ImbRdlRoutine.cpp: 1222: SqlRoutine::invoke: : BIP2488E: ('.CardInquiry_Compute.CopyEntireMessage', '8.5') Error detected whilst executing the SQL statement ''PROPAGATE TO LABEL 'card' FINALIZE DEFAULT DELETE DEFAULT;''. : /build/slot2/S000_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 666: SqlStatementGroup::execute: : BIP2230E: Error detected whilst processing a message in node 'CardInquiry.Mapping1'. : /build/slot2/S000_P/src/DataFlowEngine/PluginInterface/ImbJniNode.cpp: 1304: ImbJniNode::evaluate: ComIbmMSLMappingNode: CardInquiry#FCMComposite_1_8 BIP4367E: The method ''evaluate'' in Java node ''Mapping1'' has thrown the following exception: 'java.lang.NullPointerException'. : /build/slot2/S000_P/src/DataFlowEngine/PluginInterface/com_ibm_broker_plugin_CMbService.cpp: 1871: ImbJavaExceptionUtils::throwableToNativeException: : BIP4395E: Java exception: ''java.lang.NullPointerException''; thrown from class name: ''com.ibm.broker.ct.mapping.MappingNode'', method name: ''buildAndPropagate'', file: ''MappingNode.java'', line: '573' : /build/slot2/S000_P/src/DataFlowEngine/PluginInterface/com_ibm_broker_plugin_CMbService.cpp: 1889: ImbJavaExceptionUtils::throwableToNativeException: :</text>
</detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope> |
I can try to parse this XML and display appropriate message saying no data found but the catch is when i tried the same flow after renaming the table in database, i received the same XML as output.
It will be great if somebody can guide me to some example/option for handling such exceptions.
Thanks & Regards
Ajay Rana |
|
| Back to top |
|
 |
| ajayrana |
| Posted: Wed Jun 04, 2014 5:56 am Post subject: |
|
|
Apprentice
Joined: 08 May 2014
Posts: 35
|
Hi All,
The issue was in my mapping transformation. I was linking the for each with the collection of records on the other side. Connecting it to a single record resolved the issue. Now I am able to handle no data found and other technical failure message.
Thanks & Regards
Ajay Rana |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
