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 » DFDL error

Post new topic  Reply to topic
 DFDL error « View previous topic :: View next topic » 
Author Message
laddu858
PostPosted: Thu Jun 19, 2014 8:12 am    Post subject: DFDL error Reply with quote

Novice

Joined: 19 May 2008
Posts: 10

Hi Guys, Please need some help on the dfdl,

I have a input message with csv format(see below) and i was able to parse the message successfully, but how can i handle the 'XOA' and the value at the end of the message ( 340) in dfdl.

I/P message:

20140618,211138.337,01,0741,20140627,XXX,XXX,P, 0, 20, 0, 0, 379,CBP, 140, 140, 140, 140, 140, 140, 140, 220, 300,LBP, 380, 380, 380, 380, 380, 380, 380, 380, 380,OBP, 380, 380, 380, 380, 380, 380, 380, 380, 380,RBP, 380, 380, 380, 380, 380, 380, 380, 380, 380
20140618,211140.125,01,1557,20140703,XXX,XXX,Y, 242, 33, 0, 0, 0,CBP, 220, 220, 220, 220, 220, 220, 220, 220, 220,LBP, 220, 220, 220, 220, 220, 220, 220, 220, 220,OBP, 220, 220, 220, 220, 220, 220, 220, 220, 220,RBP, 220, 220, 220, 220, 220, 220, 220, 220, 220
340
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Jun 19, 2014 8:57 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

What "XOA" at the end of the message?

If you mean x'0A', i.e. a byte value indicating the end of a line on some platforms, DFDL handles that out of the box - why do you need to?

The fact that the message was parsed successfully (in your words) does imply that the DFDL parser has managed it, or you would have got an "unexpected character" message.

Define your problem more clearly. Like posting the error you did receive from DFDL.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
kimbert
PostPosted: Thu Jun 19, 2014 12:08 pm    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

As Vitor says, we need more information. Please quote the error message, or ( even better ) the relevant part of the DFDL trace.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.
Back to top
View user's profile Send private message
laddu858
PostPosted: Thu Jun 19, 2014 12:50 pm    Post subject: Reply with quote

Novice

Joined: 19 May 2008
Posts: 10

Thanks for the replay Vitor and Kim.

Sorry it was a whitespace(0x20) and my input has whitespace and value. I am not sure how to handle that.

I was able to parse the first two records from input msg, and 3rd record has whitespace and value, that will be the end of data.

In the delimiters field, i have put the termination as "%NL;", what should it be for whitespace("%WSP;" and number) is there way to handle it?



Jun 19, 2014 2:38:24 PM info: Offset: 607. Found delimited value: ' 220' for element 'RBP_Two_Seats'. The delimiter was ','.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::RBP_Two_Seats), 104]

Jun 19, 2014 2:38:24 PM info: Offset: 612. Finished processing element 'RBP_Two_Seats'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::RBP_Two_Seats), 65]

Jun 19, 2014 2:38:24 PM info: Offset: 612. Found separator ',' owned by the 'sequence' group contained within element 'body'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence), 103]

Jun 19, 2014 2:38:24 PM info: Offset: 613. Starting to process element 'RBP_One_Seat'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::RBP_One_Seat), 64]

Jun 19, 2014 2:38:24 PM info: Offset: 613. Found delimited value: ' 220' for element 'RBP_One_Seat'. The delimiter was '%NL;'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::RBP_One_Seat), 106]

Jun 19, 2014 2:38:24 PM info: Offset: 618. Finished processing element 'RBP_One_Seat'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::RBP_One_Seat), 64]

Jun 19, 2014 2:38:24 PM info: Offset: 618. Found terminator '%NL;' for 'body'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body), 56]

Jun 19, 2014 2:38:24 PM info: Offset: 620. Finished processing element 'body'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body), 56]

Jun 19, 2014 2:38:24 PM info: Offset: 620. Optional element 'body' encountered. The DFDL parser will return to this position if the element is not present in the data stream.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body), 152]

Jun 19, 2014 2:38:24 PM info: Offset: 620. Starting to process element 'body'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body), 56]

