topic document session lost on server. Reconnect? in QlikView

document session lost on server. Reconnect?

Tue, 30 Jun 2009 21:34:14 GMT

Hi,

I'm a newbie here and to qlikview. What I am trying to do is the following:

1. Load a qvd from an oracle database table.

2. Run a batch job every 10 mintues to update the qvd file with the latest incremental data from the database.

essentially, this what I am doing:

SELECT * FROM myschema.my_table where <condition to get incremental data>

concatenate
LOAD *
FROM my_data.qvd (qvd);

STORE Qlkdata INTO my_data.qvd;

The problem is..everytime I run the script, everyone using the report gets the following error message: "Document connection lost on server. Reconnect?" I'm using Qlikview 8.5

Any thoughts would be greatly appreciated. I just got into this about 3 days ago..already loving it.

Thank you

--S

document session lost on server. Reconnect?

Tue, 30 Jun 2009 23:16:56 GMT

The action can be set at the individual document level. See Document Properties>Server>Refresh Mode

Glad you are enjoying Qlikview!

Regards,

Gordon

document session lost on server. Reconnect?

Wed, 01 Jul 2009 00:11:27 GMT

Brilliant!! Thanks a lot Gordon..it works! However, everytime, the data is refreshed in the server, all the selections on the screen are lost. The document defaults to no-selections. I selected the following option "Server performs refresh automatically without client action".

document session lost on server. Reconnect?

Tue, 07 Jul 2009 00:42:39 GMT

you might be able to solve that using bookmarks (set a bookmark before reloading and open it after)

document session lost on server. Reconnect?

Mon, 05 Apr 2010 22:54:25 GMT

More on this in post: http://community.qlik.com/forums/p/25346/96752.aspx#96752