How do I Stop a macro that have been running for 6 days? - Solved

[MellBI]

Hi,

When I look in the list of Macros I find a macro that reached 16% in 6 days.
I would like it to be stopped but when I click Stop it says "The Macro will stop before the next macro step"

Since it looks like it is standing still it will never reach the next macro step.
How do I "reset" it to Run state Ready?

Regards
MellBI

[StuartS]

Hello

The only way I am aware of is to re-execute the macro. 

If you want READY then it needs to run to completion.

You could execute and then press stop immediately.   This will provide a status of STOPPED.  This assumes the first step is something like wait for jobs and does not do anything you dont want running.

Regards

Stuart

[andy_acacia]

Can you tell me what the macro step is doing?

[francois]

If you execute a contributor administration console macro running an analyst macro there's some case you will face an error like the one you're describing :

for a publish on a sql database using an odbc sql server (because you can't use native for publish, planning doesn't allow) you'll never receive the completion status even if the macro's succeeded.

that's a bug, known and not solved : "Analyst ODBC macro run via Contributor macro sits at'Running' state until the process is deleted"

[JaromirSeps]

Try to go to job servers management, stop them all and delete them.
Add them again
It should produce an error on the macro and stop it.
Worked in some cases for me.
Jaromir

[MellBI]

Hi,

Thank you for the suggested actions.
I deleted some of the running macros and I restarted some of them to get them out of the state "Running"


/MellBI