Spooler Error 0x80040E14 - Fixing

[ITG_Mike]

All

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

Mike

 

[Gary L. Chefetz \(MVP\)]

Mike:

Corrsponding Event log errors?

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-

All,

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?

 

[ITG_Mike]

Gary, et al

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: Erro
Event Source: Microsoft Project Server Tracing Eventlog Provide
Event Category: Non
Event ID:
Date: 4/30/200
Time: 7:22:10 A
User: NT AUTHORITY\LOCAL SERVIC
Computer: EPRO
Description
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cp
Line: 43
Error Number: 0x80040e1
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description
__________________________________

Component: Microsoft OLE DB Provider for SQL Serve
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: Erro
Event Source: Microsoft Project Server Tracing Eventlog Provide
Event Category: Non
Event ID:
Date: 4/30/200
Time: 7:22:10 A
User: NT AUTHORITY\LOCAL SERVIC
Computer: EPRO
Description
Component: PjMsgHl
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cp
Line: 133
Error Number: 0x80040e1
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description

- - - - -

#2 - - - -
Event Type: Erro
Event Source: Microsoft Project Server Tracing Eventlog Provide
Event Category: Non
Event ID:
Date: 4/30/200
Time: 7:22:10 A
User: NT AUTHORITY\LOCAL SERVIC
Computer: EPRO
Description
Component: PjMsgHl
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\updatedb.cp
Line: 230
Error Number: 0x80040e1
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description
- - - -

#3- - - -
Event Type: Erro
Event Source: Microsoft Project Server Tracing Eventlog Provide
Event Category: Non
Event ID:
Date: 4/30/200
Time: 7:22:10 A
User: NT AUTHORITY\LOCAL SERVIC
Computer: EPRO
Description
Component: PjMsgHl
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\MsgHandler.cp
Line: 109
Error Number: 0x80040e1
Description: <Description><![CDATA[Assert Detected. The error code was also included.]]></Description
- - - -

#4- - - -
Event Type: Erro
Event Source: Microsoft Project Server Tracing Eventlog Provide
Event Category: Non
Event ID:
Date: 4/30/200
Time: 7:22:10 A
User: NT AUTHORITY\LOCAL SERVIC
Computer: EPRO
Description
Component: PjMsgHl
File: C:\Office\dev\project\WebClient\source\server\pjmsghlr\MsgHandler.cp
Line: 58
Error Number: 0x80040e1
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

 

[Barbara]

We're experiencing the same error. If anyone sent you a
resolution could you forward it on?

-----Original Message-----
All,

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?

 

[ITG_Mike]

Barbara, et al

No replies from anyone on how to fix this problem. I posted a new message today with all of the details (spooler message, error log, etc.) Maybe I will get a reply this time

Mike