Cannot Find Macro : when scheduling the workflow having a certain macro

[lalitsankhla]

Hi,

I have a workflow that where the data is coming through the google sheets input. When I run the workflow, it works fine but on the scheduler, it gives the following errors:

'Cannot find macro' for google sheets input tool.

Attaching the screenshot of the error:

Thanks in Advance.

[atcodedog05]

Hi @lalitsankhla 

Did you try running manually on the server too did it run ?

[lalitsankhla]

Hey @atcodedog05 , I am working on the Desktop Automation environment and the workflows are scheduled to run from the original location on disc.

[atcodedog05]

Hi @lalitsankhla 

You might want to check your path setting they might be relative and set them to absolute.

Go to below setting

It will pop a window like below.

You can set to all absolute or all UNC, click on ok. Save it now and check on scheduler.

Hope this helps 🙂

[danilang]

Hi @lalitsankhla 

Are you running the non-admin version of Designer.  If so, the supporting macros get installed in your personal AppData folders.  If the Automation engine doesn't run with your user account, i.e. it runs with Local System, it won't have access to your AppData. 

Dan  

[lalitsankhla]

Hi @danilang,

I am running the Admin-Version of Designer. still not able to figure out the issue.

Whereas I have crew macros and they are running absolutely fine with the scheduler.

[atcodedog05 · Accepted solution]

Hi @lalitsankhla 

If Crew macro is working and yours is not, reason could maybe path issue.

These could be possible fixes

1. Change path to absolute path in workflow dependency and check.

2. You can check the path of Crew macros in work dependency and add your macros to same folder, configure accordingly and check

Let me know if it works

[lalitsankhla]

Thanks, @atcodedog05, It worked. I moved the macro to the folder where other macros are stored.