B
Brian Tkatch
Project Server 2003
We are trying to install SiteMinder Agent on a few Project Server
boxes, and have been encountering errors.
After the SiteMinder Agent was installed, all three servers had
problems with PWA. Most of the tabs redirected the user back to the
home page, and the Resources tab gave an error:
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
VBScript: Microsoft Office Project Web Access 2003
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
An error occurred 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.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
SiteMinder was then disabled on all the boxes. On all three the tabs
stopped redirecting back to the home page. However, for the
"Resources" tab, one server resumed working properly, but the other
two did not.
The Event log shows four errors each time i load the page. Three of
them are just an assert failed from different scripts, but the first
states:
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
File: C:\Office\dev\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
'RES_CHECKEDOUT'.]]></Description>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
The COLUMN indeed doest exist, and can be SELECTed by the user that
Project logs into the database with. SQL Server logs and the event
logs on the database server (for the one that has Project and SQL
Server on different boxes) shows only successful logins.
Upon further investagtion, i found that the error only show up for
people inany of the following groups:
Administrators
Executives
Portfolio Managers
Resource Managers
Memership in any of those groups, causes the error. Being in:
Project Managers
Team Leads
Team Members
does not cause the error (unless they are also in one of the other
four).
Does PWA work with Siteminder?
B.
We are trying to install SiteMinder Agent on a few Project Server
boxes, and have been encountering errors.
After the SiteMinder Agent was installed, all three servers had
problems with PWA. Most of the tabs redirected the user back to the
home page, and the Resources tab gave an error:
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
VBScript: Microsoft Office Project Web Access 2003
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
An error occurred 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.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
SiteMinder was then disabled on all the boxes. On all three the tabs
stopped redirecting back to the home page. However, for the
"Resources" tab, one server resumed working properly, but the other
two did not.
The Event log shows four errors each time i load the page. Three of
them are just an assert failed from different scripts, but the first
states:
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
File: C:\Office\dev\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
'RES_CHECKEDOUT'.]]></Description>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
The COLUMN indeed doest exist, and can be SELECTed by the user that
Project logs into the database with. SQL Server logs and the event
logs on the database server (for the one that has Project and SQL
Server on different boxes) shows only successful logins.
Upon further investagtion, i found that the error only show up for
people inany of the following groups:
Administrators
Executives
Portfolio Managers
Resource Managers
Memership in any of those groups, causes the error. Being in:
Project Managers
Team Leads
Team Members
does not cause the error (unless they are also in one of the other
four).
Does PWA work with Siteminder?
B.