topic Re: <result><message text="Empty response" /></result> when exporting to Excel in QV Access Point in QlikView

when exporting to Excel in QV Access Point

Mon, 26 Jan 2026 18:19:17 GMT

This issue started when we upgraded from QV9 to QV10. At first the issue was intermittent, but over a month or so, during which usage increased somewhat, the problem started to happen more often than not. Still, a second attempt would often be successful. Now, however, we get the excel file saying <result><message text="Empty response" /></result> every time we attempt an export using IE7, 8 or 9; Firefox 3.5, 3.6 and 4; and Chrome 12.x. However, if a user logs into one of our QV servers and opens a report with the desktop client, even if it is stored remotely, they will succeed every time...in fact, the export to excel is about the only thing that happens quickly in QV, even for our largest reports. We've had issues with support, and our most experienced QV admin is abroad for a few weeks. Any suggestions? Please feel free to request more info about our environment if needed.

Thanks!

when exporting to Excel in QV Access Point

stevedark — Thu, 24 Mar 2011 22:29:41 GMT

Hi there,

This is not an issue I have come across with QV10. Are you running SR1 of QV10 on your server? This is probably the first thing to ensure.

It may be a time-out issue, you can up various time-out settings in the management console. Is the server stretched at all or is it running with plenty of free CPU and Memory?

Regards,
Steve

when exporting to Excel in QV Access Point

Fri, 25 Mar 2011 13:46:42 GMT

Hey Steve. Thanks for the reply. We are running SR1 - QVS version is 10.00.8811.0409.10. The server is definitely stretched at times. It's an 8-core xeon running at 2.5GHz with 64GB RAM, and it isn't uncommon to see both memory and cpu usage top 90%. We have 12 qvw's over 1GB, one of those is a 3GB file. When a user opens that one, it eats up 9-12 GB memory by itself. My gut feeling is that this problem is load-related, but we want to be sure that's it before we invest in another monster server.

I will definitely look at upping timeout values in the management console and let you know if we see any improvement.

Thanks again.

Jason

when exporting to Excel in QV Access Point

Fri, 25 Mar 2011 18:33:43 GMT

I was able to test with the server under no load, and get the same results. When I try the export from AccessPoint, it goes very quickly, within a second or so I am prompted to save or open the excel file. I combed through the Management Console looking for timeout values that might apply, and searched the Reference Manual to be sure i wasn't missing one somewhere. All timeout values are set high enough that they can't account for the quick export of the empty excel sheet. Is there a particular timeout setting you had in mind when making the suggestion? If not, it looks like both of my theories about what's going wrong are disproven.

when exporting to Excel in QV Access Point

stevedark — Sat, 26 Mar 2011 00:22:48 GMT

Hi there,

It may be one to escalate to support@qlik.com . They will want full details of both server and client side sent along with the description of the issue. You could also send a link to this thread in QlikCommunity.

Regards,
Steve

when exporting to Excel in QV Access Point

Mon, 28 Mar 2011 17:51:38 GMT

We do have a ticket open, but things are moving very slowly. Thought I'd give the community a shot. Thanks for your help.

when exporting to Excel in QV Access Point

Tue, 29 Mar 2011 19:39:21 GMT

This issue was resolved by running a repair install of QV10 on both servers in our cluster. Thanks!

Re: when exporting to Excel in QV Access Point

Fri, 09 Dec 2011 16:42:38 GMT

I know this is an answered question, but I wanted to add that I had the same symptom as a result my server's C: drive being out of disk space. The problem stopped occurring as soon as I freed some disk space.

Re: when exporting to Excel in QV Access Point

kenneth_syverts — Tue, 20 Dec 2011 13:34:56 GMT

Just to let you know, we have the same issue after upgrading from 9 sr6 to 10 sr4.

- and it didn't help to "repair" - or restart

when exporting to Excel in QV Access Point

Thu, 22 Mar 2012 18:43:23 GMT

