DSXchange

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

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?

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

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

Thanks
kalpna

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

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?

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

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

Try providing a full path to the xsd.

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.

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

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!!!

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!!!

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