QlikSense - Load Script - Adding Large XML files

We are experiencing serious issues with QlikSense when trying to add large XML files to its loader script; look at the picture below; with Qlik Sense the looping (busy) cursor (the circle in the middle) sits there, any attempt to do anything is ignored by Qlik Sense, the user frustration is high, and become higher when running the script (the application was originally written in QlikView) when the script freezes.

I just tried the same XML file with QlikView, and we were able to open, select/de-select tables and columns in less that 60 seconds !!! and we generate the QVDs yesterday using the original QlikView QVD Creator; it took less than 40 minutes.

Qlik Sense freezes!

The size of the XML file is 115,367 KB.

Michael, we need assistance with this issue, anything you can suggest will be appreciated; with QlikSense we already change the way the script loads data from these XML files.

Re: QlikSense - Load Script - Adding Large XML files

If the above is yes - please contact them directly to get support for this, but I will attempt to help you as well.

What version and edition of Qlik Sense? - Enterprise Server? September 2017? - Is it the latest version?

If you are using a previous version, can you please download the latest Qlik Sense Desktop and attempt to load the XML file locally on another machine? - Just to rule out any previous known issues that might have been fixed in the September 2017 release.

I will do some research here to see if I come up with anything.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: QlikSense - Load Script - Adding Large XML files

Hi Arnaldo - let me being in daz‌ in on this thread - perhaps he can help us troubleshoot. Also please updated us with what your supplier has found as well. If your supplier is working with someone at Qlik, please let us know so we do not duplicate efforts.

Re: QlikSense - Load Script - Adding Large XML files

You show a snippet here, but are you loading multiple xml tables in the script?

I notice the fields you are commenting out are the generated keys. Gererally when using generated keys from multiple xml files in a loop, you need to use unique Key field names for each file, like this:

FileBasename() & %Key_TransPort_operations... as %Key_Transport //etc

I don't know if this will help, but if it's taking 45 minutes for QV I suspect there is a lot of key craziness going on. Can you post the document log?

Re: QlikSense - Load Script - Adding Large XML files

Nothing is happening before the loop shown in the snippet, everything was commented out; the loop is expected to read 32 XML files, each one of them containing the table: RouteVariantPoint, the process freeze on the first XML file (before commenting the last 3 columns), and on the third XML file after we commented them. NOTE: The process never freeze on the same record.

Two log files attached, the first one before commenting %Key columns; second one after commenting them.

Sorry: I can't post the log files to this reply, I post w/o attachment, and I will try to attach to the original post.