|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
FileInput Node WBI V6.1.0.8 packed decimal, no sign found |
« View previous topic :: View next topic » |
Author |
Message
|
Michaelscof |
Posted: Wed Jun 29, 2011 7:52 pm Post subject: FileInput Node WBI V6.1.0.8 packed decimal, no sign found |
|
|
Novice
Joined: 12 Nov 2009 Posts: 10
|
Using FileInput Node to prase a file which was coming from Main Frame, but i keep getting below error.
I imported the copybook and created the messagedefination file. I am getting the below error when conveting the field DLT-AUD-PAID-AMT PIC S9(09)V99 COMP-3. from the exsisting copybook.
I check the field properties to default and nillable.Physical properties checked as singed and representation of null values specified as NullLiteralFIll and Space. Is there anything i need to mention in fileinput node properties to parse it correctly. I need very desperate help on this one :hel p:
The copy book field which
ParserException BIP5285E: Parsing errors have occurred.
Message set name: 'WCPayGoPolicyListFileProcessing_MsgSet'
Message format: 'CWF1'
Message type path: '/msg_WSOUTDTLREC/DTL_TRAN_TYPE'
Review other error messages to find the cause of the errors.
2011-06-29 14:00:21.483463 6320 ParserException BIP5171E: An error occurred while a Custom Wire Format message was being parsed:
Current message: 'msg_WSOUTDTLREC'
Current element: 'DTL_AUD_PAID_AMT'
Path from message root: '/msg_WSOUTDTLREC'
Offset from start of message: 26
See the following errors for more details.
2011-06-29 14:00:21.483470 6320 ConversionException BIP5505E: A data conversion failed because the data was invalid.
Type of data being read: 'packed decimal, no sign found '
Data: '0x00000160da25'
Data conversion when reading or writing a message failed because the input data was invalid for the output data type.
Review other error messages for details of the message set and message type.
Check that the message model is correct and that the processed message is of the expected format and type. Specifically, the following actions might help to resolve the problem:
1. Check that the bit stream is correctly aligned with the model. For example, check the lengths of input elements against the model.
2. Check that the input message has the correct Encoding and Coded Character Set ID applied to the message body.
3. Check that the input message has an appropriate WebSphere MQ format applied to the message body.
4. If the error occured for a numeric field then check that the input data is compatible with the physical format settings defined in the model.
5. If the input message is incompatible with the MRM model definitions then check the message at source[/code] |
|
Back to top |
|
 |
fjb_saper |
Posted: Wed Jun 29, 2011 8:18 pm Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
OK so it says the data is invalid as compared to the model.
When you ingest the copy book (wizard) there are a few decisions to be made on the 3rd and last pannel.
Can you please tell us what values the fields on that pannel had?
Have fun  _________________ MQ & Broker admin |
|
Back to top |
|
 |
Michaelscof |
Posted: Wed Jun 29, 2011 9:42 pm Post subject: |
|
|
Novice
Joined: 12 Nov 2009 Posts: 10
|
Thanks for your quick response.
Below is the wizard information in the 3rd panel or last panel for the mxsd creation.
Complier information:
Source plateform :Win32
codepage:ISO8859_1
FloatingPointFormat: IEEE Non-Extended
Storage Layout:
Byte Order : Little endian
External Decimal Sign: ASCII
Compile Options:
Quote : DOUBLE
trunc: STD
Nsymbol: NATIONAL
Null character:SPACE
padding character for strings SPACE
[/list][/code] |
|
Back to top |
|
 |
fjb_saper |
Posted: Thu Jun 30, 2011 2:29 pm Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
Seems you left everything as default...
Usually we do following:
- source platform is being set to the platform where the flow will be running (AIX for us)
- code page : we leave it alone
- floating point format => you might want to try the zos option
- byte order: we set the value in the middle (big endian) Probably to match AIX platform? or to match source data?
- External Decimal Sign => you might want to look if there is a zos option
- we also check "all fields nillable"
Have fun  _________________ MQ & Broker admin |
|
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
|
|
|
|