Jun 19, 2014 2:38:24 PM info: Offset: 620. Starting to process element 'System_Date'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::System_Date), 63]

Jun 19, 2014 2:38:24 PM info: Offset: 624. The simple content region of element 'System_Date' does not match the literal nil value.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::System_Date), 109]

Jun 19, 2014 2:38:24 PM info: Offset: 620. Found delimited value: ' 340' for element 'System_Date'. The delimiter was 'End of data stream'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::System_Date), 118]

Jun 19, 2014 2:38:24 PM info: Offset: 624. Finished processing element 'System_Date'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body/type::0/model::sequence/schemaElement::System_Date), 63]

Jun 19, 2014 2:38:24 PM error: CTDP3058E: Separator ',' not found at offset '624' for sequence or choice within element '/MSG_ESeamlessToLHOutbound_Output[1]/body[3]'.

Jun 19, 2014 2:38:24 PM info: Offset: 624. Parser was unable to resolve data on the current branch and will evaluate the next available branch beginning at offset '620' owned by the 'sequence' group contained within element 'MSG_ESeamlessToLHOutbound_Output'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::MSG_ESeamlessToLHOutbound_Output/type::0/model::sequence), 237]

Jun 19, 2014 2:38:24 PM info: Offset: 620. Occurrence '3' of element 'body' was not found in the data. occursCountKind is 'implicit' so no more occurrences of this element will be expected.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::body), 168]

Jun 19, 2014 2:38:24 PM info: Offset: 620. Finished processing element 'MSG_ESeamlessToLHOutbound_Output'.
[dfdl = /MMLIB_ESeamlessToLHOutbound/DFDLSchema_ESeamlessToLHOutbound.xsd, scd = #xscd(/schemaElement::MSG_ESeamlessToLHOutbound_Output), 84]

Jun 19, 2014 2:38:24 PM fatal: CTDP3002E: Unexpected data found at offset '620' after parsing completed. Data: '0x20...'.

----

Input Message:

20140618,211138.337,01,0741,20140627,XXX,XXX,P, 0, 20, 0, 0, 379,CBP, 140, 140, 140, 140, 140, 140, 140, 220, 300,LBP, 380, 380, 380, 380, 380, 380, 380, 380, 380,OBP, 380, 380, 380, 380, 380, 380, 380, 380, 380,RBP, 380, 380, 380, 380, 380, 380, 380, 380, 380
20140618,211140.125,01,1557,20140703,XXX,XXX,Y, 242, 33, 0, 0, 0,CBP, 220, 220, 220, 220, 220, 220, 220, 220, 220,LBP, 220, 220, 220, 220, 220, 220, 220, 220, 220,OBP, 220, 220, 220, 220, 220, 220, 220, 220, 220,RBP, 220, 220, 220, 220, 220, 220, 220, 220, 220
340
[/url][/code]
Back to top
View user's profile Send private message
kimbert
PostPosted: Thu Jun 19, 2014 1:07 pm    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Your data format seems to be a header/body/trailer format. That's a very common type of data format, and I answered a question about it last week:
http://www.mqseries.net/phpBB2/viewtopic.php?t=67624
You need to do the same thing : model the trailer record explicitly, and put a discriminator on the body record.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Jun 19, 2014 1:13 pm    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

laddu858 wrote:
Thanks for the replay Vitor and Kim.

To be entirely inaccurate, you should have said "ViCtor and Kim".

kimbert is not a Kim. Unless you've got a bad head-cold.
Back to top
View user's profile Send private message
laddu858
PostPosted: Thu Jun 19, 2014 2:38 pm    Post subject: Reply with quote

Novice

Joined: 19 May 2008
Posts: 10

Thanks Kimbert, I will create the dfdl and let you guys know if I find any issues.
Back to top
View user's profile Send private message
Vitor
PostPosted: Fri Jun 20, 2014 4:38 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

mqjeff wrote:
kimbert is not a Kim. Unless you've got a bad head-cold.


That's a really bad,bad cold (no offense intended sir)
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DFDL error
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.