| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DFDL Parsing |
« View previous topic :: View next topic » |
| Author |
Message
|
| 6FA |
 Posted: Fri Jan 15, 2016 5:21 am Post subject: DFDL Parsing |
 |
|
Novice
Joined: 08 Jan 2016
Posts: 21
|
Hi Folks,
I created message model of Record Oriented Text to convert DTS file to XML file using mapping node.
While testing the msg model I'm getting the below error.
CTDP3062E: An unexpected non-postfix separator ',' occurs in a postfix position at offset '91' in 'sequence' group contained within element 'Ident', xpath: '/PD_DFDL[1]/Ident[1]'.
ParsedDataRegion[SimpleContent, startOffset = 72, length = 19, scd = #xscd(/schemaElement::PD_DFDL/type::0/model::sequence/schemaElement::Ident/type::0/model::sequence/schemaElement::ImplementationVersionNumber)]
Sample message to test is below
AA.IDENT:BW,SRD,1.0.3,20150531,013848,29461,1,,BM,,R,US,20150531,,,,,?,,
AA.HEADER:20150531,D,2,STK,5151L01300
AA.LINEITEM:20150531013848,29461,61119326454,0,1,N,2, ,Sales in P,L,7,1,STK,5151L01300,L-S0301B ,1
AA.TRAILER:2
I have configured min occurances=0, Max occurances=1 for each element.
Getting error at last element of Ident line. How to terminate Ident line?
Thanks 
Last edited by 6FA on Fri Jan 15, 2016 5:39 am; edited 1 time in total |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Jan 15, 2016 5:34 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Do all of your records have the same amount of commas in them?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jan 15, 2016 5:52 am Post subject: Re: DFDL Parsing |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| 6FA wrote: |
| Sample message to test is below |
Test with what?
| 6FA wrote: |
| I have configured min occurances=0, Max occurances=1 for each element. |
Well congratulations. How about posting the entire DFDL schema so we can:
- see that and all the other things you've got configured
- actually test this data
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| timber |
| Posted: Fri Jan 15, 2016 6:24 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| Quote: |
| I created message model of Record Oriented Text |
The sample data looks exactly like CSV to me. Any reason why you did not use the CSV wizard? |
|
| Back to top |
|
|
| 6FA |
| Posted: Fri Jan 15, 2016 6:37 am Post subject: |
|
|
Novice
Joined: 08 Jan 2016
Posts: 21
|
Hi Timber:
At starting of each line there is keyword(AA.Header, AA.Ident, ...). Thats why I used Record Oriented if I'm not wrong. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jan 15, 2016 7:05 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Did you try running a user trace to see how the DFDL parser is handling your records?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| timber |
| Posted: Fri Jan 15, 2016 8:04 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| Quote: |
| At starting of each line there is keyword(AA.Header, AA.Ident, ...). Thats why I used Record Oriented if I'm not wrong. |
OK - that's a valid reason for not using the CSV wizard.
However...it looks as if you have *two* header lines, not one. The Record Oriented Text wizard expects a single record for the header line.
Your next step should be to take a DFDL Trace ( as mqjeff suggested ) and see exactly what the DFDL parser is doing with the model and the data. |
|
| Back to top |
|
|
| maurito |
| Posted: Mon Jan 18, 2016 12:59 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| 6FA wrote: |
Hi Timber:
At starting of each line there is keyword(AA.Header, AA.Ident, ...). Thats why I used Record Oriented if I'm not wrong. |
you can still define a CSV, with a choice and use the keywords as initiatiors for the different records |
|
| Back to top |
|
|
| timber |
| Posted: Mon Jan 18, 2016 3:56 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
@6FA: Looks as if the wizards will not give you a ready-made DFDL schema. I suggest that you start with CSV, and then add the initiators.
| Quote: |
| I have configured min occurances=0, Max occurances=1 for each element |
This is not the reason for your error, but...are you sure that LINEITEM can only occur once? Usually, lineItems are repeating elements. |
|
| 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
|
|
|
|
