My Oracle Support Banner

OBP 14.5.4.0.0 | MESSAGE_STATUS_UPDATER_JOB Job Stuck In Loop And Continuously Writing Logs (Doc ID 2998531.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Banking Payments - Version 14.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
In the environment, observed that MESSAGE_STATUS_UPDATER_JOB is continuously running and writing logs. On further analysis, we found that this job runs through all the records in PMTB_MSG_DLY_MSG_OUT with MSG_STATUS 'B' and tries to update the MSG_STATUS to 'G' for all valid transactions.

As the number of transactions increases, this job will keep looping through them and continuously write debugs and have performance impact.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.