Error msg - "Overwrite default version"

[John L]

We're getting the following error msg: "You cannot overwrite the default
version (published) of a project"

We've looked all over for a file with the same name, checked in all our
projects, etc. and still can't figure this out.

Can someone explain why we're getting this error msg?

Thanks !

 

[Dale Howard [MVP]]

John L --

What is the history of the project in question? Is it a new project from
scratch? Is it an existing project? Has the project been saved as an .mpp
file? Is it saved as an alternate Version and you are trying to replace the
Published version with the alternate version? Let us know more and we'll
try to help.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the books on Project Server"

 

[John L]

Hi Dale!

My partner was creating a new project using an existing template - not sure
how he saved it, (maybe he fat-fingered something?) but we can't find the
file and we can't create a new project using that same "descriptor". We use
a 5 digit # to name the files and we usually start with a template then save
as a .mpp file.

I think our other partner was working on the template about the same time,
so maybe we have this file floating out there on the server in a "checked
out" status or something.

We have gone into PWA and tried to delete that file, but it isn't there. We
have both tried to "Check In" our projects, but can't see it there either.

We are running two concurrent numbering systems, so we need that exact file
name (5 digit number) to correspond with our other system (accounting - not
tied into Project), so just skipping that file name isn't an option.

I appreciate your help!

BTW - I was born in Denver and grew up in Aurora - living in MO now -
"restless native"

 

[John L]

New information. While working on this project, the program (MS Project Pro)
crashed, giving him the illustrious "Do you wish to send an error report"
msg.

Does the server still think this project is "Checked out"? If so, it's not
showing it in the Admin section, Project section, or in Project Pro files.

Hmmmmm.

 

[Dale Howard [MVP]]

John L --

Hmmmmm is right. I would suspect the project is still in a checked out
state, but is not showing up in the PWA interface to check it back in again.
Refer to the following link for the steps needed by your SQL Server DBA to
check it in directly in the SQL Server database:

http://www.projectserverexperts.com/Shared Documents/checkinprojectsandresources.htm

Although I live in Dener, I used to live in Gladstone, Missouri and worked
for a company in Kansas City that no longer exists. Hope this helps.

 

[John L]

Dale,

We'll try this in the morning, and I'll get back with you if (when?) it works.

Thanks for your attention and prompt reply - BTW your Blue Book with Gary
Chefetz just arrived! : ) I'll read it and get smarter!

I was a Sprint Telecomm casualty, so I was in KC too! When I'm home for a
visit, I'll look you guys up, see if there's a seminar or something going on.

 

[Dale Howard [MVP]]

John L --

I would have been a Farmland Industries casualty, but jumped ship before its
demise and become a trainer/consultant with Microsoft Project. Let me know
how the problem resolution goes, if at all.

 

[John L]

Dale,

We tried your solution, entering a "0" in the SQL db to check the project
back in. That didn't work, so we decided to compare SQL tables and looked at
other projects and compared the columns.

We found out that the problem project had "NULL" for many table values... as
well as a "100" in the "proj_type" column. We figured we couldn't hurt
anything by changing these values around, so we tried it. (we changed the
"100" to a "0" to match the other projects).

This resulted in still not being able to see the project in PWA, but it was
now accessible in MS Project Professional - from where we promptly deleted
the problem child.

Thanks for your help, and for at least putting us on a path to correct this
- I thought I would post the outcome, maybe someone knows exactly what we
did...

Gonna read more on the SQL engine - although I wasn't quite prepared to dig
this deep! LOL.


John

========================================================

 

[Dale Howard [MVP]]

John L --

Thanks for your perserverance and for sharing the solution to your problem
with us.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the books on Project Server"