Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I run into an issue where the qvw is not reloading data.
The qvw has a trigger and it reloads every night. it shows successful load but it is not reloading new data.
Any ideas!
I also noticed the following:
In the architecture of the documents, I have source documents directory and documents directory.
I was asked when I do changes to the qvw to copy the file to both directories(If someone can tell me why, it will be great).
Now when the file get reloaded by the console the copy in the document directory looses the script!!
I appreciate any help.
Thxs,
Alec
Hi,
If You are able to reload the document manually, it looks like a security issue.
Make sure that the service user running the qlikview services has access to the sources. It could be access to databases, files og folders.
In a qvw-file you can also set a check in log-file, then you get more info saved as a txt-file on reloads. The txt file is stored in the same folder as the qvw-file. You find it in document properties.
I'm only listing plausible errors, there might be others, since you can do tons of funny stuff in a reload process.
/Henrik
Just a guess,
does you script in the document have an errormode syntax. Cause then errors might be ignored.
/Henrik
might be document not get copied properly .please check date and time for copy
hope this helps
Hi Henrik,
May you please give me an example of errormode. and how can I check that.
Thxs,
Alec
Hi SK,
The document is loaded succefully manually using QV on the Development server then saved, copied to the source document and to the document directories.
Is there anyway I should follow in coping the document?
Or is it possible to give me more details.
Thxs so much for your reply,
Alec
Hi,
If You are able to reload the document manually, it looks like a security issue.
Make sure that the service user running the qlikview services has access to the sources. It could be access to databases, files og folders.
In a qvw-file you can also set a check in log-file, then you get more info saved as a txt-file on reloads. The txt file is stored in the same folder as the qvw-file. You find it in document properties.
I'm only listing plausible errors, there might be others, since you can do tons of funny stuff in a reload process.
/Henrik
I have had the security issue before where the log file showed access denied. then I authorized the service user to access the data and everything worked normally.
The issues now on one of the qvw when The console reloads the qvw, it see the fields Names but it doesn't load any rows(0 rows fetched).
Another qvw loading from a simmilar source doesn't update the changes that i make on the source but it keeps the old fetched rows from previous reload.
On another QVW, I have a Google map and if I open the document using QV or on the access point, the map works fine but if i open it through a frame on a web page the map shows NO Data.
I appreciate any help if you guys know what should i do.
Thxs
Alec
Over all, it wasn't a big issue.
The Service account needed to have a full permission on SharePoint.
Thxs for your help.