topic Re: Server Reload Intermittently Fails and Completes in QlikView

Server Reload Intermittently Fails and Completes

rustyfishbones — Thu, 02 Jul 2015 13:59:30 GMT

Hi All,

I have a Qlikview Extraction file on a Scheduled reload, however sometime this completes and other times it does not

Has anyone seen this before, and if so, what could be the issue

See below screenshot of the reload Task History

Re: Server Reload Intermittently Fails and Completes

rustyfishbones — Thu, 02 Jul 2015 14:58:47 GMT

I have changed a a couple of settings but I still have the same issue.

The document reloads without any problems when I manually reload the document.

All my other files are reloading successfully from the server, I have a problem with just this one file

Any suggestions

Regards

Alan

Re: Server Reload Intermittently Fails and Completes

Gysbert_Wassenaar — Thu, 02 Jul 2015 16:02:18 GMT

I assume you've already checked the log files?

Re: Server Reload Intermittently Fails and Completes

rustyfishbones — Thu, 02 Jul 2015 16:20:05 GMT

Yes, I just keep getting General Script Error.

It's driving me demented now, Now I cannot even load it manually, which was working

Re: Server Reload Intermittently Fails and Completes

Anonymous — Thu, 02 Jul 2015 16:27:18 GMT

Could you share the reload log file ?

Is the command before it fails a Store() ?

If so then try putting a sleep(9000) immediately after the Store().

Re: Server Reload Intermittently Fails and Completes

rustyfishbones — Thu, 02 Jul 2015 16:38:13 GMT

Hi Bill,

Yes it fails at the same place each time and it appears to happen just before a STORE command.

the log file just says General Script Error

Re: Server Reload Intermittently Fails and Completes

Anonymous — Thu, 02 Jul 2015 17:24:44 GMT

I have seen this happen when the qvd file is in use and cannot be overwritten.

You could use Execute before the Store() to try and delete the file with dos DEL before it does the actual Store(). If it fails on the delete then that will certainly point to the file being in use.

Re: Server Reload Intermittently Fails and Completes

rustyfishbones — Fri, 03 Jul 2015 07:40:24 GMT

Hi Bill,

It does not fail on the delete, I added the EXECUTE statement and it deletes the file without any issues as I surrounded

the before and after with TRACE to capture what is happening, it still fails on the STORE.

I have a TRANSFORM file that loads the extracted QVD, is it this file that is possibly causing the issue?

I will stop the reload of the Transform file and see if the Extract file completes without any errors.

Regards

Alan

Re: Server Reload Intermittently Fails and Completes

jonathandienst — Fri, 03 Jul 2015 08:00:12 GMT

It could be something to do with the closing of the qvb.exe processes - if the next reload starts while the previous qvb.exe is still open, it will fail because of file locks not yet released by the previous qvb.exe. You could monitor this in the task manager.

Re: Server Reload Intermittently Fails and Completes

rustyfishbones — Fri, 03 Jul 2015 08:03:02 GMT

Thanks Bill, I stopped the TRANSFORM and the EXTRACT runs fine.

I need to change the Reload for the TRANSFORM file to run when the EXTRACT file finishes

Re: Server Reload Intermittently Fails and Completes

rustyfishbones — Fri, 03 Jul 2015 08:20:19 GMT

I would have thought that if there was a conflicting issue with a QVD file that this should appear in the log file.

General Script Error does not really help.

Something like this would be better

Conflicting Use of QVD ..\qvd.qvd

Thanks again Bill and all for your help

Regards

Alan

Re: Server Reload Intermittently Fails and Completes

Anonymous — Fri, 03 Jul 2015 08:40:50 GMT

Alan

Absolutely agree that that General Script Error does not really help