topic Re: Reload of Doc is not happening in QlikView

Reload of Doc is not happening

Wed, 01 Apr 2015 08:59:14 GMT

Hi,

I am new to QMC and trying to reload one document, but it's not getting reloaded, I have tried scheduling the task and manually reloading as well, please help to reload it.

Screen shot is attached.

Regards,

Navdeep

Re: Reload of Doc is not happening

datanibbler — Wed, 01 Apr 2015 09:15:01 GMT

Hi Navdeep,

are you getting any error_message in QMC? If it goes back to "failed" after running for a short time, have a look in the log. Can you post the last few lines here?

Re: Reload of Doc is not happening

Wed, 01 Apr 2015 09:17:59 GMT

Hey m not getting the log file, its not starting at all. Nothing is showing up in doc details also.

Re: Reload of Doc is not happening

datanibbler — Wed, 01 Apr 2015 09:20:38 GMT

Can you open the doc (right-click -> "Open without data") and in the doc_properties, tick the checkbox to create a log file?

If I understand you correctly, though, the task never even goes to "running" in the QMC, but after a few seconds it switches right back to "failed". Is that it?

Re: Reload of Doc is not happening

datanibbler — Wed, 01 Apr 2015 09:36:48 GMT

And that task is scheduled? (if it wasn't, it wouldn't show up on this page of QMC)

=> Can you look in QMC on the tab "documents" and make sure it is physically saved in the directory where QMC "knows" it? Otherwise, it might be a "ghost task" - we had those regularly.

Re: Reload of Doc is not happening

simsondevadoss — Wed, 01 Apr 2015 09:37:45 GMT

Restart all the services

Re: Reload of Doc is not happening

datanibbler — Wed, 01 Apr 2015 09:47:06 GMT

Hi simson,

if he can do that himself, that might be a possibility - though I think that restarting the QDS should be enough ("QlikView Distribution Service", that is).

Me for my part, i cannot do that myself, I don't have the privileges, which is why I would first test out all other possibilities and leave that for last.

Re: Reload of Doc is not happening

simsondevadoss — Wed, 01 Apr 2015 09:52:00 GMT

Yeah. Since he has administrator rights to the QMC i thought he also has access to server as well.

Re: Reload of Doc is not happening

datanibbler — Wed, 01 Apr 2015 09:54:17 GMT

Hi simsin,

not necessarily. I have access to QMC as I am in that security_group, but I cannot access the services running on the server.

Let's see what it is in Navdeep's case ...

Re: Reload of Doc is not happening

Wed, 01 Apr 2015 12:42:24 GMT

Hey Guys,

Seems there was some issue with RAM and I restarted my server, now everything is working fine :-). Thanks for support.

Re: Reload of Doc is not happening

simsondevadoss — Wed, 01 Apr 2015 12:45:25 GMT

Please mark the answer is Correct/ Helpful. So that it will be easy for others

Re: Reload of Doc is not happening

datanibbler — Wed, 01 Apr 2015 12:48:18 GMT

Hi Navdeep,

have a look at the logs created by the DistributionService maybe. It is possible to build a QlikView_app to load those logs and read some data, among others the RAM_consumption, from them.

QlikView has the tendency to grab RAM, but not free it up again, so the consumption continues to grow and it's possible that at some point you'll run into problems because your server doesn't have enough RAM left for other things.

That is why, acc. to my latest knowledge, Qlik advises to restart the services in regular intervals. I suggested it here, but our IT wouldn't do it. They'd rather have me ask them to restart every time and continue grumbling about QlikView because it's not integrated into their world ...

I guess that restarting the QDS would be enough and restarting once a month would seem reasonable - once a week if you're a bit short on RAM generally.

HTH

Re: Reload of Doc is not happening

Wed, 01 Apr 2015 12:54:34 GMT

Yes Buddy, I am facing same issue, RAM is too less as we are testing Qlikview in our organisation. And to my bad gradually RAM consumption will increase thus once in 2 weeks I have to restart my server.

Re: Reload of Doc is not happening

datanibbler — Wed, 01 Apr 2015 12:58:36 GMT

Well, then you can schedule to restart QDS every night. That way RAM will be freed up daily and your troubles will be minimizes - at least rgd. QlikView.

Since QlikView is an IN-MEMORY tool, of course it will still need a lot of RAM depending on the amount of data to be processed, but freeing it up again daily should minimize the impact.