Question

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

  • 23 May 2021
  • 1 reply
  • 235 views
W
Rank
Userlevel 4
Badge +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
Rank
Userlevel 6
Badge +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

Nadeesh Herath
Terms & ConditionsCookie settings