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

[#1]

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!

J

[kenneth_syverts]

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

[#3]

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> .

[#4]

Solution!

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

[#5]

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

[#6]

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

Michael

[#7]

Hi Michael,

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

Thanks

Arunesh

[#8]

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

[rolandstadler]

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

[#10]

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.

[vincent_ardiet]

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-'".