|
How to execute pending requests? 14 Years, 3 Months ago
|
|
How can execute open requests which are in pending state for some time, I also have some older request in the queue which i am not sure wheather they needed to be executed? Please Advise. Thanks.
|
|
|
|
|
The administrator has disabled public write access.
|
Charlie (User)
Gold Boarder
Posts: 284
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
The reason you have jobs in the Pending Standby state, is because you have INCOMPATABILITY
issues regarding jobs.
ie. Job #1 can not run while Job #2 is running.
Find out which jobs are currently running.
Read up on INCOMPATABILITY in the System Administrators Users guide.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
How do you check if any job running? I do not see on my requests list.
There is no-one else on this system.
|
|
|
|
|
Last Edit: 2010/02/03 02:17 By handsonerp.
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Is your concurrent manager running?
Looks like either concurrent manager is down or standard manager is down.
Please post a screen shot for this window:
Concurrent -> Manager -> Administer
Hasan
|
|
|
|
|
Last Edit: 2010/01/25 04:16 By handsonerp.
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - Attached are the screen shot for concurrent->Manager-> Administer
I also tried restart, terminate and activate option but it did not help either.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Sorry, I posted requests screen shot twice. Concurrent manager screen shot.
|
|
|
|
|
The administrator has disabled public write access.
|
Charlie (User)
Gold Boarder
Posts: 284
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
If you have confirmed that the manager is up and running... then try the following :
Place the open periods jobs on HOLD. WAIT.. and see if the other jobs start up.
Then place the Compile hierarchies jobs on HOLD... and wait to see what happens... the other jobs should start running...
if so.. wait till they finish and release the HOLDS one at a time...
Monitor the progress of the jobs in the queue.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Holding and releasing job has no bearing. Jobs are not running.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Concurrent->Manager-> Administer Screen should show at least
three managers: Concurrent, Standard, and Conflict.
Your screen is showing only one record for Standard.
Could you please query all the records on this screen and then
take the snapshot.
I want to see if Conflict manager is running or not.
Hasan
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - I query Concurrent->Manager-> Administer but I get only one standard managerm, But I did more digging and found error for the 390303,390304,390305 jobs, job name "Compile value set hierarchies".
390303,4,5 Compile value set hierarchies
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set. ORA-06512: at "APPS.FND_MESSAGE", line 509 ORA-06512: at "APPS.MO_GLOBAL", line 36 ORA-06512: at "APPS.MO_GLOBAL", line 757 ORA-06512: at "APPS.MO_GLOBAL", line 700 ORA-06512: at line 1
Job 390306 "Other - Calendar Validation Report which submited and completed after above three jobs were submitted.
Open Period job(392329) is not executing due to
390303 - This request is incompatible with request 392329.
390304 - This request is incompatible with request 392329.
390305 - This request is incompatible with request 392329.
391337 - This request is incompatible with request 392329. Thanks.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - I query Concurrent->Manager-> Administer but I get only one standard managerm, But I did more digging and found error for the 390303,390304,390305 jobs, job name "Compile value set hierarchies".
390303,4,5 Compile value set hierarchies
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set. ORA-06512: at "APPS.FND_MESSAGE", line 509 ORA-06512: at "APPS.MO_GLOBAL", line 36 ORA-06512: at "APPS.MO_GLOBAL", line 757 ORA-06512: at "APPS.MO_GLOBAL", line 700 ORA-06512: at line 1
Job 390306 "Other - Calendar Validation Report which submited and completed after above three jobs were submitted.
Open Period job(392329) is not executing due to
390303 - This request is incompatible with request 392329.
390304 - This request is incompatible with request 392329.
390305 - This request is incompatible with request 392329.
391337 - This request is incompatible with request 392329. Thanks.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - I query Concurrent->Manager-> Administer but I get only one standard managerm, But I did more digging and found error for the 390303,390304,390305 jobs, job name "Compile value set hierarchies".
390303,4,5 Compile value set hierarchies
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set. ORA-06512: at "APPS.FND_MESSAGE", line 509 ORA-06512: at "APPS.MO_GLOBAL", line 36 ORA-06512: at "APPS.MO_GLOBAL", line 757 ORA-06512: at "APPS.MO_GLOBAL", line 700 ORA-06512: at line 1
Job 390306 "Other - Calendar Validation Report which submited and completed after above three jobs were submitted.
Open Period job(392329) is not executing due to
390303 - This request is incompatible with request 392329.
390304 - This request is incompatible with request 392329.
390305 - This request is incompatible with request 392329.
391337 - This request is incompatible with request 392329. Thanks.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - I query Concurrent->Manager-> Administer but I get only one standard manager,
But I did more digging and found error for the 390303,390304,390305 jobs,
job name "Compile value set hierarchies".
Error:
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON,
ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit.
Please check if your profile option MO: Security Profile includes any operating unit
or the profile option MO: Operating Unit is set. ORA-06512: at "APPS.FND_MESSAGE",
line 509 ORA-06512: at "APPS.MO_GLOBAL", line 36 ORA-06512: at "APPS.MO_GLOBAL",
line 757 ORA-06512: at "APPS.MO_GLOBAL", line 700 ORA-06512: at line 1
Job 390306 "Other - Calendar Validation Report which was submited and completed
after above three jobs were submitted.
Open Period job(392329) is not executing due to
390303 - This request is incompatible with request 392329.
390304 - This request is incompatible with request 392329.
390305 - This request is incompatible with request 392329.
391337 - This request is incompatible with request 392329.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - how to provide access privilege to any operating unit, so these request goes thru completion? or Do I need these hierarchies jobs? Should I cancel these jobs and let open period job complete? I am stuck on this step before I can more further. Thanks.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Lets take it one step at a time.
You have not given me the screen shot for:
"Concurrent->Manager-> Administer->Requests".
Go to this screen. Do CTRL+F11 so that all rows are visible and take a
screen shot.
I want to make sure you have three managers running: Internal, Standard,
Conflict.
Thank you.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - Attached is the screen shot for Concurrent: manager-> Administer, also screen shot of the path how I got there.
I see only Standard Manager running which I stated on 1/28 as well. I also did CTRL+F11, as well as F11, typed % and CTRL+F11 but same result.
Thanks for all the help.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - Attached is the screen shot for Concurrent: manager-> Administer, also screen shot of the path how I got there.
I see only Standard Manager running which I stated on 1/28 as well. I also did CTRL+F11, as well as F11, typed % and CTRL+F11 but same result.
Thanks for all the help.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Hasan - Attached is the Concurrent:Manager->Administer-> Request screen shot.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
Your internal manager is down for some reason.
What is the output of this command.
./adcmstl.sh start
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:How to execute pending requests? 14 Years, 3 Months ago
|
|
I executed ./adcmstl.sh, attached is the out of this command. There is no change in Administer Concurrent Manager screen. I did notice when Concurrent Manager starting internal manager with PROD, when I start database I used Prod not PROD. Can this cause a problem?
|
|
|
|
|
The administrator has disabled public write access.
|
|