Hi Guys,
I am trying to read XML file using the Sequential file stage. I am giving a Record delimiter as </Transaction> (closing Transaction Tag).
But for some reasons, after 10 records the job is throwing error that delimiter is not present. But i am able to see the delimiter. In fact, i did a grep on the Closing tag to check the number of records which was exact number of records which is needed.
I created a new XML from my source MQ queue. Even the new XML file, aborted after processing 10 records(using peek stage am able to say this). I even removed the 11th record and kept the remaining records. Still, i am having the same issue.
So, can somebody let me know what is going wrong.
Cheers!!
Issue in Reading a Sequential File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
Issue in Reading a Sequential File
Mac4rfree
Re: Issue in Reading a Sequential File
Why? An XML file is not a "sequential" file in the sense that the Sequential File stage understands reliably. Technically they are one long stream of characters with no individual records. Why not use the stage that was meant to read XML, the XML Input stage?mac4rfree85 wrote:I am trying to read XML file using the Sequential file stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
Re: Issue in Reading a Sequential File
I agree to it. But this how the client needs it. As there are already existing jobs which is designed in this manner. I added an environmental variable which helped me to resolve the issue. "$APT_DELIMITED_READ_SIZE = 990000000" This is what i added. Now i am able to read the file.chulett wrote:Why? An XML file is not a "sequential" file in the sense that the Sequential File stage understands reliably. Technically they are one long stream of characters with no individual records. Why not use the stage that was meant to read XML, the XML Input stage?mac4rfree85 wrote:I am trying to read XML file using the Sequential file stage.
![Smile :)](./images/smilies/icon_smile.gif)
Mac4rfree
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: