Siteminder and PWA

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.
 
G

Gary L. Chefetz

Brian:

I think you need to hit the CA communities, if there are any, to get your
answers to this one. You're not doing a good job of explaining what you're
talking about with two servers working and one not working. Are these part
of the same installation or independent installations? Get the picture?
We're not mind readers. Also, it's a really bad idea to edit what error
messages you post and those you don't. The series is often as important at
the individual messages in determining what's going wrong. With that said, I
suspect you corrupted the database, but I couldn't say that for certain,
particularly with the wild cards you've thrown in and the lack of complete
information.

--

Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

Brian Tkatch said:
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.
 
B

Brian Tkatch

Brian:

I think you need to hit the CA communities, if there are any, to get your
answers to this one. You're not doing a good job of explaining what you're
talking about with two servers working and one not working. Are these part
of the same installation or independent installations? Get the picture?
We're not mind readers. Also, it's a really bad idea to edit what error
messages you post and those you don't. The series is often as important at
the individual messages in determining what's going wrong. With that said, I
suspect you corrupted the database, but I couldn't say that for certain,
particularly with the wild cards you've thrown in and the lack of complete
information.

Gary, i appreciate your reply. It may be better to ask in CA, but i
just follow this NG to some extent, and seeing all the knowledge here,
i figured i would ask.

The installations are three completely separate installations. Each
supports a different department. Two of them are two-tiered (database
on a separate server) and a third is single-tier.

I sent a shorter message as i have found that when i give all the
detail, noone ever really responds. I figured that people want a
little and will ask for more as required. Either that, or i just keep
doing something incorrectly. So, i'll post all the error messages.

I just now logged in to PWA and clicked on "Resources". The error
mentioned was displayed, and the Event Log (Application) has the
following four messages:

=============================================
Message 1
=============================================
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>
=============================================
Message 2
=============================================
Component: PjBusObj
File:
C:\Office\dev\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 3754
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
=============================================
Message 3
=============================================
Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
=============================================
Message 4
=============================================
Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1073
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
=============================================

Any help would be greatly appreciated.

B.
 
G

Gary L. Chefetz [MVP]

Brian:

It certainly looks like data corruption; possibly a duplicate key. The other
possibility is that SQL crashed. Have you tried rebooting the system? If the
problem persists, can you revert to a backup? Troubleshooting this on-line
is not going to be a quick solution.

--

Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Brian Tkatch said:
Brian:

I think you need to hit the CA communities, if there are any, to get your
answers to this one. You're not doing a good job of explaining what you're
talking about with two servers working and one not working. Are these part
of the same installation or independent installations? Get the picture?
We're not mind readers. Also, it's a really bad idea to edit what error
messages you post and those you don't. The series is often as important at
the individual messages in determining what's going wrong. With that said,
I
suspect you corrupted the database, but I couldn't say that for certain,
particularly with the wild cards you've thrown in and the lack of complete
information.

Gary, i appreciate your reply. It may be better to ask in CA, but i
just follow this NG to some extent, and seeing all the knowledge here,
i figured i would ask.

The installations are three completely separate installations. Each
supports a different department. Two of them are two-tiered (database
on a separate server) and a third is single-tier.

I sent a shorter message as i have found that when i give all the
detail, noone ever really responds. I figured that people want a
little and will ask for more as required. Either that, or i just keep
doing something incorrectly. So, i'll post all the error messages.

I just now logged in to PWA and clicked on "Resources". The error
mentioned was displayed, and the Event Log (Application) has the
following four messages:

=============================================
Message 1
=============================================
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>
=============================================
Message 2
=============================================
Component: PjBusObj
File:
C:\Office\dev\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 3754
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
=============================================
Message 3
=============================================
Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
=============================================
Message 4
=============================================
Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1073
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
=============================================

Any help would be greatly appreciated.

B.
 
B

Brian Tkatch

Brian:

It certainly looks like data corruption; possibly a duplicate key.

Data corruption? That doesn't sound good. Is there anything i should
look for?

The other possibility is that SQL crashed. Have you tried rebooting the system?

I have not tried rebooting the system. It's not so simple for me to do
that here. But if i needed to, i could.
If the problem persists, can you revert to a backup?

As for reverting to a backup, i am afraid i would lose data at this
point. I caught this only some days after it was installed.
Troubleshooting this on-line is not going to be a quick solution.

Is there another avenue?

B.
 
G

Gary L. Chefetz [MVP]

Brian:

I'd try the reboot first, but I suspect your "alternate" route is to engage
professional services help if you need it. In the future, you'll want to
test changes like this in a development or test environment.
 
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.

The resolution to my problem was in a KB
article:<URL:http://support.microsoft.com/kb/832588/en-us>.

A simple file pernmission. Who woulda thought?

B.
 
G

Gary L. Chefetz [MVP]

The problem, then, would have predated your use of siteminder. IOW, this was
not the cause in this case.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Brian Tkatch said:
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.

The resolution to my problem was in a KB
article:<URL:http://support.microsoft.com/kb/832588/en-us>.

A simple file pernmission. Who woulda thought?

B.
 
B

Brian Tkatch

The problem, then, would have predated your use of siteminder. IOW, this was
not the cause in this case.

Gary, i appreciate your attentiveness and decisiveness, however, on
the dev box, changing exactly one file's permissions made it work.
Changing it back, made it fail. Very much repeatable. The change, to
be exact, was allowing anonymous access to msadcs.dll via IIS.

[After i posted the original note, more came to light.]

On the production servers, the change was different. Changing just the
file permission did not help. Indeed, changing the entire directory's
permission did not help. So, we removed the entire MSADC directory
from SiteMinder's protection on the SiteMinder policy server. With
that change, the tabs work except for the "Resources" tab which gives
the other error.

On top of that, SiteMinder seems only to ask for a login on Virtual
Directories creates after its installation. Legacy Virtual Directories
do not ask for a login, causing our scheme to fail. Being i cannot
delete or rename the default directory created by Project (without
uninstalling/reinstalling) i need to use editsite to create yet
another directory.

I still have the ticket opened with Microsoft. I'll be happy to post
if we find anything else.

B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top