#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing Port on Project Server PWA | danny_boy328 | Project | 0 | 09-25-2007 08:27 AM |
Error 9571 when opening Project Server from Project Pro | mona | Project | 0 | 04-24-2007 07:50 AM |
Notification Mail In project server - Plz help urgent | myanilkumar | Project | 0 | 01-19-2006 05:44 AM |
Project Server 2003 - un-checkout enterprise resource | SteveGold | Office | 3 | 11-28-2005 06:35 PM |
Outlook 2003 on Terminal server | Larry Stover | Outlook | 0 | 11-15-2005 09:38 AM |