MRP Job Unable to Delete - MRP hanging

HELP!! We’re unable to run MRP and are “stuck”. We have an MRP job sitting there that we can’t delete.

We’re getting a 4GL error.
Error Detail

4GL STOP condition: The Server application has returned an error. (7243) (7241)

Stack Trace

at Epicor.Mfg.UI.Adapters.JobEntryAdapter.Delete(DataRow dr)
at Epicor.Mfg.UI.App.JobEntry.Transaction.Delete()

About the only other thing I can think of doing is to reboot the server.

Thoughts?
Thanks

Houston - we have a problem.
We did a server re-start last night and it runs out we have some database corruption on the BI file. After some tweaking (and a LOT of praying) I got the database back on line - but the error below still persists. it sounds (to me) like there is a corrupted index somewhere - like maybe the PartDtl Table. Anyone else ever seen something like this?
Please dvise.

[17/09/05@22:53:43.328-0500] P-003988 T-003200 1 AS – (Procedure: ‘DELETE-TRIGGER mr/MrpExpCD.p’ Line:34611) SYSTEM ERROR: Index JobDemand in PartDtl for recid 192347533 could not be deleted. (1422)
[17/09/05@23:31:50.808-0500] P-003564 T-003560 1 AS – (Procedure: ‘main-block mr/MrpExpSched.p’ Line:28931) Cancelling from main-block
[17/09/05@23:31:55.761-0500] P-002528 T-001492 1 AS – (Procedure: ‘mrp mr/MrpExp.p’ Line:32954) Cancelling from mrp
[17/09/06@04:46:43.919-0500] P-002528 T-001492 1 AS – as/connect.p connect procedure ended with an ERROR condition. (8025)
[17/09/06@04:51:29.789-0500] P-003564 T-003560 1 AS – as/connect.p connect procedure ended with an ERROR condition. (8025)
[

Jeesh! finally back up an running.

Turned out to be a bad block in the BI file, database corruption, a down database, truncate BI force, prostrct repair and then a proutil idxbuild.

But all’s well that ends well.

and a few (more) gray hairs… ouch!

2 Likes