How fortunate you have been to enjoy your many years at the university, and how fortunate we all have been to have you share your expertise and insights with the JDE community. I wish you all the best in your retirement - may it be a long and fulfilling one, and yes, you're always...
Do you have any backup software clients on your servers? We had a BackupExec client on our db server that would cause 30 second freeze-ups once every few hours. Eventually we found it and disabled it during our normal production hours.
Due to several factors, we have some pieces of equipment in our facility that have both a Fixed Asset Master record, and also an Equipment Master record. Is there any way to combine them so that we can use the same Unit Number? My hunch is no, but I'd love to be proven wrong! Thanks.
Yes, there is a Data Selection import tool that works great. We use the Google Chrome extension. Check out the link below.
One thing you might check is to make sure you don't have any Item Master or Item Branch records with a short item number (alias ITM) of zero. We've had these appear once in a great while and they significantly impacted MRP performance.
You could also set up each building as a separate Branch/Plant and have a separate Item/Branch, BOM and Routing for each B/P.
There is the ability to copy a BOM and a Routing from one B/P to another. Of course, maintenance (e.g. ECO's) will be more challenging with multiple B/P's.
You could refresh another environment's business data and control tables from your Production database, add the planned demand into that non-Production database, and then run MRP over there. Of course, database refreshes vary widely in time to complete; ours currently takes about 3 minutes, but...
You might also have your CNC person delete the 6 spec ddb/xdb files on your enterprise/batch server(s).
They are located in a folder like "E910\***\spec". Delete these files: dddict, ddtext, glbltbl, both ddb and xdb files.
These can cache data dictionary information.