IndexOutOfRangeException

[GV]

Has anyone encountered the following error? I am unable to find any posts
related to it. I am seeing a lot of them in the logs.

Thanks.

Exception Message=There is no row at position 0.
Exception Source=System.Data
Exception ToString=System.IndexOutOfRangeException: There is no row at
position 0.
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.DataRowCollection.get_Item(Int32 index)
at
Microsoft.Office.Project.Server.BusinessLayer.Project.GetApprovalWorkflowUrl(Guid projectUid)
at
Microsoft.Office.Project.Server.WebService.PWA.ProjectGetApprovalWorkflowUrl(Guid projectUid)

 

[Stephen Sanderlin]

Need more information. when does it occur? Do you have ULS logs? What
patchlevel of PS07? Do you have repro steps?

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[GV]

This is being caused by Security.CheckUserGlobalPermissions call.

The environment is
SharePoint 2007
MOSS Search
Project Portfolio Server 2007
Project Server 2007 w/ SP1 Version 12.0.0.6219
officeserver2007sp1-kb936984-x86-fullfile-en-us.exe (both servers) Service
Pack

Thanks for your Help.

 

[Stephen Sanderlin]

I'm unsure that this is originating from a
Security.CheckUserGlobalPermissions call. According to the stack trace
you posted, the error originated from a call to the
ProjectGetApprovalWorkflowUrl method in the PWA web service.



This method calls an internal method, which retrieves information from
the Published DB using the two stored procedures:

1. MSP_Admin_GetProposalInfo, which retrieves information from the
MSP_WEB_ADMIN table.

2. MSP_PROJECTS_GetWorkflowInstanceUidForProjUid, which retrieves
information from the MSP_PROJECTS table.



Although I cannot say which one is at fault from the information in the
stack trace, unless you are making a call to the
ProjectGetApprovalWorkflowUrl method of the PWA web service, the
GetApprovalWorkflow is being called when the details of a Proposal or
Activity are viewed in either Proposals and Activities or the Project
Center.



Assuming you're not making the call yourself, my best guess is that
either you've removed the Proposal workflow, or you have some sort of
problem with whatever approval workflow you are using - perhaps it is
missing or broken. Follow the directions on this page
(http://technet.microsoft.com/en-us/library/cc197595.aspx) to find it.
Hopefully this should give you some direction. You may also want to take
a look at the two stored procedures I mentioned and see which one
returns no rows.



Please us know what happens!


--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com