Microsoft KB Archive/889500

= &quot;0x80040e14&quot; error message is displayed in the Microsoft Office Project Server Spooler dialog box and is logged in the Application log when you publish a project to Project Server 2003 =

Article ID: 889500

Article Last Modified on 1/5/2007

-

APPLIES TO


 * Microsoft Office Project Professional 2003
 * Microsoft Office Project Server 2003
 * Microsoft Project Server 2002

-





SYMPTOMS
You connect to Microsoft Office Project Server 2003 by using Microsoft Office Project Professional 2003, open a project, and then make changes to the project. When you republish the project to Project Server 2003, a flashing red exclamation point appears next to the Microsoft Office Project Server Spooler icon in the notification area, at the far right of the taskbar. When you double-click the icon, an error message that is similar to the following is displayed in the Error column of the Microsoft Office Project Server Spooler dialog box:

DATABASE ERROR (0x80040E14)

Additionally, an event error message that is similar to the following is logged in the Application log, where  is the PROJ_ID number, and   is a hexadecimal value of the timestamp:

Type: Error

Source: Microsoft Project Server

Category: None

Event ID: 2

User: NT AUTHORITY\LOCAL SERVICE

Description:

File: :\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp

Line: 438

Error Number: 0x80040e14

Description: <![CDATA[Assert Detected. The error code was also included.]]>

__________________________________________________

Component: Microsoft OLEDB Provider for SQL Server

Description: <![DDATA[Attempted to insert duplicate 

PROJ_ID PROJ_TIMESTAMP

, IN

MSP_WEB_PROJECTS)]>



CAUSE
This issue may occur if the hexadecimal value of the timestamp in the MSP_WEB_PROJECTS table in the database that is used by Project Server 2003 is incorrect for a particular project. Timestamp values are stored in the PROJ_TIMESTAMP column.



RESOLUTION
To resolve this issue, copy the hexadecimal value that is displayed in the event ID error message to the PROJ_TIMESTAMP column of the MSP_WEB_PROJECTS table for the project that has the incorrect timestamp value. To do this, follow these steps:  In the Application log, locate the event ID error message that is mentioned in the &quot;Symptoms&quot; section, and then do the following:  Identify the number that is displayed in the PROJ_ID entry. For example, if the PROJ_ID entry in the event ID error message is PROJ_ID (5), the PROJ_ID number is 5. Copy the hexadecimal value of the timestamp to a Notepad document. An example of a hexadecimal value of a timestamp is D407070004000F000B00080016000000. </li> Paste the hexadecimal value that is displayed in the event ID error message to the PROJ_TIMESTAMP column of the MSP_WEB_PROJECTS table for the project that has the incorrect timestamp value. To do this, follow these steps:  Start SQL Server Enterprise Manager.</li> Expand Microsoft SQL Servers, expand the server group, and then expand the appropriate server.</li> Expand Databases, expand the ProjectServer database, and then click Tables.</li> In the right pane, right-click MSP_PROJECTS, point to Open Table, and then click Return all rows.</li> In the PROJ_ID column, locate the entry that matches the PROJ_ID number that you identified in the event ID error message in the Application log. Make a note of the corresponding project name that is displayed in the PROJ_NAME column.</li> Close the Data in Table 'MSP_PROJECTS' in 'ProjectServer' on ' ' window.</li> In the right pane, right-click MSP_WEB_PROJECTS, point to Open Table, and then click Return all rows.</li> In the PROJ_NAME column, locate the project name that matches the project name that you identified in step 2e.</li> Paste the hexadecimal value that you copied from the event ID error message to the PROJ_TIMESTAMP column for the project name that you identified in step 2e.</li> Close the Data in Table 'MSP_WEB_PROJECTS' in 'ProjectServer' on ' ' window, and then quit SQL Server Enterprise Manager.</li></ol> </li></ol>

<div class="moreinformation_section">

MORE INFORMATION
For more information about how to configure and administer Project Server 2003, see the Project Server 2003 Administrator's Guide. To obtain the Project Server 2003 Administrator's Guide, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=2f446940-147b-447a-b0d3-6088673a53a4&amp;DisplayLang=en

Additional query words: prj2003

Keywords: kbprb kberrmsg kbtshoot KB889500

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.