| Author | 
		  Message
		 | 
		
		  | sarasu | 
		  
		    
			  
				 Posted: Sat Feb 09, 2013 2:00 pm    Post subject: DFDL Serialization error | 
				     | 
			   
			 
		   | 
		
		
		   Master
 
 Joined: 02 Feb 2006 Posts: 229
  
  | 
		  
		    
			  
				I have created a test service using MB8 toolkit /MB8 runtime. And within the compute node, I have used a select statement to retrieve data from the sql DB. I am able to see the response successfully.
 
 
But when i tried using a different scenario as below.
 
 
XMLNSC --> DFDL (Defined from a cobol copy book) --> MQOutput. ( In this process, getting the serialization error when it connects to the DB.
 
SQL statement used:
 
SET TEMP = THE (SELECT ITEM T.NAME FROM Database.TestTABLE AS T Where T.UNIQUEID = TEMP_UNIQUEID);
 
 
Please advise. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | fjb_saper | 
		  
		    
			  
				 Posted: Sat Feb 09, 2013 2:52 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 18 Nov 2003 Posts: 20768 Location: LI,NY 
  | 
		  
		    
			  
				And how is the ESQL statement related to the other information you are giving us? Remember mind readers we are not!   _________________ MQ & Broker admin | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | kimbert | 
		  
		    
			  
				 Posted: Sat Feb 09, 2013 4:14 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 29 Jul 2003 Posts: 5543 Location: Southampton 
  | 
		  
		    
			  
				
   
	| Quote: | 
   
  
	| In this process, getting the serialization error when it connects to the DB | 
   
 
How can we help you to avoid this 'serialization error' if you do not tell us what the error says? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | sarasu | 
		  
		    
			  
				 Posted: Mon Feb 11, 2013 6:30 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Master
 
 Joined: 02 Feb 2006 Posts: 229
  
  | 
		  
		    
			  
				Please fidnt he below error details I was getting.
 
 
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
 
   <soapenv:Body>
 
      <soapenv:Fault>
 
         <faultcode>soapenv:Server</faultcode>
 
         <faultstring>BIP3113E: Exception detected in message flow gen.Test.SOAP Input (broker TEST_BRKR1)</faultstring>
 
         <detail>
 
            <Text>BIP2230E: Error detected whilst processing a message in node 'gen.Test.MQ Output'. 
 
The message broker detected an error whilst processing a message in node 'gen.Test.MQ Output'. An exception has been thrown to cut short the processing of the message. 
 
See the following messages for details of the error. : /build/slot1/S800_P/src/DataFlowEngine/ImbMqOutputNode.cpp: 876: ImbMqOutputNode::evaluate: ComIbmMQOutputNode: gen/Test#FCMComposite_1_8.gen/operation1_Request_Response#FCMComposite_1_5
 
BIP5831E: The DFDL serializer signalled that a processing error occurred.  The message from the DFDL serializer is:  'CTDU4004E: The DFDL serializer cannot output element 'PASSWORD_DATA' because it does not match an element declaration at the current position in the DFDL schema model.'  The element being serialized was:  '/DFDL/RECORD/INFO/PWD_DATA' 
 
Processing errors occurred during the serializing of a DFDL message tree. 
 
Review and resolve the problems indicated in the message from the DFDL serializer by modifying or deleting the specified element from the DFDL message tree. : /build/slot1/S800_P/src/MTI/MTIforBroker/DfdlParser/ImbDFDLErrorHandler.cpp: 314: ImbDFDLErrorHandler::handleSerializerErrors: ComIbmSOAPInputNode: gen/Test#FCMComposite_1_1</Text>
 
         </detail>
 
      </soapenv:Fault>
 
   </soapenv:Body>
 
</soapenv:Envelope>
  Last edited by sarasu on Mon Feb 11, 2013 2:19 pm; edited 1 time in total | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | lancelotlinc | 
		  
		    
			  
				 Posted: Mon Feb 11, 2013 7:06 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 22 Mar 2010 Posts: 4941 Location: Bloomington, IL USA 
  | 
		  
		    
			  
				I found that error:  The DFDL serializer cannot output element 'GKPR_BP_RACF_PASSWORD_DATA' because it does not match an element declaration at the current position in the DFDL schema model.
 
 
What is your plan to solve this error? _________________ http://leanpub.com/IIB_Tips_and_Tricks
 
Save $20: Coupon Code: MQSERIES_READER | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | smdavies99 | 
		  
		    
			  
				 Posted: Mon Feb 11, 2013 7:25 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land. 
  | 
		  
		    
			  
				
   
	| sarasu wrote: | 
   
  
	
 
 
 'GKPR_BP_RACF_PASSWORD_DATA' 
 
 
 | 
   
 
 
 
Please obfuscate field names like this RACF is a huge give away for many of us.
 
 
You might also be breaching confidentiality rukes when using real data names on a public forum. _________________ WMQ User since 1999
 
MQSI/WBI/WMB/'Thingy' User since 2002
 
Linux user since 1995
 
 
 
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | kimbert | 
		  
		    
			  
				 Posted: Mon Feb 11, 2013 12:34 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 29 Jul 2003 Posts: 5543 Location: Southampton 
  | 
		  
		    
			  
				Your message tree is a tree of names and values. The DFDL serializer cannot match the names in your message tree to the names in the DFDL xsd.
 
 
We cannot solve this for you - you may need to take a debug-level user trace ( using command-line commands mqsichangetrace, mqsireadlog, mqsiformatlog ). Then you will be able to see exactly how much of your message tree *did* match the xsd, and exactly where the problem has occurred.
 
 
However, there might be enough information to solve the problem in the error message, if you read it very carefully. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | sarasu | 
		  
		    
			  
				 Posted: Mon Feb 11, 2013 2:15 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Master
 
 Joined: 02 Feb 2006 Posts: 229
  
  | 
		  
		    
			  
				I found that error: The DFDL serializer cannot output element 'PASSWORD_DATA' because it does not match an element declaration at the current position in the DFDL schema model. 
 
 
What is your plan to solve this error?
 
 
This is correct lancelotlinc & Kimbert. I have changed the position of the filed as per the DFDL and its working now.
 
 
Thanks for the catch.
 
 
Thanks | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | kimbert | 
		  
		    
			  
				 Posted: Mon Feb 11, 2013 2:46 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 29 Jul 2003 Posts: 5543 Location: Southampton 
  | 
		  
		    
			  
				Glad it's working for you now. 
 
   
	| Quote: | 
   
  
	| Thanks for the catch. | 
   
 
You're welcome. But you did not really need our help - the error message was perfectly clear. Two lessons from this:
 
- try to provide enough information to allow us to actually answer you questions
 
- read error messages carefully before asking for help | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |