"0x80040e14" 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 (889500)


The information in this article 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 Number is the PROJ_ID number, and xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 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: Drive:\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 OLEDB Provider for SQL Server
Description: <Description><![DDATA[Attempted to insert duplicate </Description>
PROJ_ID (Number) PROJ_TIMESTAMP
(xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx), 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:
  1. In the Application log, locate the event ID error message that is mentioned in the "Symptoms" section, and then do the following:
    1. Identify the number that is displayed in the PROJ_ID (Number) entry. For example, if the PROJ_ID (Number) entry in the event ID error message is PROJ_ID (5), the PROJ_ID number is 5.
    2. Copy the hexadecimal value of the timestamp to a Notepad document. An example of a hexadecimal value of a timestamp is D407070004000F000B00080016000000.
  2. 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:
    1. Start SQL Server Enterprise Manager.
    2. Expand Microsoft SQL Servers, expand the server group, and then expand the appropriate server.
    3. Expand Databases, expand the ProjectServer database, and then click Tables.
    4. In the right pane, right-click MSP_PROJECTS, point to Open Table, and then click Return all rows.
    5. 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.
    6. Close the Data in Table 'MSP_PROJECTS' in 'ProjectServer' on 'Server' window.
    7. In the right pane, right-click MSP_WEB_PROJECTS, point to Open Table, and then click Return all rows.
    8. In the PROJ_NAME column, locate the project name that matches the project name that you identified in step 2e.
    9. 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.
    10. Close the Data in Table 'MSP_WEB_PROJECTS' in 'ProjectServer' on 'Server' window, and then quit SQL Server Enterprise Manager.

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

Modification Type:MinorLast Reviewed:8/29/2006
Keywords:kbnewfile kbprb kberrmsg kbtshoot KB889500 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.