Job cannot open XML location

johm73 · Post by **johm73** » Thu Dec 08, 2011 1:39 pm

I'm trying to use the XML Input stage to grab an XML data from a http location and process it into an Oracle table.

folder stage--->XML Input--->transformer--->OCI

The file I read in the folder stage contains the URL to the XML file. That seems to be working fine.

I can access the XML data from my local browser.
I can access the XML data from the browser on the DS server (windows 2003) even when I log into that server as the local admin account.
I can access the XML file via the DS XML meta-data importer.

All of that works great, but as soon as actually run the job. It fails because it cannot access the XML location. I'm obviously missing something here, because that makes no sense to me.

Here is the error and thanks for any help you can provide.

XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:NetAccessorException, Message:Could not open file: http://cpwva3020.wellsfargo.com:7778/do ... assest.xml

eostic · Post by **eostic** » Thu Dec 08, 2011 6:01 pm

I haven't tried URL access in awhile --- exactly what release?

Also, make certain that it is getting the correct string via the folder stage....

I would test initially instead with a Transformer going into xmlInput, and just hard code the URL into a Derivation as a simple string (in a single big column called something like "myURL" with varchar and length of 100...... and be sure that the input link for xmlInput, with that one derived column, has its "XML Content" radio button checked....

Ernie

johm73 · Post by **johm73** » Thu Dec 08, 2011 6:20 pm

version is 8.1 FP2

I'll give that a try, but I'm pretty sure it's picking up the URL fine because the error message DS gives has the full URL in it and it's correct.

Thanks.

johm73 · Post by **johm73** » Fri Dec 09, 2011 3:53 pm

no luck and DS is seeing everything correctly. Does anyone know what DS uses under the covers for http gets?

[quote="johm73"]version is 8.1 FP2

I'll give that a try, but I'm pretty sure it's picking up the URL fine because the error message DS gives has the full URL in it and it's correct.

Thanks.[/quote]

eostic · Post by **eostic** » Fri Dec 09, 2011 4:26 pm

Unfortunately I don't have access to an 8.1 right now, but it works in 8.7...I just did one where the xml document is on a web server and accessed via HTTP...... is your web server accessible directly from the DS engine machine?

johm73 · Post by **johm73** » Fri Dec 09, 2011 4:31 pm

I assume that it is when I can put the http address in the browser on the engine and it can access it fine. but, maybe that isn't the best test. do you know what is?

eostic · Post by **eostic** » Fri Dec 09, 2011 7:49 pm

I would concur, or at least I can't think of anything else.... might be worth a support call. I don't know the history of this one back to 8.1....