|   | 
	 
  
    | 
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: 20768 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: 20768 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
  | 
  		 
	   
	 | 
   
 
  	 | 
	  |