Article ID: 903093
Article Last Modified on 11/2/2005
APPLIES TO
- Microsoft Office Project Server 2003
- Microsoft Project Server 2002
SYMPTOMS
You may experience the following issues when you work with Microsoft Office Project Server 2003 or with Microsoft Project Server 2002:
- When you publish a Microsoft Project plan to a computer that is running Project Server 2003, you receive the following error message:
Additionally, the following error may be logged in the error log:
Component: ADODB.Recordset
Description: <Description><CDATA>Item cannot be found in the collection corresponding to the requested name or ordinal.</CDATA></Description> - When you click Manage Users and Groups on the Admin page in Microsoft Project Web Access, you receive the following Visual Basic Editor script error message:
- When you publish a new assignment or a changed assignment, you receive the following error message:
Additionally, the following error may be logged in the event log:
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 588
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also included.]></Description>
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2386
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also included.]></Description>
Component: PjMsgHlr File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4828
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also included.]></Description>
Component: PjMsgHlr File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 4682
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also included.]></Description> - When you click Save to save the changes that you made to the Manage Security category on the Admin page in Project Server, you receive the following error message:
- When you try to see the tasks in a published project plan in Project Web Access, you receive an error message that is similar to the following:
CAUSE
The issues that are described in the "Symptoms" section may occur if the following conditions are true:
- You installed a hotfix or a service pack for Project Server 2003 or for Project Server 2002.
- You did not run the scripts that are included with the hotfix or with the service pack that you installed.
RESOLUTION
To resolve these issues, run the upgrade database .cmd script file that is included with the service pack or with the hotfix that you installed.
Note If the database is a partitioned database, run the script against each Project Server database.
To run the upgrade database .cmd script file from a command line, follow these steps:
- Click Start, click Run, type cmd in the Open box, and then click OK.
- At the command prompt, type cd
folder
.
Note In this command,folder
is the folder to which you extracted the service pack or the hotfix package. - At the command prompt, type the following command:
filename
.cmdsql_server_name
database_name
logon
password
Or, if you logged on by using a user account that uses Windows authentication to connect to Microsoft SQL Server, type the following command at the command prompt:
filename
.cmdsql_server_name
database_name
Notes
- In these commands,
filename
is the name of the upgrade database .cmd script file. For example, type upgdb111.cmd. - If you do not include the system administrator account logon name and the password, the command file assumes Windows authentication is used to connect to SQL Server. If you supply only the SQL server name, the command files assumes that the database name is "ProjectServer".
- In these commands,
Additional query words: projectserver2003 projectserver2k3 projectserver2002 projectserver2k2 prjsvr2003 prjsvr2k3 prjsvr2002 prjsvr2k2
Keywords: kbtshoot kbsetup kbprb KB903093