MQSeries.net :: View topic - Issue while transforming Comp 3 field SV999 in MQSI

kavitak · Posted: Thu Oct 11, 2007 6:34 am Post subject:

Hi All

We are using MQ 6.0 and MQSI 2.1.

I have a requirement to read an BLOB message and am having problems. The message that I place appears to be correct in length and format but in all instances as soon as I go near the MRM parser it gives the following error.

2592 ConversionException BIP5505E: Data conversion failed: data invalid.
Type of data being read : 'packed decimal, no sign found '
Data : '0x4040'
A data conversion during reading or writing of a message failed because the input data was invalid for the output data type.
Check that the message model is correct. Review previous messages for details of the message set and message type.
Check that the processed message is of the expected format and type.

Code:
DECLARE AMTFEE DECIMAL;

SET AMTFEE = CAST("InputRoot"."MRM"."FEES" AS DECIMAL(4,3));

I read the message as BLOB and then converting it using a ResetContentDescriptor node. Then the fields are transformed using CAST function.
The element for which this error is thrown is having definition as SV999 Usage COMP3 and Length as 2 bytes.

I can not change the version from 2.1 to 6 as of now as my company is using the older version only.

Can any one help on this issue.

Thanks in anticipation
Kavita
_________________
Use what talents you possess; The woods would be very silent if no birds sang there except those that sang best."
- William Blake