2022年4月28日 星期四

Oracle EBS: cancel request時出現could not lock request訊息, 無法成功cancel

問題:  cancel request時出現could not lock request訊息, 無法成功cancel

狀況:

1.以XML publisher寫的程式執行過久, 要cancel時出現訊息could not lock request


2.程式超過3小時後complete warning

3.log有訊息: 

The Output Post-processor is running but has not picked up this request. 
No further attempts will be made to post-process this request, and the request will be marked 
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.


解決方式:

1.Restart Output Post Processor

2.在DB中找出並cancel異常程式對應的session

3.手動更新異常concurrent request的狀態


Ref:

1.Concurrent request receiving Could Not Lock Request when canceling

https://doyensys.com/blogs/concurrent-request-receiving-could-not-lock-request-when-canceling/


2.could not lock request concurrent manager

https://mohamedazar.com/2019/05/16/could-not-lock-request-concurrent-manager/