Skip to main content
Question

Installation of UPD8 in App 10 held up by (2) running processes

  • May 23, 2021
  • 1 reply
  • 302 views

Forum|alt.badge.img+9

These processes seem to be holding up the installation of UPD8 in apps 10 . . .

 

The following F1 jobs are currently running
===========================================
F1JOB_3                  Transaction_SYS.Process_All_Pending__(0,'Default Queue','%',job_id_)
   Running job: Dictionary_Sys.Post_Rebuild_Dictionary__
F1JOB_2190               Mobile_Db_Process_SYS.Push_Data_('MaintEngApp')
 
Use Install_Tem_SYS.Stop_Scheduler_Processes to stop all currently running F1 jobs if you do not want to wait until they finish.

This topic has been closed for comments

1 reply

Nadeesh Herath
Hero (Employee)
Forum|alt.badge.img+9

@woprhowe,

 

If the UPD installation is in progress, you could execute the following from the database as App owner,

 

begin
  -- Call the procedure
  install_tem_sys.stop_scheduler_processes;
end;

 

In the meantime, it is recommended to make the job_queue_processes  of the database to 0, when installing a UPD as this would prevent all new background/scheduler jobs from executing.

This can be done by executing the following command on the database,

 

ALTER SYSTEM SET job_queue_processes=0 SCOPE=SPFILE;

 

(Make sure to alter it back to the old count after the installation)

Or you could also use the System parameters window,

 

Regards,

Nadeesh


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings