project server 2007 - project checkin failed at 37%

hi Experts,
i have a problem with a project, since a week i'm no longer able to complete the check-in/publishing. the project seems to be corrupted.

- Updates from resources fails in to be applied
- cannot open the project with the MS Project client

any idea how to solve this problem?

Project server 2007
Project professional 2007 sp2


error:

Your ProjectCheckIn job failed. Its current state is Failed. It was 37% complete. It entered the queue at 04/02/2012 11:27:02.
To get more information about the job failure, please go to Project Web Access. Select Personal Settings from the left menu. Then select My Queued Jobs.
The errors returned from the queue are as follows:
Error ID: 3116
Error ID: 23008
Error ID: 26000
Detailed error below - send it to the administrator for more detailed troubleshooting.
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Status approval internal error">
<error id="3116" name="StatusingInternalError" uid="e2b41bd4-56bf-438e-bbb5-abd841bc9b5f" />
</class>
<class name="Object reference not set to an instance of an object.">
<error id="23008" name="ProjectCheckinFailure" uid="9a30cb2d-4829-4fba-9dec-5b2078056629" ProjectUID="1c897387-e4fd-44b3-b7f6-daa19c46c002" JobUID="5f23f78d-1abf-4ccc-8b7b-26f9291b8c06" MessageID="4" Error="System.NullReferenceException: Object reference not set to an instance of an object.&#xD;&#xA; at Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.ProcessingComplete(StatusApprovalApplyResult result, StatusApprovalMessageHandlerResult status)&#xD;&#xA; at Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage message, StatusTransactionState expectedState, Boolean keepSchedulingResults, StatusApprovalApplyResult&amp; result)&#xD;&#xA; at Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage message)&#xD;&#xA; at Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.ApplyInProcessStatusApprovalsForProject(Guid projectID)&#xD;&#xA; at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessProjectCheckinMessage.ProcessProjectCheckinApplyStatusUpdatesMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)&#xD;&#xA; at Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessProjectCheckinMessage.ProcessMessageCallback(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="a150a56d-1dd3-4a61-90c6-57139e966a2c" JobUID="5f23f78d-1abf-4ccc-8b7b-26f9291b8c06" ComputerName="SERVER" GroupType="ProjectCheckIn" MessageType="ProjectCheckinApplyStatusUpdatesMessage" MessageId="4" Stage="" />
</class>
</general>
</errinfo>
LVL 1
ITDataCenterAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

g000seCommented:
Hi,

Can you revert back to a good system restore on the box that is housing the Project server?  If that doesn't work, you may need to reinstall the project server.
0
ITDataCenterAuthor Commented:
hi, this is a in-house project server, with over 1500 active projects and 50 project managers
the PWA has more or less the same numbers or sites per project.

this is the only project with this issue, i would totally exclude the reinstallation or restore. thanks.
0
ITDataCenterAuthor Commented:
problem solved deleting project queue tasks.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ITDataCenterAuthor Commented:
that solved the problem.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Project Management

From novice to tech pro — start learning today.