delete 2007 Project(s) from MS SQL 2005 DB directly

[Dima]

I can't delete poject(s) (project server 2007) using web interface. Is it
possible delete projects from MS SQL 2005 DB directly using SQL query ?
I found procedure [MSP_DELETE_PROJECTS]. Can I use this procedure?

 

[Sharry Heberer [MSFT]]

No, it is not supported to delete projects directly from the DB. Why won't
it work from PWA? That's what I would spend time on, not in finding the
magic SQL query. If you post any errors your getting while deleting
projects, someone can help you better.

Specifically, there should be errors in your Queue. On the Manage Queue
page you can filter by project so it makes it easier to see the history of
that project. You will probably also want to increase the Job History
window, as it defaults to the current day only. If you find a job in the
Failed and Blocking state for that project, that is the problem. If this is
the case, select the job that is in this state, hit the Cancel Job button,
then try to delete the project again. Once the Queue processes the delete
jobs, it should be gone.

 

[Paul Goldman]

Hi,

I have the same issue. One project I cannot delete or check-in. I've
cancelled all jobs. No success. What to do?

Thanks
Paul

--
Paul Goldman

No, it is not supported to delete projects directly from the DB. Why
won't it work from PWA? That's what I would spend time on, not in finding
the magic SQL query. If you post any errors your getting while deleting
projects, someone can help you better.

Specifically, there should be errors in your Queue. On the Manage Queue
page you can filter by project so it makes it easier to see the history of
that project. You will probably also want to increase the Job History
window, as it defaults to the current day only. If you find a job in the
Failed and Blocking state for that project, that is the problem. If this
is the case, select the job that is in this state, hit the Cancel Job
button, then try to delete the project again. Once the Queue processes
the delete jobs, it should be gone.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

I can't delete poject(s) (project server 2007) using web interface. Is it
possible delete projects from MS SQL 2005 DB directly using SQL query ?
I found procedure [MSP_DELETE_PROJECTS]. Can I use this procedure?

 

[Dima]

I hope I found solution

use PWA_Published_XXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'
use PWA_Draft_XXXXXXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'
use PWA_Archive_XXXXXXXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'

Please tell me is this way correct ?

Hi,

I have the same issue. One project I cannot delete or check-in. I've
cancelled all jobs. No success. What to do?

Thanks
Paul

--
Paul Goldman

No, it is not supported to delete projects directly from the DB. Why
won't it work from PWA? That's what I would spend time on, not in finding
the magic SQL query. If you post any errors your getting while deleting
projects, someone can help you better.

Specifically, there should be errors in your Queue. On the Manage Queue
page you can filter by project so it makes it easier to see the history of
that project. You will probably also want to increase the Job History
window, as it defaults to the current day only. If you find a job in the
Failed and Blocking state for that project, that is the problem. If this
is the case, select the job that is in this state, hit the Cancel Job
button, then try to delete the project again. Once the Queue processes
the delete jobs, it should be gone.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

I can't delete poject(s) (project server 2007) using web interface. Is it
possible delete projects from MS SQL 2005 DB directly using SQL query ?
I found procedure [MSP_DELETE_PROJECTS]. Can I use this procedure?

 

[Sharry Heberer [MSFT]]

I think you all are missing a crucial concept here. It is more than likely
that for the project you are trying to delete, there is a job in the Queue
which is blocking the deletion. Addressing that issue will allow the
project to be *properly* deleted. I think your time is probably better
spent understanding how the Queue works, since direct DB access probably
won't get you very far in troubleshooting other problems. Project Server
2007 is very different from 2003, and direct DB access is very dangerous and
you could easily corrupt your data and get yourself into an unsupported
state. If anyone needs help determining what to look for in the Queue,
please post back and I'll be happy to help. But obviously I can only help
if the stored procedures below have not been run. Two points here:

