PS03 error 0x80040E14 - Repairing the problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: ITG_Mike (anonymous_at_discussions.microsoft.com)
Date: 05/04/04 

Date: Tue, 4 May 2004 11:41:02 -0700

I have seen a number of reports of the 0x80040E14 spooler error. In fact, I have posted descriptions the circumstances where duplicate assignments occur in PS03 --causing this error to occur.

However, I now have a project that does not appear to have duplicate assignments, but the 0x80040E14 is generated whenever you try to publish the project. Even after adding a new resource, assigning that resource to a new task, and publishing just that one task I get this spooler error.

So I now have a project that cannot be published without an error. Since you can't publish, you also can't add new resources, tasks, or assignments. The Project Spooler gives no indication on the problem that is causing the problem or what one should do to address the error.

Has anyone ever gotten a reply from Microsoft on what to do when this happens? What caused this error? Has anyone ever recovered from this codition?

The event log has set of five errors for each assignment that you attempt to publish. So if I republish a task with three resources, I will get 15 errors in the log (five for each assignment).

Within these five errors, the first, and most interesting is:
- - - - - -
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/30/2004
Time: 7:22:10 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: EPROJ
Description:
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 438
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Attempted to insert duplicate PROJ_ID (615), PROJ_TIMESTAMP (D4070400010013000B001C0011000000), IN MSP_WEB_PROJECTS]]></Description>
- - - - -

I have checked the MSP_WEB_PROJECTS table and there is a single record with the identified PROJ_ID (615). This record contains the information for the project I am trying to publish.

It appears that the spooler is trying to insert a new record for this PROJ_ID, rather then updating the record that is present. Any idea on why this is or how to fix it?

Just for completeness, there are fouradditional errors for each assignment published:

#1 - - - - - -
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/30/2004
Time: 7:22:10 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: EPROJ
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 1335
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description>

- - - - - -

#2 - - - - -
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/30/2004
Time: 7:22:10 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: EPROJ
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2307
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description>
- - - - -

#3- - - - -
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/30/2004
Time: 7:22:10 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: EPROJ
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 1099
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description>
- - - - -

#4- - - - -
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/30/2004
Time: 7:22:10 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: EPROJ
Description:
Component: PjMsgHlr
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 587
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description>
- - - - -

As mentioned above, I think the first error that mentions the duplicate record is the interesting one...

Mike

Quantcast