Skip to main content

Hi IFS Community!

Reposting this to the Framework & Experience subforum. Here’s the contents of the original post to the Buying sub-forum:

I’ve been tasked with hunting down why a Scheduled Database Task for process Mrp_Process_API.Schedule_Mrp_Process__ keeps ending with a status of ‘Error’. The Error Text field has a notice “This background job was set to state Error because the executing Oracle process was killed. ( Detected by cleanup process at 2025-01-08-23.49.11 )”. I’ve checked out a few other Community posts noting that the Light Cleanup process may be responsible, but the Light Cleanup job was posted / started executing 2 seconds after the time reported in the MRP background job. The last bit of output in the background job is:

“Site X MS Calculation for MS parts that have received exploded demand started at 20250108 21:36:24”

I’ve checked out the Oracle Alert log and other background jobs executing around the same time that the process was killed, but the only thing that I see being suspicious is this entry in the Oracle Alert log:

2025-01-08T23:54:59.981027-06:00
NET  (PID:13564): Possible network disconnect with primary database
NET  (PID:13564): while processing B-1160408753.T-1.S-56173 BNUM:2138112 BCNT:939
NET  (PID:13564): RFS client TEST (PID:0)

I know I’m taking this in from a technical perspective, but figured out reach out to some functional folks instead of posting this in the Framework & Experience sub-forum to see if anyone else has encountered this and identified a resolution.

Many thanks, and let me know if there’s anything else I could supply to help with identifying a resolution.

Regards,

Randy

Hi ​@EsiRandyG 
It will be good if you could:

Analyze Oracle Alert Logs and Trace Files

  • Check for additional details related to the network disconnect or other errors logged around the same time as the job failure.
  • Look for Resource Manager or session termination entries.

Validate MRP Job Configuration

  • Review the settings for Mrp_Process_API.Schedule_Mrp_Process__:
    • Ensure the data scope is appropriate for the job (e.g., reducing the number of sites or parts processed in a single run).
    • Check for any customizations or modifications to the MRP process that might increase its resource demands.

Reply