Run MS Access Macro task failing inexplicably - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

jrtwynam
Free support Topic Starter

2019-06-13T15:54:25Z

Hi,

I have a job that runs an MS Access macro, which has been running nicely for several months now with no errors. This job has suddenly stopped working. This is what's captured in the output:

ExecuteProcess("C:\Program Files (x86)\VisualCron\\TaskOfficeMacro.exe" 46604923)->RunAccessMacro->COMException System.Runtime.InteropServices.COMException (0x80010105): The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
   at Microsoft.Office.Interop.Access.DoCmd.RunMacro(Object MacroName, Object RepeatCount, Object RepeatExpression)
   at TaskOfficeMacro.OfficeMacro.FI9TTWX4H() - maybe Microsoft Office is not installed? This Task requires Microsoft Office being installed.
ExecuteProcess("C:\Program Files (x86)\VisualCron\\TaskOfficeMacro.exe" 46604923)->Unhandled execution error: System.Runtime.InteropServices.COMException (0x80010105): The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
   at TaskOfficeMacro.OfficeMacro.FI9TTWX4H()
   at TaskOfficeMacro.OfficeMacro.hCmLhMCQZ()
   at ku8f4Ki7tn12qhZSXw.E0Asrfd6lbKLAQ8eLl.YEm1Dvumr(String[]  )

And this is what's in the extended debug logging:

6/13/2019 11:40:57 AM	Info	Job started: Transline CICO
6/13/2019 11:40:57 AM	Debug	SendJobStats->Ended (6/13/2019 11:40:57 AM)
6/13/2019 11:40:57 AM	Debug	Next action: ActionContinue
6/13/2019 11:40:57 AM	Debug	Calling GetNextTaskProcess()
6/13/2019 11:40:57 AM	Debug	Next Task is: Run Transline CICO MS Access Macro
6/13/2019 11:40:57 AM	Debug	Next action: ActionContinue
6/13/2019 11:40:57 AM	Debug	Calling StartTaskProcess() with Task: Run Transline CICO MS Access Macro (46604923)
6/13/2019 11:40:57 AM	Info	User 'VisualCron Default Admin' - Ran Job: Transline CICO
6/13/2019 11:40:57 AM	Info	Task started(Office macro): Run Transline CICO MS Access Macro (46604923)
6/13/2019 11:40:57 AM	Debug	RunAsType: API
6/13/2019 11:40:57 AM	Debug	Username: *****
6/13/2019 11:40:57 AM	Debug	ExecuteHelper started process: 13932
6/13/2019 11:40:57 AM	Debug	Process status - retrieving process id (46604923)
6/13/2019 11:41:09 AM	Debug	Process status - has left WaitForExit (46604923)
6/13/2019 11:41:09 AM	Debug	ExecuteHelper->CloseOutputHandle: C:\Windows\TEMP\VisualCron\StdOut_48fc4998-db0d-4ea7-a537-70e98b7e3337
6/13/2019 11:41:09 AM	Debug	ExecuteHelper->CloseOutputHandle: C:\Windows\TEMP\VisualCron\StdErr_6baa11e3-eeed-4a3d-aeaa-821aed27415d
6/13/2019 11:41:09 AM	Debug	Process status - OutPut captured (46604923)
6/13/2019 11:41:09 AM	Debug	Process status - trying to retrieve exit code
6/13/2019 11:41:09 AM	Debug	Process status - ExitCode fetched (46604923)
6/13/2019 11:41:09 AM	Debug	Process status - ProcessHandles closed (46604923)
6/13/2019 11:41:09 AM	Debug	ExecuteHelper->CloseOutputHandle: C:\Windows\TEMP\VisualCron\StdOut_48fc4998-db0d-4ea7-a537-70e98b7e3337
6/13/2019 11:41:09 AM	Debug	ExecuteHelper->CloseOutputHandle: C:\Windows\TEMP\VisualCron\StdErr_6baa11e3-eeed-4a3d-aeaa-821aed27415d
6/13/2019 11:41:09 AM	Info	Task completed (Success)->'Run Transline CICO MS Access Macro' (46604923)
6/13/2019 11:41:09 AM	Debug	PrevTaskProcess(Run Transline CICO MS Access Macro)->ExitCodeResult: Success (ECCId: 746c95ce-d394-491c-925c-8bd50e4daa8ePId: 46604923, Exit code: 0)
6/13/2019 11:41:09 AM	Debug	Found 1 matching flows. (46604923)
6/13/2019 11:41:09 AM	Debug	Calling GetNextTaskProcess()
6/13/2019 11:41:09 AM	Debug	Next execution (2) for Job 'Transline CICO' is: 5:00:00 AM
6/13/2019 11:41:09 AM	Debug	SendJobStats->Ended (6/13/2019 11:40:57 AM)
6/13/2019 11:41:09 AM	Info	Job completed (Success)->'Transline CICO'

The weird thing is that if I simply open the database file and double-click on the macro, it runs perfectly. This tells me that the problem isn't with the Access file, but I can't seem to figure out what the problem is.

Any ideas?

Thanks.

Edited by moderator 2019-06-19T16:53:13Z | Reason: Not specified

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

jrtwynam
Free support Topic Starter

2019-06-19T11:58:21Z

Just an FYI, I managed to solve this. It turned out not to be a problem with either the Access database file or with VisualCron - something had gone wonky in Windows. I have no idea what it was, but I rebooted the virtual machine that runs VC, and things were back to normal. I probably should have tried that first.

Support
Official support

2019-06-19T16:52:59Z

Originally Posted by: jrtwynam

Just an FYI, I managed to solve this. It turned out not to be a problem with either the Access database file or with VisualCron - something had gone wonky in Windows. I have no idea what it was, but I rebooted the virtual machine that runs VC, and things were back to normal. I probably should have tried that first.

Thanks for the feedback!

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!