PS2003 - upgrade SQL2000 to SQL2005 - PWA Task tab not working

[Wharton Computer Consulting]

I am running Project Server 2003 and recently upgraded SQL Server 2000 to SQL
server 2005.

All the PWA menu tabs are working except for TASK tab. When I click on the
"TASKS" tab, the Task page flashes to the page and then returns to the home
page. Sometimes I can see a control that isn't getting rendered before it
returns to the home page.

Project professional can add and modify projects on the server and all the
functionality seems to be working.

Event:

Event ID 2
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1073
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>


Component: PjQuery
File: C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>

Component: PjBusObj
File:
C:\Office\devsp\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 5385
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

 

[Wharton Computer Consulting]

Problem fixed, but did not figure out why.

I fixed by detaching database, and copying over the old SQL 2000
ProjectServer database back to the new SQL 2005. and reattaching. It is
working.