ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » FileInput Node WBI V6.1.0.8 packed decimal, no sign found

Post new topic  Reply to topic
 FileInput Node WBI V6.1.0.8 packed decimal, no sign found « View previous topic :: View next topic » 
Author Message
Michaelscof
PostPosted: Wed Jun 29, 2011 7:52 pm    Post subject: FileInput Node WBI V6.1.0.8 packed decimal, no sign found Reply with quote

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
View user's profile Send private message
fjb_saper
PostPosted: Wed Jun 29, 2011 8:18 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Michaelscof
PostPosted: Wed Jun 29, 2011 9:42 pm    Post subject: Reply with quote

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
View user's profile Send private message
fjb_saper
PostPosted: Thu Jun 30, 2011 2:29 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » FileInput Node WBI V6.1.0.8 packed decimal, no sign found
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.