Reload from macro fails randomly

[stabben23]

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.

[avinashelite]

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

[stabben23]

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.

[avinashelite]

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

[stabben23]

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

[avinashelite]

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 ..

[stabben23]

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

Antivirus could be Worth a check.

[avinashelite]

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

Hope this helps you

[stabben23]

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.

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

[stabben23]

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