Page 1 of 1

Job remain blue

Posted: 19 Jul 2010 2:20
by Kayhman
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.

Posted: 26 Jul 2010 4:31
by Kayhman
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.

Posted: 26 Jul 2010 4:51
by philmalmaison
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

Posted: 22 Sep 2010 4:42
by Kayhman
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 ;)