topic Re: Reload from macro fails randomly in QlikView

Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 10:05:11 GMT

Hi, I have a problem which have bothered me for awhile.

I have a Dashboard which I save as a png file and save it to a path. This Works, but it fails randomly during the day. If I'm Lucky it could Works 24 hours, but sometimes it fails 2 times in 10 min.

The logfile says Execution finished, script runs to the end but then something happens. This Message shows up and the Application need to be restarted.

This is the code that I use in edit module:

Sub RefreshData
'Reload new data
ActiveDocument.ReloadEX 0,1

'Export sheet

ActiveDocument.GetSheetByID("SH02").Activate
ActiveDocument.GetApplication.WaitForIdle 1500
ActiveDocument.GetSheetByID("SH02").ExportBitmapToFile "\\10.1.1.1\xxx\xxx\xxx\pic.png"
ActiveDocument.GetApplication.WaitForIdle 3000
ActiveDocument.Save
End Sub

I have try to export to local path C:\temp but still same problem.

Re: Reload from macro fails randomly

avinashelite — Wed, 05 Apr 2017 10:08:07 GMT

If the script execution is complete then the problem is some time its not able to save the document this may happen because of the server not available , memory etc

share the complete log file

Re: Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 10:20:07 GMT

Hi Avinash,

this is not used in a server environment, its my local desktop‌. Its not a memory issue and there is no log file except the document logfile which not include any issues.

Re: Reload from macro fails randomly

avinashelite — Wed, 05 Apr 2017 10:25:24 GMT

could you share the document log file ? every day is it failing at the same time ?

Re: Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 10:34:06 GMT

It fails randomly, not the same time. I show you a screenshoot from my log files, they always look like this, no difference in it. The script is always succeeded

Re: Reload from macro fails randomly

avinashelite — Wed, 05 Apr 2017 12:55:41 GMT

Do you have any other process running because if your creating QVD 's and if its open by other qvw it won't allow you to save .

one more thing I suspect is , during the failure time check your Antivirus is running because few antivirus does allow QV to perform operations ..

Re: Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 13:06:44 GMT

No qvd's, it export a png file to a folder path.

Antivirus could be Worth a check.

Re: Reload from macro fails randomly

avinashelite — Wed, 05 Apr 2017 13:10:39 GMT

also check during that time whether the image is open by others or by any app

Hope this helps you

Re: Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 13:10:48 GMT

I have also notice that when I press "Yes" the macro will continue to export the Picture.

It feel like the macro end here:

Sub RefreshData
'Reload new data
ActiveDocument.ReloadEX 0,1

Then When I press Yes the rest of the macro run then Application die.

Re: Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 13:13:34 GMT

That was my first Guess, but when I change path to my local computer (C:\Temp\) it stills crash.

Re: Reload from macro fails randomly

cwolf — Wed, 05 Apr 2017 13:34:26 GMT

Use WaitForIdle without milliseconds!

Sub RefreshData

'Reload new data

ActiveDocument.DoReload 2,false,false

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.Save

ActiveDocument.GetApplication.WaitForIdle

'Export sheet

ActiveDocument.GetSheetByID("SH02").Activate

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.GetSheetByID("SH02").ExportBitmapToFile "c:\temp\pic.png"

End Sub

Re: Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 13:49:52 GMT

Thanks Christian,

I'll change and do a test.

What is the different between ActiveDocument.DoReload 2,false,false and ActiveDocument.ReloadEX 0,1?

Re: Reload from macro fails randomly

cwolf — Wed, 05 Apr 2017 13:59:29 GMT

Description in QlikView API Guid:

DoReload:

Executes the script. This is a more modern version of the old Reload member. The old Reload will continue to work for most applications.

Re: Reload from macro fails randomly

stabben23 — Wed, 05 Apr 2017 14:02:31 GMT

Seams like theese two are the same, no script window is shown during the reload.

Re: Reload from macro fails randomly

cwolf — Wed, 05 Apr 2017 14:52:04 GMT

The progress dialog during reload you can see only with ReloadEx:

ActiveDocument.ReloadEx 2,2

Re: Reload from macro fails randomly

stabben23 — Thu, 06 Apr 2017 05:49:53 GMT

Hi Christian,

The milliseconds seams to cause the problem that I have, I have now run the Application during the night and no issue at all. Do you know why these milliseconds are "bad"?

Re: Reload from macro fails randomly

cwolf — Thu, 06 Apr 2017 06:27:53 GMT

After the milliseconds, the macro is continued regardless of whether the idle state has already been reached or not. For example, you can not export the chart before it is finished. Before such actions you have to wait for the idle state how long it will take. It needs a WaitforIdle after Reload, Save, Activate, ...

Re: Reload from macro fails randomly

stabben23 — Thu, 06 Apr 2017 06:38:33 GMT

Many Thanks Christian,

I hve tested so many Things here but not "deleted" the milliseconds. I have rather increase the milliseconds to get rid of the problem.