Manufacturing "Check Data" Script

(0) Share

Report

Posted on by Community Member

Hello:

In a test environment where the company database is over 11 GB, I have imported additional inventory items, bills of material, routings, and quantities. After conducting other necessary configurations, I know that the "exec mfgfix90CHECKDATA" script needs to be run against the company database.

I ran it, for about 45 minutes. It never concluded. So, I stopped it since I needed to move on to my other "daily" tasks.

I was trying to generate the results to file. Would it have been any faster, if I had simply generated results to "screen"?

I know that it's good practice to run this. But, is it a "must"? I'm just trying to be proactive, before importing data into production.

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

Hi John, In my 3 GB database the script ran for over 2 hours. I don't have great hardware but I think it's just one of those scripts you have to kick off at the end of the day and let it run. Of course, I had over 800 pages of issues to deal with in my production environment...

-Trevor

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, Trevor!

John

Was this reply helpful? Yes No