Error on resources view after SP2a

[jakub]

Hi all,
I just have installed SP2a and I got an error on resources view:

An error occurred while trying to access the resources stored on the
database. Either there are too many resources, or the Microsoft Project
Server may not have the correct DSN configuration. Contact the server
administrator.

I have checked event log and I have discovered the following:

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>

___________________________________

Component: Microsoft OLE DB Provider for SQL Server

Description: <Description><![CDATA[Invalid column name
'ResourceEnterpriseGeneric'.]]></Description>



According to Microsoft Office Project Server 2003 Data Reference such column
should be in MSP_VIEW_RES_ENT.

But after service pack 2a it seems that no more.

So as Administrator I went to admin/manage views and I have changed filter.

I have removed expression "Generic equals false".

Now view works except I see Virutal Employee on the list. I see dead people


Questions:

1 - is there any workaround for that to see generic resources only?

2 - is that a bug that this field vanished after sp2a?

Regards,

Jakub Dudek (MCSD)

 

[Gary L. Chefetz [MVP]]

Jakub:

After the service pack, you must go back to Manage Views and explicitly add
that field to the view in order to make the filter work correctly.

 

[jakub]

Jakub:

After the service pack, you must go back to Manage Views and explicitly
add that field to the view in order to make the filter work correctly.

Thanks Gary,
It works.

Jakub