document session lost on server. Reconnect?

[#1]

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

[#2 · Accepted solution]

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

Glad you are enjoying Qlikview!

Regards,

Gordon

[#3]

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

[#4]

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

[#5]

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