XMLQuery in 12.2

[Former Member]

I have an XMLQuery (not an XMLQuery Action Block) attempting to get a local file. 

Source URL is:  I:\User Data\Folder\fileName.xml

Getting the message:

Fatal Error

Error has occurred while processing data stream I:\usr\sap\XMD\J00\j2ee\cluster\server0\User%20Data\Folder\fileName.xml (The system cannot find the path specified

Why is the XMLQuery adding the extra usr\sap.... server0 to my path instead of returning my data???

This used to work in 11.5.

Thank You,

Dennis

[Former Member · Accepted solution]

We've raised this as a ticket item, and The support team will be putting this in the next patch...

[HariCS23]

Hi Dennis,

you can to refer that file by network path.

First you need to share that file.

Then access by some thing like this path:  \\hostsystem\Folder\fileName.xml 

Hope this helps.

Thanks

Hari

[Former Member]

Hi Hari,

I have tried this and still get the Fatal Error message above.

If I sit at the Server and put this URL in Notepad or other applications, it opens the xml fine.

When I create an xml query in workbench.  The error above shows up.

This xmlquery (not BLS Action Block) takes http:// addresses and returns correctly, just not file paths.

[Former Member]

OK, I've changed the back slashes(\) to forward slashes(/) and it works. Not what I was expecting but it's one of those things that make you say HHHMMMM.

Thanks

[HariCS23]

hhmmm... 

I am glad that it worked out for you...

Thanks

Hari

[Former Member]

Actually, it is still unresolved...

as this workaround requires additional changes in more places...

[HariCS23]

Hi Dennis, use forward slash /  instead of back slash.

I:/User Data/Folder/fileName.xml

When you use back slash,it is trying to find the path from server root which Drive:\usr\sap\<sapid>\j<id>\j2ee\cluster\server0.

Thanks

Hari