| Author |
Message
|
| shankar_kyr |
 Posted: Wed Jan 26, 2005 1:53 pm Post subject: dealing empty tags in mqsi |
 |
|
Newbie
Joined: 30 Jan 2004
Posts: 7
|
Hello,
I have an xml message in this form
<A>
<B></B>-----------empty tag
<C>Shankar</C>
</A>
Mqsi fails at <B> since it is empty. We are using MQSI 2.1 CSD05.Any suggestions.
Rgds
Shankar |
|
| Back to top |
|
 |
| kirani |
| Posted: Wed Jan 26, 2005 2:31 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Can you explain more about this failure. You should not get failures for empty tags. It's a valid XML message.
Please post your exceptionList.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| shankar_kyr |
| Posted: Thu Jan 27, 2005 6:24 am Post subject: dealing empty tags |
|
|
Newbie
Joined: 30 Jan 2004
Posts: 7
|
Hi Kiran,
Thanks for your time. I agree with what you say. That's why I put this posting. Though I work in MQseries but I am not an MQSI guy. So I am trying to help my team. Please find below the log information and the portion of xml message parsed by MQSI. The bolded portion in the xml message caused the mqsi to fail
************************Error Log********************
- <GIOSXML>
- <Exception>
- <RecoverableException>
<File>/build/S210_BP/src/DataFlowEngine/ImbComputeNode.cpp</File>
<Line>453</Line>
<Function>ImbComputeNode::evaluate</Function>
<Type>ComIbmComputeNode</Type>
<Name>77980eb8-f800-0000-0080-eabd28ae6ca3</Name>
<Label>GIOS.AUTO.RATING.REQUEST.GIOSXMLtoPICXML</Label>
<Text>Caught exception and rethrowing</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
- <RecoverableException>
<File>/build/S210_BP/src/DataFlowEngine/ImbRdl/ImbRdlCallableProcedure.cpp</File>
<Line>214</Line>
<Function>SqlCallableProcedure::execute</Function>
<Type>ComIbmComputeNode</Type>
<Name>77980eb8-f800-0000-0080-eabd28ae6ca3</Name>
<Label>GIOS.AUTO.RATING.REQUEST.GIOSXMLtoPICXML</Label>
<Text>Error occured in procedure</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2934</Number>
- <Insert>
<Type>5</Type>
<Text>mapCoverage</Text>
</Insert>
- <RecoverableException>
<File>/build/S210_BP/src/DataFlowEngine/ImbRdl/ImbRdlTypeCast.cpp</File>
<Line>194</Line>
<Function>SqlTypeCast::evaluate</Function>
<Type />
<Name />
<Label />
<Text>Error casting from %3 to %4</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2521</Number>
- <Insert>
<Type>2</Type>
<Text>608</Text>
</Insert>
- <Insert>
<Type>2</Type>
<Text>71</Text>
</Insert>
- <Insert>
<Type>5</Type>
<Text>CHARACTER</Text>
</Insert>
- <Insert>
<Type>5</Type>
<Text>DECIMAL</Text>
</Insert>
- <RecoverableException>
<File>/build/S210_BP/src/CommonServices/ImbDecimal.cpp</File>
<Line>763</Line>
<Function>ImbDecimal::ImbDecimal(ImbWstring::const_iterator, ImbWstring::const_iterator)</Function>
<Type />
<Name />
<Label />
<Text>Can't convert '%' into an exact numeric number. The ImbString must be of the form '[+|-]d+[.d+]'.</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2592</Number>
- <Insert>
<Type>5</Type>
<Text />
</Insert>
- <Insert>
<Type>2</Type>
<Text>31</Text>
</Insert>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
- <AppInfo>
<InputMsgId>414d51204d515349323142202020202041f7a39920000801</InputMsgId>
<BackoutQueue>ERROR.ORIGINAL.MESSAGE.Q</BackoutQueue>
</AppInfo>
</Exception>
</GIOSXML>
*********************************************************
***********portion of xml message*************
<CoverageCd>TPPD</CoverageCd>
<PrimaryLimitAmt>2000000</PrimaryLimitAmt>
<SecondaryLimitAmt>0</SecondaryLimitAmt>
<DeductibleAmt>0</DeductibleAmt>
<PremiumAmountGrp>
<AdjustedFullTermPremiumPct>0.00</AdjustedFullTermPremiumPct>
<PreviousAdjustedFullTermPremiumPct></PreviousAdjustedFullTermPremiumPct>
<PreviousFullTermPremiumAmt>0.00</PreviousFullTermPremiumAmt>
<AdjustedTransactionPremiumAmt>0.00</AdjustedTransactionPremiumAmt>
</PremiumAmountGrp>
<ActionCd>ADDED</ActionCd>
</Coverage>
<Coverage>
***********portion of xml message************* |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jan 27, 2005 6:30 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
This is telling you that you can't convert a NULL value to a number.
This is not a failure in the Product.
It is a failure in the code or the message model. The model should ensure that input data is valid, and the code should ensure that it handles all valid data cases properly.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| shankar_kyr |
| Posted: Thu Jan 27, 2005 6:47 am Post subject: dealing empty tags |
|
|
Newbie
Joined: 30 Jan 2004
Posts: 7
|
Hi Jeff,
You are saying that the code used in MQSI to parse the xml message
should be written properly.
Thanks
Shankar |
|
| Back to top |
|
|
| EddieA |
| Posted: Thu Jan 27, 2005 8:08 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| Quote: |
You are saying that the code used in MQSI to parse the xml message
should be written properly. |
No. Jeff is saying that whoever wrote the ESQL needs to write it properly.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jan 27, 2005 8:14 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| EddieA wrote: |
No. Jeff is saying that whoever wrote the ESQL needs to write it properly.
|
Yes.
That is what I am saying. The ESQL is wrong, or the message model that was developed was wrong - depending on the requirements. Either the requirements specified that the field could not be null, in which case the model is wrong because it does not validate against this (the tag is not required).. Or the requirements specified that the field could be NULL and the ESQL fails to check for it.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| shankar_kyr |
| Posted: Thu Jan 27, 2005 8:47 am Post subject: dealing empty tags in mqsi |
|
|
Newbie
Joined: 30 Jan 2004
Posts: 7
|
Thanks everybody.
Rgds
Shankar |
|
| Back to top |
|
|
|
|
