deleted projects show on project center list

Question

Hi all,

We are having a few issues which seem to be related.  I hope one of you masters can help me out.

- First, we have a user that has tried to delete a project through PWA.  however when she did this, she receiced errors.  The project does not exist as far as we can tell but it still exists on the "Project Center".  When you click on the deleted project you get an error (I get this as an administrator as well).  The project is no longer available to delete.

-  Resources that were assigned to this deleted project are still showing as allocated to it.

- When clicking the bulk edit button we also receiece a similar error pop up in PWA.

Below are some log entries that I hope can help:

Buld Edit errors - I checked permissions on the folders and they all look good.

02/15/2011 10:39:45.17  w3wp.exe (0x3134)                        0x13CC SharePoint Foundation          General                        b9y3 High     Failed to open the file 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Resources\BulkEditTool.en-US.resx'. e1941c2e-e8b4-4e12-be23-27d96d4f601e
02/15/2011 10:39:45.17  w3wp.exe (0x3134)                        0x13CC SharePoint Foundation          General                        b9y4 High     #20015: Cannot open "": no such file or folder. e1941c2e-e8b4-4e12-be23-27d96d4f601e
02/15/2011 10:39:45.17  w3wp.exe (0x3134)                        0x13CC SharePoint Foundation          General                        b9y4 High     (#2: Cannot open "": no such file or folder.) e1941c2e-e8b4-4e12-be23-27d96d4f601e

I also see this error on the event log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{61738644-F196-11D0-9953-00C04FD919C1}

and APPID

{61738644-F196-11D0-9953-00C04FD919C1}

to the user PHASE2\wsspooluser SID (S-1-5-21-2716186352-2771925758-2286958482-7458) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

 

If anyone can help it would be greatly appreciated!

Mike

Answer 1

Hello Mike,

This is pretty serious and wouldn't want to get a fix thru forums.  You aren't going to get enough detail and support.  I would open a call for support with Microsoft.  

Cheers!

---

Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
www.WhartonComputer.com

Answer 2

Mike: I need you to go to the delete Enterprise Objects page and let me know if you see this project with the option to delete from both draft and published, and then see if things change if you select published database only.

---

Gary Chefetz, MCITP, MCP, MVP msProjectExperts
Project and Project ServerFAQs
Project Server Help BLOG

Answer 3

Hi there,

Thanks for your response!  The database does apear if you change to Published only.  If I try to delete it using an administrator account I get the following error:

<error id="23006" name="ProjectDeleteFailure" uid="80d8eb07-31c2-4327-bc77-249db354558a" projectuid="a67d6ef0-3634-41e4-a6dc-5bca6c5cff28" messagetype="Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.AdjustTimeSheetForDeletedProjectMessage" messageID="6" stage="" blocking="Undefined" />
    </class>
    <class name="Queue">
      <error id="26000" name="GeneralQueueJobFailed" uid="0fce5328-b82a-4b7a-8b5f-3cf5fadd5604" JobUID="e8721905-da83-4a61-98f3-5abe6c2eaedd" ComputerName="PROJ-HNL-2010" GroupType="ProjectDelete" MessageType="AdjustTimeSheetForDeletedProjectMessage" MessageId="6" Stage="" />

Mike

Answer 4

Mike: This is the result of a little bug we expect a fix for shortly. In the mean time, you need to find the culprit timesheet and delete it. It will be from someone associated with the project who has had an adjusted timesheet and has the permission to adjust timesheets..

---

Gary Chefetz, MCITP, MCP, MVP msProjectExperts
Project and Project ServerFAQs
Project Server Help BLOG

Answer 5

  Mike, 

   I think, that this workaround can help you to resolve issue with your projects. We got this solution via premier support and he helped us. But i recommend test it before used.

   So, you need to execute query on your Published database for every projects with this problem:

 

use <ProjectServerPublishedDatabase>
delete MSP_TIMESHEET_ACTIONS
where TS_LINE_UID in (select TS_LINE_UID from MSP_TIMESHEET_LINES
where PROJ_UID in ('Project UID that is provided in the error message under projectuid’) and TS_ACTION_ENUM = 1)

 

In your case from your message Project UID is a67d6ef0-3634-41e4-a6dc-5bca6c5cff28.

Hope you can test, create backup database before execute and after that execute this script and resolve this issue.

 

---

Alexey