The operation cannot be completed because the source file contains invalid project data or the total

[Luis Porras]

Hi,

How can I repair a .mpp file with this error:

"The operation cannot be completed because the source file contains invalid
project data or the total number of rows would exceed the limit of 1,048,000
rows in a project"

It looks like it has a circular reference, but I can't open it!!!

Thanks!

~Luis

 

[Rod Gill]

There's not much you can do if a .mpp file can't be opened. There's plenty
once it is open!

Can you try opening with another PC?

Are there any macros in the file? Resource pool or master project
connections?

 

[Luis Porras]

I tried from another PC... same error

Yes, the project has macros and resource pool connections... I tried opening
an old version of the same file and I have no errors from it...

 

[John]

Hi,

How can I repair a .mpp file with this error:

"The operation cannot be completed because the source file contains invalid
project data or the total number of rows would exceed the limit of 1,048,000
rows in a project"

It looks like it has a circular reference, but I can't open it!!!

Thanks!

~Luis

Luis,
If you can't even open the file you may be out of luck. With Project
active but no projects open, try turning off automatic calculation
(Tools/Options/Calculation tab). You may get lucky and then be able to
open the file. If you can, first look for links on summary lines since
they are the most prominent cause for circular relationships. Remove
links and summary lines and then turn calculation back on. If that
solves the problem, you might be OK. If that doesn't solve the problem,
follow the steps in FAQ 43 - File Bloat? Might be corruption, which you
can find on our MVP website at: http://project.mvps.org/faqs.htm.

If none of the above works, you might try sorting by Unique ID.
Sometimes an inadvertent keystroke can create a rogue task that is way
out in left field. If there is a blank task name for the highest Unique
ID, then delete that task and see if that helps.

Hope this helps. Let us know how things work out.

John
Project MVP

 

[Luis Porras]

John,

I already tried with turning off the automatic calculation with no luck...
Also, I followed the instructions in the website (Faq.43) but the project
saves an empty project db...

~Luis

 

[John]

John,

I already tried with turning off the automatic calculation with no luck...
Also, I followed the instructions in the website (Faq.43) but the project
saves an empty project db...

~Luis

Luis,
Sorry for the late reply. You post got buried down so far down in my
newsreader list that I didn't see your replies back to my post and Rod's.

Based on your response to Rod's questions, I'd say something became
corrupt to the point where the current file cannot be recovered. I
suggest you start with the last version that will open, perhaps run the
corruption clearing process on it (i.e. FAQ 43), and then rebuild the
file from there. Not what you wanted to hear, but this type of
occurrence is the best reason to do periodic backups.

John
Project MVP