Job remain blue

Kayhman · Post by **Kayhman** » 19 Jul 2010 2:20

Bonjour,

J'ai un probleme avec un job controlm qui reste en waiting control ressource alors que la ressource n'est pas utilisée.

J'ai donc essayé de modifier les tables CMR_CTLUSE, CMR_CTL_J et CMR_CTLTAB sans succes.

Quelqu'un peut il m'aider sachant que le ControlM est en version 2.2.4 sur un serveur NT4.

D'avance merci.

-------------------

Hello,

I have a probleme with a controlm job which remains waiting control resource there while the resource is not used.

I thus tried to modify tables CMR_CTLUSE, CMR_CTL_J and CMR_CTLTAB without succes.

Somebody can help me knowing that ControlM is in version 2.2.4 on a NT4 server.

Thank you in advance.

Kayhman · Post by **Kayhman** » 26 Jul 2010 4:31

Hi,

No, the job still stay in blue after placed on HOLD and released.

But thx for the answer

And i have this issue only with 1 job.
Every jobs with Control Ressource runs correctly.

philmalmaison · Post by **philmalmaison** » 26 Jul 2010 4:51

detect witch order_id it is for this job
on command line on controlm server type :
p_36 <order_id>
then
update CMR_AJF set STATE = '5', OSCOMPSTAT=1, STATUS='N' where ORDERNO = <number>

after doing it just hold/free the jobs should become in red status.

regards
Philmalmaison

Kayhman · Post by **Kayhman** » 22 Sep 2010 4:42

Sorry, i forgot to give you an answer.

I tried this but the ressource was not released.

I tried another method:
I forced the job in status running and forced to allocate the ressource to the job. And i killed the job. And it was ok.

update CMR_AJF set STATE = '4', OSCOMPSTAT=0, STATUS='' where ORDERNO = XXXXXX

insert into CMR_CTLUSE values ('Ressource_Name','E','N','','XXXXXX')

Thanks for your help