Renaming & Deleting Projects

[Abi]

Hi I've downloaded all project server utilities recommended by Microsoft in the Project Server 2003 Administrator's Guide including PSCleaner, and PSRenamer.
The Renamer tool only renames the PROJ_NAME field in the MSP_WEB_PROJECTS Table and but it does not change the WLOCAL_PATH, that's why whenever we try to open it from PWA, Project displays an error message that it cannot be found.
Am I right here?

If this is the case, will it be ok to rename the value in WLOCAL_PATH column to its correct name? Thanks

 

[Gary L. Chefetz \(MVP\)]

Abi:

If your aim is to implement in "Enterprise" mode, then you never have a
local path to a project file stored in the database. It sounds like you're
creating non-enterprise projects in your system by publishing project plans
without establishing a connection to the server. You need to stop and do
some more reading through the documentation that came with the system. To
get connected to the server, make sure that you have an account setup in
Project Server (in the normal progress of configuring an enterprise system,
your resource pool and accounts are created before you introduce your first
project to the system).

Open Project Pro
Go to Tools > Enterprise Options > Microsoft Office Project Server Accounts
Create your account using either Windows or Project Server auth according to
your setup
Test Link
Set detect connection state to manual
Save and close
Close Project
Restart Project and connect to the server

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

Hi I've downloaded all project server utilities recommended by Microsoft

in the Project Server 2003 Administrator's Guide including PSCleaner, and
PSRenamer.

The Renamer tool only renames the PROJ_NAME field in the MSP_WEB_PROJECTS

Table and but it does not change the WLOCAL_PATH, that's why whenever we try
to open it from PWA, Project displays an error message that it cannot be
found.

Am I right here?

If this is the case, will it be ok to rename the value in WLOCAL_PATH

column to its correct name? Thanks

 

[Antoon]

I experience the same problem as Abi, I suppose.

We work completely in enterprise mode.
After renaming a project using the ProjectRenamer utility, in Project
WebAccess everything seems perfect.

However, when a user opens Project Center in Project Professional, and then
clicks the 'Open in Project' button, the following error message is shown:
'Project Server was unable to find the specified project. Check the project
name and version. If the problem continues, contact your server
administrator'.

Renaming the project to the old project name again (with projectRenamer)
makes things work again.

To my opinion, the ProjectRenamer utility does not update all necessary
tables.



Regards,
Antoon

 

[Antoon]

Everything works fine now.

I forgot to apply the SQL patch that comes with Project Server 2003 SP1.
To make the rename utility work without problems, first get rid of all
pending task updates.


Cheers,
Antoon

I tried renaming a project by executing an SQL statement
sampleSQLQuery2RenameProject.txt from the Project Renamer sample of the PDS
Reference Downloads, which I customized to use my project id and new project
name. The query looks like this (before my changes)

UPDATE MSP_WEB_PROJECTS SET PROJ_NAME='Name1' WHERE PROJ_ID=5 OR PROJ_ID in
(select PROJ_ID from MSP_PROJECTS where PROJ_ID in (5) OR
(SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))in (select
(SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))from MSP_PROJECTS where
PROJ_ID in (5)))

UPDATE MSP_VIEW_PROJ_PROJECTS_STD SET
ProjectTitle='Name1'+(SUBSTRING(ProjectTitle,CHARINDEX('.',ProjectTitle),LEN(ProjectTitle)))WHERE
ProjectUniqueID=5 OR ProjectUniqueID in (select PROJ_ID from MSP_PROJECTS
where PROJ_ID in (5) OR (SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))in
(select (SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))from MSP_PROJECTS
where PROJ_ID in (5)))

UPDATE MSP_VIEW_PROJ_TASKS_STD SET
TaskName='Name1'+(SUBSTRING(TaskName,CHARINDEX('.',TaskName),LEN(TaskName)))WHERE
TaskUniqueID=0 And (ProjectUniqueID=5 OR ProjectUniqueID in (select PROJ_ID
from MSP_PROJECTS where PROJ_ID in (5) OR
(SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))in (select
(SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))from MSP_PROJECTS where
PROJ_ID in (5))))

UPDATE MSP_WEB_ASSIGNMENTS SET
TASK_NAME='Name1'+(SUBSTRING(TASK_NAME,CHARINDEX('.',TASK_NAME),LEN(TASK_NAME)))WHERE
TASK_UID=0 And WPROJ_ID in (SELECT WPROJ_ID from MSP_WEB_PROJECTS WHERE
PROJ_ID=5 OR PROJ_ID in (select PROJ_ID from MSP_PROJECTS where PROJ_ID in
(5) OR (SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))in (select
(SUBSTRING(PROJ_NAME,0,CHARINDEX('.',PROJ_NAME)))from MSP_PROJECTS where
PROJ_ID in (5))))

I executed this using Query Analyzer, and received the following feedback:


(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)


After this, the project is renamed and can be opened with Project
Professional from the Project Center.

Now, when saving the project, I get a Database Error 0x80040E14. The
'project file' column in Office Project Server Spooler shows [old project
name].published

When I now rename the project back to the old name, everything works fine,
no messages in the Spooler ...

To be continued!

.

I experience the same problem as Abi, I suppose.

We work completely in enterprise mode.
After renaming a project using the ProjectRenamer utility, in Project
WebAccess everything seems perfect.

However, when a user opens Project Center in Project Professional, and then
clicks the 'Open in Project' button, the following error message is shown:
'Project Server was unable to find the specified project. Check the project
name and version. If the problem continues, contact your server
administrator'.

Renaming the project to the old project name again (with projectRenamer)
makes things work again.

To my opinion, the ProjectRenamer utility does not update all necessary
tables.



Regards,
Antoon