EXCEPTION FOREIGN_LOCK, nothing done!- CLEAN_REQREQ_UP job

[Former Member]

Dear Experts

When I create a shc, the same is approved & a follow on document couldn't be created. The reason being job CLEAN_REQREQ_UP is not running correctly & upon execution gives a message 'EXCEPTION FOREIGN_LOCK, nothing done!'. Pls advise.

Ravi

[Former Member]

Hi,

Please check any long running job in the system which is more than expected and immediately cancel that job.

Again reschedule the job CLEAN_REQREQ_UP and check.

This issue has been encountered after a database refresh activity by our basis team earlier.

Regards,

Suresh