topic Re: White space error - XML file format in QlikView

White space error - XML file format

richard_chilvers — Tue, 11 Aug 2015 08:29:23 GMT

I am LOADing data from a web file, in XML format.

The script runs perfectly when I run it locally on my PC.

When I save the model to server and run it, I get:

Error: Required white space was missing On line number: 1. On column number: 55.

I have no idea what this error is telling me, so any advice would be welcome.

Re: White space error - XML file format

marcus_sommer — Tue, 11 Aug 2015 09:41:29 GMT

Maybe this is helpful: https://www.google.de/?gws_rd=ssl#q=xml%2C+Required+white+space+was+missing.

- Marcus

Re: White space error - XML file format

richard_chilvers — Tue, 11 Aug 2015 11:15:03 GMT

Thanks Marcus

I will take a look in detail, but it seems strange the same model works on my local PC but not the server.

Re: White space error - XML file format

marcus_sommer — Tue, 11 Aug 2015 11:30:38 GMT

Have you the same qv version on server and on the local machine? Further for many things used qv no own functionalities else it used windows system libraries (*.dll) and they could differ to each other.

- Marcus

Re: White space error - XML file format

vupen — Tue, 15 Nov 2016 09:12:03 GMT

I know I am replying to a very old post, but I had the same problem.

This is seen when you extract pieces of a large LOB using DBMS_LOB.SUBSTR(DB_XML_FIELD, 4000, 8001) from the database, and joining them in QV to create one field that has the full XML content.

While returning data, Oracle is trimming the leading (and trailing?) white spaces.

To overcome this, I used

Replace(DBMS_LOB.SUBSTR(DB_XML_FIELD, 4000, 8001),' ','|') as XML_Chunk_2 from the database, and then replace '|' with ' ' on QV side.

Hope this helps.