Hi, I have de same issue with QV10 sr4, after upgrading from QV9 sr6.

You know how resolve?

Thks

Re: when exporting to Excel in QV Access Point

kenneth_syverts — Fri, 23 Mar 2012 06:14:59 GMT

I think in the end there where some traces of an earlier installation that the upgrade procedure did not catch.

The support people seemed to suspect this, though, whereafter a new installation made things ok.

Den 22. mars 2012 kl. 19:40 skrev "diego.berriel" <qliktech@sgaur.hosted.jivesoftware.com>:

QlikCommunity
Re: when exporting to Excel in QV Access Point
created by diego.berriel in Deployment and Management (Server/Publisher/AJAX/IE/Web Parts) - View the full discussion
Hi, I have de same issue with QV10 sr4, after upgrading from QV9 sr6.
You know how resolve?

Thks
Reply to this message by replying to this email -or- go to the message on QlikCommunity
Start a new discussion in Deployment and Management (Server/Publisher/AJAX/IE/Web Parts) by email or at QlikCommunity
Join us for our next "Ask the Experts" event! The Ask the Experts- Cool Visualizations will be held on April 10th and 11th in QlikCommunity. More info »
© 1993-2011 QlikTech International AB Copyright & Trademarks | Privacy | Terms of Use | Software EULA

when exporting to Excel in QV Access Point

Fri, 23 Mar 2012 18:25:41 GMT

Look, for more details. I Implement a cluster with QV10. When accespoint route to one node the functionality "send to excel" worki fine, but if route to another node, get the error message, and in the excel document appear <result><message text="Empty response" /></result> .

when exporting to Excel in QV Access Point

Thu, 29 Mar 2012 13:15:13 GMT

Solution!

Specify in QVS Folders, an common folder to both servers in cluster on: Alternate Temporary Files Folder Path

Re: when exporting to Excel in QV Access Point

Wed, 18 Apr 2012 15:42:42 GMT

Hi All,

We have upgraded q11 and faced similer issue that export excel via ajax client is giving below

<result><message text="Empty response" /></result> when exporting to Excel in QV Access Point

Please let me know how you have fixed in your enviornment. I have repaired software but no luck.

Thanks in Advance.!!

Arunesh

when exporting to Excel in QV Access Point

Thu, 26 Apr 2012 15:43:48 GMT

This solution worked for us on QV11 also. Thanks for posting it!

Michael

when exporting to Excel in QV Access Point

Thu, 03 May 2012 11:59:49 GMT

Hi Michael,

Could you please let me know which folder need to share or create common folder?

Thanks

Arunesh

when exporting to Excel in QV Access Point

Fri, 04 May 2012 09:05:14 GMT

Arunesh,

I simply created a new folder in a network share that both servers had access to, then set the "Alternate Temporary Files Folder Path" to this folder. It looks like this folder is where the exported xls is temporarily saved while the user downloads it.

Kind regards,

Michael

Re: when exporting to Excel in QV Access Point

rolandstadler — Tue, 05 Feb 2013 08:40:35 GMT

Thanks for the hint. A shared Temp Folder is essential on a cluster environment.

Re: when exporting to Excel in QV Access Point

Tue, 09 Apr 2013 19:14:47 GMT

That definitely was the fix for us as well. Creating a shared TempFolder in our access point area and pointing "Alternate Temporary Files Folder Path" to that location.

in QEMC go to System->Setup->Qlikview Servers->Folders. You will find it at the bottom of the page.

Thank you Diego.

Re: when exporting to Excel in QV Access Point

vincent_ardiet — Thu, 24 Oct 2013 12:47:11 GMT

Thanks guys for the solution with the Alternate Temporary Files Folder Path.

We were facing the same problem when trying to view PDF reports. But before being able to catch the "Empty Result" message, it was appearing like a corrupted PDF file with the message "File does not begin with '%PDF-'".