Solved

Mobile_Cleanup_Sys.Clean_Faulty_Sync_Tasks__ is executing and not completing

3 years ago
May 4, 2021
3 replies
176 views

+7

CUCSOLUTIONS
Sidekick (Customer)
26 replies

Good day. recently the Mobile_Cleanup_Sys.Clean_Faulty_Sync_Tasks__ is never completing and just keeps executing. We try and kill the job, but it wont stop.

I tried setting the error fag on the front end (IEE) and it wont allow me to set this job as an error or stop the job.

We tried placing this in its own batch queue to keep it from jamming up the queue and adding more processes to its queue and it just kicked off more of these jobs that will not complete.

We are running APPS9 UD14 and mWO.

Where to look to diagnose and resolve this issue and how can you kill a process that wont die?

Best answer by Chathuranga Samarakoon

@CUCSOLUTIONS you run below SQL command and you can use serial column to list session in database session screen.sessions.

SELECT level,
LPAD(' ', (level-1)*2, ' ') || NVL(s.username, '(oracle)') AS username,
s.osuser,
s.sid,
s.serial#,
s.lockwait,
s.status,
s.module,
s.machine,
s.program,
TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time
FROM v$session s
WHERE level > 1
OR EXISTS (SELECT 1
FROM v$session
WHERE blocking_session = s.sid)
CONNECT BY PRIOR s.sid = s.blocking_session
START WITH s.blocking_session IS NULL

View original

Did this topic help you find an answer to your question?

This topic has been closed for comments

+12

Chathuranga Samarakoon
Hero (Partner)
100 replies
Answer
3 years ago
May 4, 2021

@CUCSOLUTIONS you run below SQL command and you can use serial column to list session in database session screen.sessions.

SELECT level,
LPAD(' ', (level-1)*2, ' ') || NVL(s.username, '(oracle)') AS username,
s.osuser,
s.sid,
s.serial#,
s.lockwait,
s.status,
s.module,
s.machine,
s.program,
TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time
FROM v$session s
WHERE level > 1
OR EXISTS (SELECT 1
FROM v$session
WHERE blocking_session = s.sid)
CONNECT BY PRIOR s.sid = s.blocking_session
START WITH s.blocking_session IS NULL

Chathuranga Samarakoon

X

A

+9

Nadeesh Herath
Hero (Employee)
74 replies
3 years ago
May 4, 2021

@CUCSOLUTIONS

As Chathuranga has mentioned above, you could kill the blocking session that is holding the job. Just to add to this you could also view the blocking sessions by following the below steps on PLSQL Developer (through SYS user).

Tools → Sessions → Locked Sessions

Additionally, you also kill the above job from the database by executing the following script from PLSQL Developer.

begin
-- Call the procedure
transaction_sys.stop_job(id_ => :id_);
end;

:id = the job ID of the Mobile_Cleanup_Sys.Clean_Faulty_Sync_Tasks__ background job.

Hope this helps.

Regards,

Nadeesh

Nadeesh Herath

X

A

+7

CUCSOLUTIONS
Author
Sidekick (Customer)
26 replies
3 years ago
May 4, 2021

Thx so much for your feedback and recommendations …. I am saving this in my IFS Admin cheat sheets.

Mobile_Cleanup_Sys.Clean_Faulty_Sync_Tasks__ is executing and not completing

3 replies

Cookie policy

Cookie settings

Related Topics

Gruppe wird gestoppt bei Bewegungserfassung einer anderen Gruppe

Alexa spielt erst bei Wiederholung des Befehls den Titelicon

Beam "Gruppierung ignorieren" ist eigentlich "Gruppierung abschalten"?icon

Probleme im WLAN mit Mesh - Playbar + Sub+ Surround Boxen lassen sich nicht zu Gruppe mit anderen Geräten hinzufügenicon

Move lässt sich nicht in eine Gruppe einfügenicon

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings