You cannot overwrite the default version (Published) of a project

[malik]

When I try to import project to enterprise using “Import Project to
Enterprise†wizard from Tools -> Enterprise Options, I am faced with the
error “You cannot overwrite the default version (Published) of a project. To
save this project, type a new project name or save the project as a version
other than the default.â€

The Project is not in the projects list gird in “Project Centerâ€. But the
project is available in the list of check out projects (Admin -> Manage
Enterprise Features -> Check in enterprise projects ). When I try to force
check in, the project is removed from the list. It is still not in the
projects list grid in “Project Center†and the error continues.

We are using project server 2003.

Any suggestions?

 

[Chak]

Hi malik.

It seems to be the previous project plan still in the server. It may
be not be appearing on Project Open dialog box
or Project center.

It is not possible to give the same name for new project. Project plan
with same name have to removed from the server.

Please look under PWA -> Cleanup Project Server Database option to
delete the plan.

Otherwise, import the plan with different name.


Thanks
Chak
http://www.epmcentral.com

 

[malik]

Hi Chak,

Thanks for the reply but thats the problem, project is not not visible at
"Cleanup Project Server Database". Project is visible in (Admin -> Manage

Enterprise Features -> Check in enterprise projects ) but not in "Cleanup Project Server Database".

Any suggestions?

 

[Chak]

Malik,

What exactly you are thinking do? Let me understand your process:

Scenario:

You are seeing the project called "epm project" under Admin -> Manage

Enterprise Features -> Check in enterprise projects; It is not

showing up now, as you already did forceful check in.

You are trying to import project called "epm project". You are unbale
to import due to the error "You cannot overwrite the default version
(Published) of a project. To save this project, type a new project
name or save the project as a version
other than the default.” "

As I said, it is not possible to import/save the new project with name
"epm project" due to project with this same name already exists on the
server.

What exactly you want to do here? Do you want to delete the existing
project, so you can import the new project with same name?


If your answer is "Yes", please do the following:


1) Try to open the existing project from MS Project Pro 2003

2) Find out the existing project is visible in PWA -> Project Center
or not?

3) If you didn't see the project in step 1, step 2, you can query
Project Server database to find out the existence of the project

Select PROJ_ID, PROJ_Name FROM MSP_PROJECTS
ORDER BY PROJ_NAME

SELECT WPROJ_ID, WPROJ_NAME FROM MSP_WEB_PROJECTS
ORDER BY WPROJ_NAME


4) I hope, you will find the project name in MSP_PROJECTS. IBut if
you are not seeing the same project name in MSP_WEB_PROJECTS, it
indicates this project is a ghost project. It means, earlier some one
attempted to delete this project and deletion process not went through
properly.


Ghost projects can be deleted by using ODBC method:


*****************************************************************************
Steps to delete the project using ODBC in MS Project Server 2003:


1) Create the system DSN (machine data source pointing to Project
Server Database).


2) Launch project professional 2003


3) File -> Open -> Open from File -> ODBC


4) Select the DSN created on step 1.


You will see all the project plans from project server including ghost
plans.


5) Highlight the plan and click X to delete the plan


************************************************************

Thanks
Chak
http://www.epmcentral.com

 

[malik]

Thanks Chak for the reply. This is excatly what I want to accomplish.

I asked IT to run the command and they replied with the error message

Invalid column name 'WPROJ_NAME'.

for the second query

SELECT WPROJ_ID, WPROJ_NAME FROM MSP_WEB_PROJECTS
ORDER BY WPROJ_NAME

The first query retun three rows.

I don't have access to Project Server database and this is what IT brought
to me.

Any suggestion?

Thnaks agaian.

Regards,

 

[Chak]

Malik,

My mistake. Please try the the following:

SELECT WPROJ_ID, PROJ_NAME FROM MSP_WEB_PROJECTS
ORDER BY PROJ_NAME

You said, first query return only three rows. It means you have only
three projects in Project Server?


Thanks
Chak
http://www.epmcentral.com

 

[malik]

Thanks Chak.

It did the trick. I have to fight with IT in order to get the access rights
and do what you suggested.

Thnaks a lot.

Regards,

 

[Chak]

Malik,

Glad to hear from you about resolving your error.

Yes, it is all depends on organizational policies, but it is always
nice to have the application/database server access to MSPS
administrators. It helps to troubleshoot the issues effectively
without depending on IT folks.

Thanks
Chak
http://www.epmcentral.com

 

[malik]

Hi Chalk,

Sorry to bother you again, but the problem is reversed. I have deleted a
project using ODBC although it was visible in PWA.

After deleting, the project is still visible in PWA and if I try to delet it
using Admin -> Clean Up Project Database, it return me error that operation
cannot completed.

Any suggestion?