Error message A custom macro in this report has failed to run (1 Viewer)

[bharlow]

I have a number of macros that send reports via the SendObject action. They all run perfectly except for one that gives the error message...

A custom macro in this report has failed to run, and is preventing the report from rendering.

The report opens perfectly and I can run the SendObject from within the DB perfectly. I just get this error when I try to use a Task Scheduler to run the macro.

Has anyone ever seen this before???

Any help or advice is greatly appreciated

 

[pbaldy]

I haven't necessarily seen that, but when something works fine when you run it manually but not from Scheduled Tasks, I would suspect a permissions problem. Does the scheduled task have the appropriate login/password?

 

[bharlow]

That was it.

Thank you very much PBaldy

 

[pbaldy]

Ah, it feels good when a shot-in-the-dark hits the target!

Glad it helped.