COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: MellBI on 25 Aug 2010 04:42:33 AM

Title: How do I Stop a macro that have been running for 6 days? - Solved
Post by: MellBI on 25 Aug 2010 04:42:33 AM
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
Title: Re: How do I Stop a macro that have been running for 6 days?
Post by: StuartS on 27 Aug 2010 02:56:32 AM
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

Title: Re: How do I Stop a macro that have been running for 6 days?
Post by: andy_acacia on 27 Aug 2010 06:23:51 AM
Can you tell me what the macro step is doing?
Title: Re: How do I Stop a macro that have been running for 6 days?
Post by: francois on 30 Aug 2010 07:28:55 AM
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"
Title: Re: How do I Stop a macro that have been running for 6 days?
Post by: JaromirSeps on 31 Aug 2010 02:54:31 AM
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
Title: Re: How do I Stop a macro that have been running for 6 days? - Solved
Post by: MellBI on 01 Sep 2010 06:05:47 AM
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