Running Access Macro from 'Office Macro' task. - VisualCron - Forum

Community forum

EdNice
2016-11-30T17:01:30Z
Hi,

I'm evaluating VisualCron for a client. I've found it pretty easy to set up, but it errors on running a task which calls an access macro via 'office Macro'.

I've added credentials. The macro runs fine manually.

It's on a Windows 2012 r2 box. It generates the following errors (In event viewer).

Faulting application name: conhost.exe, version: 6.3.9600.17415, time stamp: 0x5450410b
Faulting module name: USER32.dll, version: 6.3.9600.18438, time stamp: 0x57ae642e
Exception code: 0xc0000142
Fault offset: 0x00000000000ecdd0
Faulting process id: 0x9a4
Faulting application start time: 0x01d24b29bd0933b0
Faulting application path: C:\Windows\system32\conhost.exe
Faulting module path: USER32.dll
Report Id: fab5bfd8-b71c-11e6-8148-12cfe79d097b
Faulting package full name:
Faulting package-relative application ID:

Faulting application name: TaskOfficeMacro.exe, version: 1.0.0.0, time stamp: 0x58185332
Faulting module name: KERNELBASE.dll, version: 6.3.9600.18438, time stamp: 0x57ae642e
Exception code: 0xc0000142
Fault offset: 0x00000000000ecdd0
Faulting process id: 0xdb0
Faulting application start time: 0x01d24b29bd0933b0
Faulting application path: D:\VisualCron\TaskOfficeMacro.exe
Faulting module path: KERNELBASE.dll
Report Id: fabf4902-b71c-11e6-8148-12cfe79d097b
Faulting package full name:
Faulting package-relative application ID:

Any information or ideas would be great. Thank you.

Regards, Ed.
Support
2016-12-01T07:42:55Z
Please add screenshot of Task settings.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
EdNice
2016-12-01T09:41:54Z
Hi Henrik,

Thanks for your reply. Here are the screens.

VC2.jpg

VC3.jpg

VC1.jpg

Ed.
Support
2016-12-01T10:06:14Z
1. have you install Access locally on the same machine?
2. have you installed 32 or 64 bit version of access?
3. I noticed there is a blank space in the macro name. Please open the macro from the document. Normally it is written like document/class.macroname.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
EdNice
2016-12-01T13:48:17Z
Hi Henrik,

Thanks for your reply

1. Yes, access is installed on the same machine.
2. It is 64bit. I have tried both 64 & 32 bit settings (I know the 32 bit was checked).
3. the macro is named with a space. I've added it [to VisualCron] as I think VBA wants it. I'll read up about macro naming, but if you have a link available to any resource for VisualCron and macr names, that would be very helpful.

Thanks.

Ed.
Support
2016-12-01T14:32:41Z
Please try the following:

1. enable Extended debugging in server settings
2. Edit the Credential that you use and change to "CreateProcessAsUserW"
3. try again
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
EdNice
2016-12-01T14:55:41Z
Thanks Henrik. I'll give it a try and let you know what happens.

Regards, Ed.
EdNice
2016-12-01T15:32:15Z
Hi Henrik,
Setting credentials to "CreateProcessAsUserW" has resolved the errors reported earlier.
The job runs, I get positive impersonation stuff in the event security audit logs, but the process in the macro isn't carried out. If I run the macro from the Access UI, it all works ok.
I'll continue to try things but if you have any further ideas of suggestions or need me to try anything, please let me know.
Regards, Ed.
Support
2016-12-07T15:09:56Z
Originally Posted by: EdNice 

Hi Henrik,
Setting credentials to "CreateProcessAsUserW" has resolved the errors reported earlier.
The job runs, I get positive impersonation stuff in the event security audit logs, but the process in the macro isn't carried out. If I run the macro from the Access UI, it all works ok.
I'll continue to try things but if you have any further ideas of suggestions or need me to try anything, please let me know.
Regards, Ed.



Yes, I think you need to add line by line debugging in the access macro to see which line is causing the problem.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top