RE: PS03 error 0x80040E14 - Repairing the problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rita Nikas [MSFT] (ritan_at_online.microsoft.com)
Date: 05/07/04 

Date: Fri, 07 May 2004 15:51:54 GMT

Hi Mike.

I apologize that we were unable to respond sooner (I was out of the country
until very recently).

I know that we've seen a few situations of either the 0x80040E14 or
0x80004005 spooler error message with Project Server 2003 when the manager
accepts updates on the Updates page in Microsoft Project Web Access.
Essentially, you can't update the assignment and in PWA, you'll notice that
some updates aren't processed.

What causes this? Resources using the option to Assign yourself to an
existing task and the resources are already assigned. In case you're
curious, I have steps (at the end of this message) to reproduce this
problem.

To resolve this issue, there are specific client and server updates that
need to be obtained. This addresses resolving the spooler error message in
*new* projects. But, existing projects still receive the spooler errors
until you accept all updates and do a few other things. At the point of
accepting all updates, updates are applied to the tasks in Microsoft
Project but will not be removed from the Updates page. You'll need to save
the existing projects as mpp files, delete the projects via Clean up
Microsoft Project Server database and then import the mpp file via Import
Projects to Enterprise. After the projects are imported select Republish
Assignments and select the option to Overwrite actual work entered by the
resources from the Collaborate\Publish menu.

Now, to get ahold of the appropriate client and server updates, you'll need
to contact Microsoft Product Support Services and work with a support
professional (these updates aren't downloadable by the generic population
at this time). You can review your different support options at this page:

http://support.microsoft.com/default.aspx?pr=cntactms&style=home

Sincerely,

Rita Nikas
Microsoft MVP Lead
Microsoft Corporation
 
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Subject: PS03 error 0x80040E14 - Repairing the problem
| 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
|

Relevant Pages

  • RE: PS03 error 0x80040E14 - Repairing the problem
    ... > Microsoft Corporation ... > | accepts updates on the Updates page in Microsoft Project Web Access. ... > | existing task and the resources are already assigned. ... > | The event log has set of five errors for each assignment that you attempt ...
    (microsoft.public.project.pro_and_server)
  • RE: PS03 error 0x80040E14 - Repairing the problem
    ... For anyone who is experiencing the spooler error message, ... Microsoft MVP Lead ... | accepts updates on the Updates page in Microsoft Project Web Access. ... | The event log has set of five errors for each assignment that you attempt ...
    (microsoft.public.project.pro_and_server)
  • Re: device drivers
    ... > does any one know how i can find out what drivers are in my system, ... Microsoft has these suggestions for Protecting your computer from the ... I'll mainly work around Windows XP, as that is what the bulk of this ... How to configure and use Automatic Updates in Windows XP ...
    (microsoft.public.windowsxp.general)
  • Re: Intermittant GPO failure to apply
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... any updates in your thread. ... | SetNtUserPolTime, ...
    (microsoft.public.windows.server.sbs)
  • Re: Computer skills
    ... > I spent several 100 bucks on buying programs from Microsoft, ... > I can't get any updates, to fix the issues which you did not manage ... only normal computer maintenance skills - ... What to Know Before You Download and Install Windows XP Service Pack 2 ...
    (microsoft.public.windowsupdate)