Error in SP2a when trying to view resources

[Steve]

In upgrading PS2003 to SP2a, all of the upgrades appeared to proceed w/o
errors. Access via PWA works in every error except viewing resources.
Thenan error appears that there is aproblem, becqause the DNS is bad or there
are too many resources (50 resrouces and the DNS is fine as all the other
links work fine).

In the event log, this message appears
--------------------------------------------------------------------------------------------
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[Column names in each table must be
unique. Column name 'ResourceUniqueID' in table '#TempResView' is specified
more than once.]]></Description

 

[Gary L. Chefetz [MVP]]

Steve:

Is the view you're accessing using a filter? If so, modify the view to
explicitly contain all fields specified in the filter.