Deactivate a concurent manager

[latifa]

Hi Erman,

How are you ? I hope fine :)

I configured Service Manager to run on some servers by mistake and now I would like to deactivate them. I don't see processes in the system but I can see them in the administration console. When ever I try to disable them the sytem rejet me.

Do you have an idea how can I do that. Thanks in adavance for your help.

Regards,
Latifa
disable_Service_Manager.docx

[ErmanArslansOracleBlog]

Hi Latifa,

All good thanks :)

Probably, the concurrent manager being updated is processing requests..

Did you try stopping the concurrent managers using "adcmctl.sh stop apps/<apps password>" and then disabling that manager using CM manager screen?

[latifa]

Hi Erman,

Thank you for your reply.

Yes I have done what you said. Please find the attached file to see what I have done.

Regards,
Latifa
disable_Service_Manager_2.docx

[ErmanArslansOracleBlog]

What happens when you do the following;

1)start your concurrent managers,
2)deactivate service manager
3)disable service manager

[latifa]

No screen to do that, it's gray box to deactivate.

disable_Service_Manager_3.docx

[ErmanArslansOracleBlog]

This is a TEST/UAT/DEV env right..

So you may update it from backend;

Update fnd_concurrent_queues set running_processes=0,max_processes=0 WHERE CONCURRENT_QUEUE_NAME = 'BLABLABLAAA';

UPDATE applsys.FND_CONCURRENT_QUEUES SET enabled_flag = 'N'
WHERE CONCURRENT_QUEUE_NAME = 'BLABLABLAAA';
commit;

This is not a supported move, so the risk is yours :)

[latifa]

yes, It's not production env (preproduction env).

But next step should be production. I'll try what you said on this environment and I'll see.

However, I think if we leave them appearing in the CM's console, it will not disturb. But it's strange that we can't do that from the console.

[latifa]

I checked this:

SQL> select running_processes, enabled_flag from fnd_concurrent_queues where  CONCURRENT_QUEUE_NAME='Service Manager: UA11ZAS1' ;

no rows selected

shull we update the table even this results ?

[ErmanArslansOracleBlog]

Can you check the FND_CONCURRENT_QUEUES table as a whole.. Just in case you may be doing punctuation error.

[latifa]

SQL> desc FND_CONCURRENT_QUEUE
ERROR:
ORA-04043: object FND_CONCURRENT_QUEUE does not exist

[ErmanArslansOracleBlog]

Sorry. I mean FND_CONCURRENT_QUEUES :)

[latifa]

I tried this also :)

[ErmanArslansOracleBlog]

What is the output of ;

select CONCURRENT_QUEUE_NAME, enabled_flag from applsys.FND_CONCURRENT_QUEUES;

[latifa]

here you are:
out.txt

[ErmanArslansOracleBlog]

Your service manager's queue name seems to be "FNDSM_UA11ZAS1"

So your update should be;

UPDATE applsys.FND_CONCURRENT_QUEUES SET enabled_flag = 'N'
WHERE CONCURRENT_QUEUE_NAME = 'FNDSM_UA11ZAS1';
commit;

[latifa]

Hi Erman,

I have done this, it works. I also updated the two others not needed: FNDSM_UA11ZAS2 and FNDSM_UA11ZAS3.

Thank you for help.

Just a question: what could be the risk while doing this from the back end ?

Regards,
Latifa

[ErmanArslansOracleBlog]

Good ! :)

It is not supported, this is the risk.. So I suggest you to get the approval of Oracle Support for using this approach in your production..