XML Input Error --> Xalan fatal error: Expected equal sig

bandish · Post by **bandish** » Thu Aug 03, 2006 4:32 am

Hi,

I searched DsXchange and could not find any solution, So writing this query.

My Job structure is as below:

Sequential File --> XML Input --> Dataset

Job is able to read data from the sequential file but no records are getting loaded in to the target dataset.

XML File Size: 4753 KB
Able to view XML in Internet explorer.
Able to open the XML doc in Microsoft Excel.

I am getting the following types of errors in my job:

Code: Select all

1. XML_Input_10,0: Info: XMLTest_Customer.XML_Input_10: Xalan fatal error (publicId: , systemId: , line: 1, column: 513):Expected equal sign

2. Info: XMLTest_Customer.XML_Input_10: Xalan fatal error (publicId: , systemId: , line: 1, column: 220): Expected comment or processing instruction

3. Info: XMLTest_Customer.XML_Input_10: Xalan fatal error (publicId: , systemId: , line: 1, column: 3): There are more end tags than start tags

4. Info: XMLTest_Customer.XML_Input_10: Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure

One of the column values in XML file is :

Code: Select all

 "http://www.target.com/gp/search.html/ref=tgt_adv_XSGT0407?field-keywords=pink+kitty+cat&url=index%3Dtarget%26AFID%3DGoogle"

Can this column value be a problem in parsing the XML file?

Thanks
Bandish

chulett · Post by **chulett** » Thu Aug 03, 2006 6:36 am

Should be all about your XPath expressions. Did you import the metadata for this from the file or an xsd? Or did you 'roll your own'?

bandish · Post by **bandish** » Fri Aug 04, 2006 12:24 am

Hi,

I imported metadata from the xml file using XML Meta Data Importer.

The structure of my XML doc is:

Code: Select all

<?xml version="1.0" standalone="yes"?>
<report>
	<table>
		<columns>
			<column name="campaignid"/>
			<column name="adgroupid"/>
			<column name="keywordid"/>
			<column name="kwStatus"/>
			<column name="keywordMinCpc"/>
			<column name="creativeid"/>
			<column name="maxCpc"/>
			<column name="kwDestUrl"/>
			<column name="imps"/>
			<column name="clicks"/>
			<column name="cost"/>
			<column name="pos"/>
			<column name="conv"/>
		</columns>
		<rows>
			<row campaignid="11222678" adgroupid="382141298" keywordid="2177859818" kwStatus="Active" keywordMinCpc="30000" creativeid="500900138" maxCpc="150000" kwDestUrl="http://www.target.com/gp/search.html/ref=tgt_adv_XSGT0407?field-keywords=pet+food&url=index%3Dtarget%26AFID%3DGoogle" imps="17" clicks="0" cost="0" pos="9.176470588235293" conv="0"/>
			<row campaignid="11222678" adgroupid="382141298" keywordid="2591713118" kwStatus="Active" keywordMinCpc="30000" creativeid="500900138" maxCpc="150000" kwDestUrl="http://www.target.com/gp/search.html/ref=tgt_adv_XSGT0407?field-keywords=puppy+bowls&url=index%3Dtarget%26AFID%3DGoogle" imps="2" clicks="0" cost="0" pos="5.5" conv="0"/>
		</rows>
	</table>
	<totals>
		<grandtotal imps="1163893" clicks="18598" cost="2958460000" pos="5.6188438284275275" conv="0"/>
	</totals>
</report>

There are 13901 rows in this document, but I have only pasted 2 rows.

Thanks
Bandish

balajisr · Post by **balajisr** » Fri Aug 04, 2006 12:42 am

I do not think you can use sequential file as a input to xml input stage.

What is your xml source column in input tab of xml source stage?

bandish · Post by **bandish** » Fri Aug 04, 2006 2:31 am

Hi Bala,

I have already created few jobs with sequential file as source and they are working. But for this xml file I am not able to figure out the problem.

The source column name is DUMMY. Its datatype is Varchar and length 50000. I dont think so column name makes any difference in the job.

Thanks
Bandish

balajisr · Post by **balajisr** » Fri Aug 04, 2006 3:00 am

bandish wrote:Hi Bala,

I have already created few jobs with sequential file as source and they are working. But for this xml file I am not able to figure out the problem.

The source column name is DUMMY. Its datatype is Varchar and length 50000. I dont think so column name makes any difference in the job.

Thanks
Bandish

Interesting. I tried your approach but the same result. The data does not come out of xml input stage. There were no warnings or errors however.

You can try this design:

External Source ----> XML INPUT ----> DB

In external source stage specify unix "find" command to get xml file url.

In the input tab select column content as url.

This should work.

bandish · Post by **bandish** » Fri Aug 04, 2006 3:13 am

On the Stage --> General tab , have you checked the options to not reject fatal or error records. I think thats why you are not getting any warnings.

Will try the design suggested by you.

balajisr · Post by **balajisr** » Fri Aug 04, 2006 3:26 am

Oh yes i forgot to check it.

On running the job i get warnings similar to what you have got.

Below is the xml with which i ran the job. xml is very small.

<?xml version="1.0" encoding="ISO-8859-1"?>
<note>
<to>AAAAAAA</to>
<from>BBBBBBB</from>
<heading>CCCCC</heading>
<body>DDDDDD</body>
</note>

bandish · Post by **bandish** » Fri Aug 04, 2006 4:22 am

I am able to run the job and load into a dataset using xml doc provided by you !
I think you are missing something in the format tab of source Sequential file.

Thanks
Bandish

balajisr · Post by **balajisr** » Fri Aug 04, 2006 5:16 am

bandish wrote:I am able to run the job and load into a dataset using xml doc provided by you !
I think you are missing something in the format tab of source Sequential file.

Thanks
Bandish

Can you furnish your format details?

bandish · Post by **bandish** » Fri Aug 04, 2006 5:37 am

Format details are as below:

Code: Select all

Record Level
Final Delimiter = none
Record Delimiter = null

Field Defaults
Delimiter = none
Quote = none

Thanks
Bandish

balajisr · Post by **balajisr** » Sat Aug 05, 2006 1:07 am

Thanks it is loading now but for a few warnings which i need to fix.

In server jobs we usually have a folder stage instead of sequential file stage.

Is your problem solved?

bandish · Post by **bandish** » Mon Aug 07, 2006 4:28 am

No its still pending !
Just trying out by decreasing the size of my original xml file.