Thread: [Solved] Project Server 2003 SP2
View Single Post
 
Old 09-28-2005, 11:28 PM
Guest
 
Posts: n/a
Default Project Server 2003 SP2

Hi There,

we decided to be one of the early adopters, and as such i upgraded our
EPM
system to SP2 level last-night. the problem is that now we are getting

errors on any views in the Resource Centre that contain a filter based
on the
Resource Type Field. The error states:

"An error ocurred while trying to access the resources stored in the
database. Either there are too many resources, or the Project Server
may not
have the correct DSN configuration. Contact the Server Administrator."

In the eventlog the only errors that seem to be related here is:

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 2005/09/28
Time: 11:04:56 PM
User: NT AUTHORITY\LOCAL SERVICE
Computer: EPMSERVER
Description:
File: C:\Office\devsp\project\WebClient\source\utility\p jadorsutil2.cpp
Line: 317
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Invalid column name
'ResourceType'.]]></Description>



The error seems to indicate that the column does not exist, but as far
as i
can see (with some investigation using SQL Profiler and Query analyzer)
the
column does indeed show up in the table MSP_VIEW_RES_STD table.

I have tried the upgrade on a different system, with a backup of our DB
and
the same error still occurs.

What may be the problem here?

Thanks!

--
www.fulcrumgroup.co.za
Reply With Quote