Urgent Help Required,
Where do I start to look to try and find out why our background jobs in Apps9 have stopped auto executing - they are being posted but only start when we are manually executing them. If I manually execute them they run no issues. The individual who had this knowledge has left the business and this isn’t documented anywhere.
Thanks for any help, Sarah
Please check value of oracle database parameter job_queue_processes. It should be higher than 0. Default Oracle value is 1000.
Do You faced problems with delivery installations last time(eq. terminated unexpectly or something like that)?
hi
Not here. Try from Application Monitoring Console(Number of Oracle queue processes ) or just by sql query:
select * from v$parameter where name = ‘job_queue_processes’.
Piotr
Hi
The database Processes in Solution Manager - Background processing - Background Jobs - Database Processes have been stopped and restarted in an attempt to sort but this hasn’t helped - any other suggestions much appreciated
+18
If Oracle job_queue_processes parameter is > 0, run the following script to re-enable IFS Batch Processing as App Owner user:
exec install_tem_sys.enable_scheduler_processes;
Thanks for this, we have in the UI on the batch queue configuration Initiated all batch queues.
From this the database processes are now not running by the looks of the below - help very much appreciated
+18
Hi, Can I have more background regarding the changes done in the affected IFS 9 environment leading up to this issue?
How are you checking whether job_queue_processes is set to a non-zero value? Can you please provide a screenshot?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