First, direct DB access like this would get you into an supported state if
you needed to call MS for support at some point.
Second, there are 4 DBs in Project Server, and the deletion will only be
complete from all DBs if the deletion is properly processed through the
Queue. Even if you run the stored procedures below on those 3 DBs, you have
not addressed the data in the Reporting DB. This project will still show up
on reports.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

I hope I found solution

use PWA_Published_XXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'
use PWA_Draft_XXXXXXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'
use PWA_Archive_XXXXXXXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'

Please tell me is this way correct ?

Hi,

I have the same issue. One project I cannot delete or check-in. I've
cancelled all jobs. No success. What to do?

Thanks
Paul

--
Paul Goldman

No, it is not supported to delete projects directly from the DB. Why
won't it work from PWA? That's what I would spend time on, not in
finding
the magic SQL query. If you post any errors your getting while
deleting
projects, someone can help you better.

Specifically, there should be errors in your Queue. On the Manage
Queue
page you can filter by project so it makes it easier to see the history
of
that project. You will probably also want to increase the Job History
window, as it defaults to the current day only. If you find a job in
the
Failed and Blocking state for that project, that is the problem. If
this
is the case, select the job that is in this state, hit the Cancel Job
button, then try to delete the project again. Once the Queue processes
the delete jobs, it should be gone.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

I can't delete poject(s) (project server 2007) using web interface. Is
it
possible delete projects from MS SQL 2005 DB directly using SQL query
?
I found procedure [MSP_DELETE_PROJECTS]. Can I use this procedure?

 

[Girish]

Sharry,
I have the same issue. Project server 2007 is not letting me delete a
project and it says the project is checked out. When I try to force checkin
the task appears in the quese and is not being processed. I am able to cancel
this task from the queue but readding it also is not being processed.
What am I doing wrong?

Thanks

I think you all are missing a crucial concept here. It is more than likely
that for the project you are trying to delete, there is a job in the Queue
which is blocking the deletion. Addressing that issue will allow the
project to be *properly* deleted. I think your time is probably better
spent understanding how the Queue works, since direct DB access probably
won't get you very far in troubleshooting other problems. Project Server
2007 is very different from 2003, and direct DB access is very dangerous and
you could easily corrupt your data and get yourself into an unsupported
state. If anyone needs help determining what to look for in the Queue,
please post back and I'll be happy to help. But obviously I can only help
if the stored procedures below have not been run. Two points here:

First, direct DB access like this would get you into an supported state if
you needed to call MS for support at some point.
Second, there are 4 DBs in Project Server, and the deletion will only be
complete from all DBs if the deletion is properly processed through the
Queue. Even if you run the stored procedures below on those 3 DBs, you have
not addressed the data in the Reporting DB. This project will still show up
on reports.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

I hope I found solution

use PWA_Published_XXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'
use PWA_Draft_XXXXXXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'
use PWA_Archive_XXXXXXXXXXXXXXX
exec PWA_Published_XXXXXXXXXX.[dbo].[MSP_PUBLISHED_PROJECT_DELETE]
@projUID='<projUID>'

Please tell me is this way correct ?

Hi,

I have the same issue. One project I cannot delete or check-in. I've
cancelled all jobs. No success. What to do?

Thanks
Paul

--
Paul Goldman
No, it is not supported to delete projects directly from the DB. Why
won't it work from PWA? That's what I would spend time on, not in
finding
the magic SQL query. If you post any errors your getting while
deleting
projects, someone can help you better.

Specifically, there should be errors in your Queue. On the Manage
Queue
page you can filter by project so it makes it easier to see the history
of
that project. You will probably also want to increase the Job History
window, as it defaults to the current day only. If you find a job in
the
Failed and Blocking state for that project, that is the problem. If
this
is the case, select the job that is in this state, hit the Cancel Job
button, then try to delete the project again. Once the Queue processes
the delete jobs, it should be gone.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

I can't delete poject(s) (project server 2007) using web interface. Is
it
possible delete projects from MS SQL 2005 DB directly using SQL query
?
I found procedure [MSP_DELETE_PROJECTS]. Can I use this procedure?