Couldn't find Assignment

[BTOjohn]

Me again!

I'm going to try to keep this short, but essentially a new resource added
himself to a few projects. Before updating, one of the PMs added him to the
same project, and then updated, so he was then added twice to the tasks.
After reaslising it was a complete mess, because somehow he was also added to
a summary task, I removed him from absolutely every task, and from every
project resource pool and then deleted his account using PSCleaner on the
server. I then recreated a brand spanking new account, and proceeded to add
him to the projects again. Successfully bar one project, which absolutely
will not publish when I add him to a task. The Spooler flashes me, and will
not accept any action other than undo with a message about New & Changed
assignments and the 0x80004005 code. The event log contains a series of three
warnings followed by five errors, copied below. Just when I thought I had
things under control, my event log is now a great big red and yellow
disaster. Many thanks in advance for any assistance offered.

Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4493
Description: <Description><![CDATA[Couldn't find assignment!]]></Description>


Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4494
Description: <Description><![CDATA[dwDBAssnUID should be -1 at this
point!]]></Description>


Event Type: Warning
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 1
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4703
Description: <Description><![CDATA[VERIFYPTR(NULL)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4703
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4849
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2386
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 1100
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 02/02/2006
Time: 17:04:31
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 588
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

 

[BTOjohn]

In case anyone else has this issue, I tried a binary rebuild (see
http://www.projectserverexperts.com/Shared Documents/BinaryRebuild.htm ) to
get rid of any potential corruption, and that did not work this time round. I
then tried a method suggested by Dale Howard MVP as follows:

1. Save the corrupted file as an .xml file and close the file
2. Ask your Project Server administrator to delete the project from the
Project Server database
3. Open the .xml project file
4. Click File - Save As and save the file as an .mpp file
5. Import the .mpp file into the Project Server database using Tools -
Enterprise Options - Import Project to Enterprise

It worked a dream...

 

[Dale Howard [MVP]]

BTOJohn --

Thanks for the kind compliment!

 

[Gary L. Chefetz [MVP]]

John:

Doing the binary rebuild after the XML conversion is particularly useful as
the XML conversion routine significantly inflates the file. The binary
rebuild removes the bloat.