topic Re: My qvw not reloading on server in QlikView

My qvw not reloading on server

Mon, 13 Jul 2015 10:24:30 GMT

I saw this after reload.

Re: My qvw not reloading on server

datanibbler — Mon, 13 Jul 2015 10:28:21 GMT

Hi Emac,

that is the log written by QMC. Unfortunately, that doesn't tell us too much about the error. Have you turned logging on in your app (on the "General" tab in the document_properties)?

If so, please post the log (in the same directory as the app, ending on .log, legible with Notepad or any other text program)

Best regards,

DataNibbler

Re: My qvw not reloading on server

vardhancse — Mon, 13 Jul 2015 10:33:30 GMT

Did you enabled Reload option in the reload tab of QMC task.?

Re: My qvw not reloading on server

Peter_Cammaert — Mon, 13 Jul 2015 10:38:51 GMT

The reload is taking too long to complete. There is a timeout value for reloads, after which they are killed. Your reload task is being killed by the Distribution Service.

Either check your reload script and the document log for anomalies (at the end, something is taking hours to complete), or in QMC change the reload timeout value on the reload tab (no Publisher) or at the bottom of the Task Triggers tab (with Publisher)

Best,

Peter

Re: My qvw not reloading on server

Mon, 13 Jul 2015 14:57:43 GMT

QMC Log is almost or 98% same as Log file.

Re: My qvw not reloading on server

Mon, 13 Jul 2015 14:58:18 GMT

Yes, reload is enabled

Re: My qvw not reloading on server

Mon, 13 Jul 2015 15:10:48 GMT

My script is running perfectly in QlikDesktop. Am using QlikServer no Qlik Publisher

Re: My qvw not reloading on server

jonathandienst — Mon, 13 Jul 2015 15:11:08 GMT

I don't think you've get the right file. It will have the same name as the qvw file, except with the .log extension and it will be in the same folder as the qvw file. That file will tell you where in the load script the reload failed. If the file does not get updated, that means the reload is not starting. If the log file shows the script running to completion, but it still fails, then it could be a complex synthetic key is causing problems. Or else check the QMC log to see if the problem is during distribution (although this would apply apply to a publisher installation).

PS - does the service account have write access to the document folder?

Re: My qvw not reloading on server

awhitfield — Mon, 13 Jul 2015 15:13:36 GMT

Hi ,

have you been able to run the reload in in QV Desktop ON the server?

If so, then the most likely cause is a permission issue for the QV Service user on one of the source / db files

HTH - Andy

Re: My qvw not reloading on server

Peter_Cammaert — Mon, 13 Jul 2015 15:17:47 GMT

Just telling you what is going wrong in your server environment. The server kills your reload after 6 hours. I provided a solution in case you don't have a publisher as well ("...change the reload timeout on the reload tab (no Publisher)...")

Peter

Re: My qvw not reloading on server

Peter_Cammaert — Mon, 13 Jul 2015 15:20:44 GMT

Your script is NOT failing or producing any errors, it is just taking too long to complete. The QDS (which is also in command when you don't have a Publisher) is killing your reload for that reason.

Peter

Re: My qvw not reloading on server

maxgro — Mon, 13 Jul 2015 15:21:27 GMT

On server the reloasd was abortetd after 6 hours.

How long does it takes the reload in Qlikview desktop?

Post the Financial Statement.qvw.log as already suggested.

Re: My qvw not reloading on server

Tue, 14 Jul 2015 08:55:04 GMT

It last for about 2hrs in QV desktop