topic Re: Clikview Reloads Failing in QlikView

Clikview Reloads Failing

PeeJay2601 — Sat, 16 Nov 2024 03:48:59 GMT

Good Day Everyone

I am very new to Qlikview eben though our Company has been using it for quite some time.

There is a company here in South Africa that supports the product but they are pretty pathetic and have been unable to assist us as of late with some of our QlikView reloads that have been failing

I have attached the log of our failing Qlikview model and was hoping on of the Gurus on this site could assit me in figuring out what is causing the reload of our Finance Model to fail.

See log attached

Thanks guys.

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 12:41:45 GMT

Very sorry to hear that.

Have you tried reloading without the "QVDeploy/Finance/Finance.qvw" model. Seems to be failing here.

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 12:44:47 GMT

Is that App using Applymap anywhere?

Have you resently had a upgrade?

Re: Clikview Reloads Failing

Gysbert_Wassenaar — Thu, 18 Apr 2019 12:51:47 GMT

Check that you're server is not trying to execute too many tasks at the same time and running out of cpu and/or memory resources and into timeout limits.
And check the document log of the Finance Model document to see if there are specific errors related to the script logic of that document.

Re: Clikview Reloads Failing

PeeJay2601 — Thu, 18 Apr 2019 12:54:56 GMT

Hi John, thanks.

But the Finance Reload is the one that we need, so no point in running the reload without it.

I need to know why that specific model is failing.

Regards

Re: Clikview Reloads Failing

PeeJay2601 — Thu, 18 Apr 2019 13:00:07 GMT

Hi Gysbert

Where will I find the Finance Model specific log?

Thanks

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 13:00:47 GMT

Hi.

I had a similar issue with a Client in JHB a while ago.

It was around the Applymap.

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 13:01:22 GMT

Does the Finance Model use Applymap in the script?

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 13:02:08 GMT

It should be in the same folder as the model.

Re: Clikview Reloads Failing

Gysbert_Wassenaar — Thu, 18 Apr 2019 13:02:42 GMT

In the same directory as the .qvw document with the same name with .log appended. If it doesn't exist then you need to enable the Generate logfile option in the document properties.

Re: Clikview Reloads Failing

PeeJay2601 — Thu, 18 Apr 2019 13:03:48 GMT

Hi John

No upgrades as far as I am aware of.
The thing is that the Finance Model reloads Successfully most days and then just seems to fail randomly on certain days. The QlikView dedicated server also restarts every weekend on a Sunday but the failures are at random. The average running time of this model is 3 hours, so it runs up until 6 hours and then it ends due to reaching the 6 hour limit. The reload is triggered by other reloads that complete successfully. So all the rest reload but they are much smaller and reload much faster, our Finance is by far the biggest model. It will succeed for 10 days in a row and then fail for 2 days and then just run smoothly again.

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 13:04:29 GMT

In the Documents properties. Make sure the checkbox is ticked.

Re: Clikview Reloads Failing

PeeJay2601 — Thu, 18 Apr 2019 13:15:43 GMT

Hi Gysbert

I found the log but I don't know what I am looking for in that script in regards to errors as you mentioned?

Re: Clikview Reloads Failing

PeeJay2601 — Thu, 18 Apr 2019 13:16:03 GMT

Where can I check the script to see whether it is using Applymap?

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 13:16:54 GMT

When things happen randomly it is more difficult to pinpoint. It sounds like you server may be having resource issues under certain circumstances. You may want to look at changing / splitting your reload schedules and monitoring again.

3 Hours to load? Thats quite a monster!

Re: Clikview Reloads Failing

johngouws — Thu, 18 Apr 2019 13:18:33 GMT

When you are in the script editor, Go to the Main / First tab, press Ctrl+F the type in Applymap. Select the check box to search all tabs.

Re: Clikview Reloads Failing

Gysbert_Wassenaar — Thu, 18 Apr 2019 16:05:21 GMT

If there's any error it's almost always at the end of the log.

Re: Clikview Reloads Failing

Josh_Berg_Support — Mon, 29 Apr 2019 14:44:58 GMT

I agree with the suggestions made by other users, you/we will need to the document and task logs from a successful and a failure to load so we can compare the two. Remember that the document log will get overwritten with subsequent reloads so after the reload task fails, grab a copy of the document log, another one will get created on subsequent reloads. This will also tell us if the task is failing in the reload or distribution portion of the task.

Thanks,
Josh

Qlik Support