Tip: Stopped Oracle Queues

  • 16 December 2019
  • 2 replies
  • 433 views

Userlevel 6
Badge +15

When you do an Oracle Export/Import (and some other operations) the Oracle Queues will become disabled. In this state the application can’t enqueue or dequeue messages from it. If the application tries to do those operation it will end up with an Oracle Exception.

If you see these errors you would need to go to IFS Solution Manager -> Monitoring ->Oracle Queues -> Oracle Queues and start the queue mentioned in the error message

 

See LCS Solution 275872


2 replies

Userlevel 7
Badge +18

I’ve seen a strange problem in the past that prevented the queues from being initialized.

 

  • When you try to call DBMS_SCHEDULER.DISABLE, it says it's running.
  • When you try to call DBMS_SCHEDULER.STOP_JOB, it say it's not running.

 

The solution is to enable it, then stop it, then disable it, then go back to Apps and reinitialize the queue.

The first part of the solution looks something like this...

 

BEGIN

   dbms_scheduler.enable('F1JOB_126');

   dbms_scheduler.stop_job('F1JOB_126');

   dbms_scheduler.disable('F1JOB_126');

END;

/

Badge +4

When installing IFS Deliveries also, the IFS Installer disables all scheduled jobs and enables all of them at the end of the installation. Sometimes rarely, this may not go perfectly and can have some jobs not enabled even after the IFS delivery installation has finished.

Reply