Error in Xml Input stage

kalpna · Post by **kalpna** » Mon Feb 06, 2006 9:00 am

Hi! Can any one identify the problem from the below error message.

"POLineXMLFF..XMLInput: Xalan warning (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:Warning: The primary document entity could not be opened. Id=WcsToHost.xsd"

My job goes like this

Folder----------XML Input---------------Sequential File

Thanx in advance
Kalpna

ray.wurlod · Post by **ray.wurlod** » Mon Feb 06, 2006 2:03 pm

Looks to me like The primary document entity could not be opened. Id=WcsToHost.xsd

Is this XSD file accessible? Did you specify its pathname correctly?

jzparad · Post by **jzparad** » Mon Feb 06, 2006 4:25 pm

If you don't want to validate the XML document, just remove the reference to the XSD document.

kalpna · Post by **kalpna** » Tue Feb 07, 2006 4:36 am

Hi! Roy
Yes i have checked the file in the specified location.
and i am able to open the file from unix.

Thanks
kalpna

kalpna · Post by **kalpna** » Tue Feb 07, 2006 5:58 am

Hi!
Iam able to open and also validate the schema file 'WcsToHost.xsd'.
and it is placed in the directory as the xml file.
but, its not recognising it..
i've tried this with XML Spy as well,
it warns the same

any clue???!!!

Thanks
kalpna

ArndW · Post by **ArndW** » Tue Feb 07, 2006 6:04 am

kalpna wrote:...i've tried this with XML Spy as well,
it warns the same...

So it is clear that it isn't a DataStage XML error, but a document form error. What does XML Spy report as the error message?

kalpna · Post by **kalpna** » Tue Feb 07, 2006 6:12 am

Hi! Arnd
It warns the same
'unable to load external DTD, schema 'WCSToHost.xsd'
but, iam able to open and validate the schema 'WCSToHost.xsd'

Thanks
kalpna

kalpna · Post by **kalpna** » Tue Feb 07, 2006 6:19 am

Now!...Iam able to validate the file from my colleague's machine..but, not on mine..

chulett · Post by **chulett** » Tue Feb 07, 2006 7:09 am

Try providing a full path to the xsd.

kalpna · Post by **kalpna** » Tue Feb 07, 2006 7:35 am

tried that!.
it wouldn't work...

Iam able to open the file from the same location...
But, when i go to the 'DTD/Schema -->Goto Schema ' Option in XML Spy..
it says it could not be opened.

kalpna · Post by **kalpna** » Tue Feb 07, 2006 8:15 am

i removed the validation part from xml file.
now the job runs fine with out complaining.but, it doesn't load the data to target.

any help would be appriciated!!!!!!!!

Thanks
kalpna

rajeevn80 · Post by **rajeevn80** » Wed Sep 26, 2007 5:40 am

Even I am facing the same problem. 'Cause of the error message no records are being output from the XML input stage. I have kept the necessary .xsd files in the same directory where the .ml exists.

Can any one let me know a solution for this please!!!

chulett · Post by **chulett** » Wed Sep 26, 2007 7:39 am

Don't jump on the end of an old thread, start a new one instead. We know nothing about your environment or job except you are facing the 'same problem' which isn't all that informative.

ps. No errrors and no output means your XPath Expressions are 'valid' but don't match the incoming XML.

pps. Start your own thread!!!

eostic · Post by **eostic** » Wed Sep 26, 2007 6:47 pm

First, separate the two problems.... Test your job with a version of the xml document that has NO indication of xml schema...remove the entry entirely using a text editor and run the job. There are 100 reasons why you'd get no rows from XMLInput, usually having to do with errors in your xpath (Description attribute of your columns in the output link).

Second, was the xml schema fully qualified inside your instance document? and are there any properties on the file that would prevent the DataStage userid "at runtime" from getting access to the directory, or to the file?

Ernie