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
Job cannot open XML location
Moderators: chulett, rschirm, roy
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
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
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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]
[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]
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?
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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....
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>