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