Cannot Publish Projects

[PackAddict]

For some reason, I cannot publish projects to my Project Server anymore. It
was working before I installed the latest Project Server service pack. My
SQL Server is SQL Server 2000 SP 3a. My Project Server is MSPS 2003 and all
service packs have been installed.

Following are the error messages that I pulled from my event log:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp
Line: 105
Error Number: 0x800a0e78
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Recordset
Description: <Description><![CDATA[Operation is not allowed when the object
is closed.]]></Description>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 117
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Fields
Description: <Description><![CDATA[Item cannot be found in the collection
corresponding to the requested name or ordinal.]]></Description>

 

[PackAddict]

I opened an MSDN problem report and found out that I didn't completely follow
the instructions when applying the last service pack. I failed to upgrade my
project server database using the upgdb111.cmd utility.

 

[Technomage]

I have the same problem, I have tried to locate the upgdb111.cmd utility but
cant find it.

Anybody know where it's located?

I opened an MSDN problem report and found out that I didn't completely follow
the instructions when applying the last service pack. I failed to upgrade my
project server database using the upgdb111.cmd utility.

For some reason, I cannot publish projects to my Project Server anymore. It
was working before I installed the latest Project Server service pack. My
SQL Server is SQL Server 2000 SP 3a. My Project Server is MSPS 2003 and all
service packs have been installed.

Following are the error messages that I pulled from my event log:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp
Line: 105
Error Number: 0x800a0e78
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Recordset
Description: <Description><![CDATA[Operation is not allowed when the object
is closed.]]></Description>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 117
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Fields
Description: <Description><![CDATA[Item cannot be found in the collection
corresponding to the requested name or ordinal.]]></Description>

 

[Technomage]

Problem sorted thanks.

I have the same problem, I have tried to locate the upgdb111.cmd utility but
cant find it.

Anybody know where it's located?

I opened an MSDN problem report and found out that I didn't completely follow
the instructions when applying the last service pack. I failed to upgrade my
project server database using the upgdb111.cmd utility.

For some reason, I cannot publish projects to my Project Server anymore. It
was working before I installed the latest Project Server service pack. My
SQL Server is SQL Server 2000 SP 3a. My Project Server is MSPS 2003 and all
service packs have been installed.

Following are the error messages that I pulled from my event log:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp
Line: 105
Error Number: 0x800a0e78
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Recordset
Description: <Description><![CDATA[Operation is not allowed when the object
is closed.]]></Description>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 117
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Fields
Description: <Description><![CDATA[Item cannot be found in the collection
corresponding to the requested name or ordinal.]]></Description>

 

[Steve]

Did you ever fix this problem? I am having it now.

BTW, the cmd file is in PROJECTSERVER2003-KB837241-SQLFILE-ENU.EXE, in the
SP1 update for SQL Server.

Problem sorted thanks.

I have the same problem, I have tried to locate the upgdb111.cmd utility but
cant find it.

Anybody know where it's located?

I opened an MSDN problem report and found out that I didn't completely follow
the instructions when applying the last service pack. I failed to upgrade my
project server database using the upgdb111.cmd utility.

:

For some reason, I cannot publish projects to my Project Server anymore. It
was working before I installed the latest Project Server service pack. My
SQL Server is SQL Server 2000 SP 3a. My Project Server is MSPS 2003 and all
service packs have been installed.

Following are the error messages that I pulled from my event log:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\utility\pjrecordsetutil.cpp
Line: 105
Error Number: 0x800a0e78
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Recordset
Description: <Description><![CDATA[Operation is not allowed when the object
is closed.]]></Description>



Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 3/21/2005
Time: 12:07:21 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PROJECT-SERVER
Description:
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 117
Error Number: 0x800a0cc1
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: ADODB.Fields
Description: <Description><![CDATA[Item cannot be found in the collection
corresponding to the requested name or ordinal.]]></Description>