InfoPath Dev

Hello,  A user recently ran into an error while using and odata connection where they receive the error message "A Microsoft SharePoint Server State Service error occurred while processing your request. For more information, contact our server farm administrator." the query runs great for me, but then again, I'm the admin. the individaul entries in this form library (forms + saved form fields) are processed by a workflow that changes the rights to only allow the correct users to see their individual entries. I'm wondering... Does an Odata query error when it can not read every entry in a form library? That would s*ck. This particular request below is for an individaul who only has rights to see a single entry. by default the workflow gives this person contribute access to their entry, but I have changed that individual to have full rights to test. full rights did not help Odd part is that on form load a similar query is executed without issue.     Leaving Monitored Scope (Request (GET:https://sharepoint.company.com:443/departments/legal/contractmgmt/_vti_bin/listdata.svc/Contracts?$select=CompanyName,ContractDateNeeded,Id,CompanyContact,StartDate,CompanyAddress,CompanyCity,CompanyState,CompanyZip,CompanyContactPhone,CompanyContactEmail,ContractAmount,ContractType,BusinessUnit,ContractNotes,LegalComments,CreatedById,CompanyContactDepartment,FileUrl&$filter=Title%20eq%20'Something541.xml')). Execution Time=211.213156979449 Access denied. Thread was being aborted. Not persisting state for request due to previous errors. Form Template: urn:schemas-microsoft-com:office:infopath:CMSUser:-myXSD-2011-05-04T15-30-38 Unhandled exception processing request for PostbackPage Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException: Exception of type 'Microsoft.Office.InfoPath.Server.Util.InfoPathFatalException' was thrown. at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentFormId() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.get_CurrentContext() at Microsoft.Office.InfoPath.Server.Util.GlobalStorage.IsDefined(GlobalItems key) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.TryGetCachedTimeZoneId(UInt16& timeZoneId) at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.GetSPTimeZoneObject() at Microsoft.Office.InfoPath.Server.Controls.DateFormattingInfo.CalculateSPLocalTimeOffset() at Microsoft.Office.InfoPath.Server.Util.GenericUtils.GetServerTimeZone() at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderResult(TextWriter writer, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.DocumentLifetime.ErrorPageRenderer.RenderForException(HttpContext context, Exception exception, Document document, EventLogStart eventLogStart) at Microsoft.Office.InfoPath.Server.Controls.PostbackPage.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Select Tags... SaveCancel [Edit Tags]

update...

It does not look like odata will choke if it can not read all the entries in a form library.  I tested by having a user who has no access to the form library to run the query from the browser.  0 results.  I then gave the user contribute rights to a single entry in the form library and had them re-run the query on their browser.  This time, 1 result.

interesting...

So why does the SP log say "access denied" ? 

Hello,

 So I found the offending Odata call, its...

https://sharepoint.mycompany.com/_vti_bin/listdata.svc/UserInformationList(1)

in my change rest URL I made the simple change of putting a variable in for the number in (): https://sharepoint.mycompay.com/_vti_bin/listdata.svc/UserInformationList(UserID) <<where UserID is a valid integer>>

when I ran this it worked fine for me

 I then thought it may be choking on using the shortcut of putting the number in () so I changed the command to look like https://sharepoint.mycompany.com/_vti_bin/listdata.svc/UserInformationList?$filter=Id eq UserID  <<where UserId would be a valid integer>>

This did not solve the problem either when running the command from the browser form

The odd thing is if I log onto a machine with the test user account and run the same command in the browser it returns good data

What gives????  Is there special rights I need to give all users for the list "UserInformationList"?

SP 2010

IP 2010

I feel bad that you are kind of talking to yourself here - but I really don't know what the permissions would have to be - It sounds like you are saying you get data back but it fails in InfoPath. I see your site is https - are you using IE 8 or 9?

My PC is IE 9, but we have a mix here.  I don't think IE is the issue as I had one of the people having the issue log onto my pc and test.  they received the same error.  I did notice if I make my test user a collection admin that everything works fine... thus I'm really convinced it a rights problem.  Just finding the correct spot to give standard users the rights is still eluding me.

talking to myself... I hope that is not the first sign of going crazy

thanks for your help,

-B

Update:

 If I browse to https://sharepoint.mycompany.com/_catalogs/users/simple.aspx I'm rewarded with being able to view the user list.

If I log in as a standard user, That ID is penalized with an "access denied" screen.  Should regular users be able to browse to https://sharepoint.mycompany.com/_catalogs/users/simple.aspx?  I don't see why not, I can't change anything so I don't see the harm in letting them see it.  I would grant rights, but this list does not have a list settings.  therefore the rights must be inherited from some other place.  digging...

Update:

Found the area to update the rights to user list:  https://sharepoint.mycompany.com/_layouts/user.aspx?obj={D45BAC54-3872-4689-A757-5B2CD1D72211},LIST

went ahead and gave my test user read permissions and then it was able to browse https://sharepoint.mycompany.com/_catalogs/users/simple.aspx

 I also checked a recently built dev server to see if a standard user could browse the user list data, thinking I may have done something to my current enviroment that prevened it.  By default, "no" users do not have access to https://sharepoint.mycompany.com/_catalogs/users/simple.aspx .  Thus, I don't believe having read rights to this list would effect my browser form issue.

after testing, I confirmed that after giving my test account read rights to the user list, the browser form still chokes when running the odata command to query the UserInformationList

However, as stated before, if I run the odata command in a browser as the test user, I do return xml results as expected

back to square 1

Hello All,

So I'm tracking down from the sharepoint logs.  I'm not sure how to interpret this so perhaps someone that knows SP / SQL a bit better can help explain this issue I'm seeing, and if there is a quick fix... oh how I long for a quick fix!

Name=Request (POST:https://sharepoint.mycompay.com:443/departments/legal/contractmgmt/_layouts/Postback.FormServer.aspx)

StateSqlSession.GetItemBytesInternal() Locked row in database for key f78b522f51cb46949388776969d86e21_04d682314cf34c95a639511aa566dcab for 2 seconds

StateManager.GetState() Locked data (04d68231-4cf3-4c95-a639-511aa566dcab)

MOSS StateService threw an exception: A Microsoft SharePoint Server State Service error occurred while processing your request. For more information, contact your server farm administrator.

The StateManager is disposing and calling ReleaseLockedStates() (Count=0)

Leaving Monitored Scope (Request (POST:https://sharepoint.mycompay.com:443/departments/legal/contractmgmt/_layouts/Postback.FormServer.aspx)). Execution Time=32.5935279483845     Have a good weekend! -B

Hello All,

So I'm tracking down from the sharepoint logs.  I'm not sure how to interpret this so perhaps someone that knows SP / SQL a bit better can help explain this issue I'm seeing, and if there is a quick fix... oh how I long for a quick fix!

Name=Request (POST:https://sharepoint.mycompay.com:443/departments/legal/contractmgmt/_layouts/Postback.FormServer.aspx)

StateSqlSession.GetItemBytesInternal() Locked row in database for key f78b522f51cb46949388776969d86e21_04d682314cf34c95a639511aa566dcab for 2 seconds

StateManager.GetState() Locked data (04d68231-4cf3-4c95-a639-511aa566dcab)

MOSS StateService threw an exception: A Microsoft SharePoint Server State Service error occurred while processing your request. For more information, contact your server farm administrator.

The StateManager is disposing and calling ReleaseLockedStates() (Count=0)

Leaving Monitored Scope (Request (POST:https://sharepoint.mycompay.com:443/departments/legal/contractmgmt/_layouts/Postback.FormServer.aspx)). Execution Time=32.5935279483845     Have a good weekend! -B

How large is the data being returned?  I suggest checking the InfoPath Form Services settings in Central Admin. Make sure your maximum size of user session data is large enough.

I thought that too.  so I added a '0'

from 1500 to 15000

Still the same error at exactly the same time.  As a stie collection admin, things work fine.  when a standard user uses the form they can click on seperate form buttons that call odata queries 3 times.  On the 4th time the error happens.  I thought if it was a data return issue that I would at least get 1 or two more queries in by changing the return data to 15000, but not the case.

-B

 edit: I did nothing after making that change though.  Is this a dynamic change in SP? or do I have to do an IIS reset or something like that to have the change take effect?

Hi, i am using REST url for filtering data from sharepoint list and populating in multi select list box. i am changing the REST URl on a dropdown change action and querying using data connection. I am getting below error msg: "A Microsoft SharePoint Server State Service error occurred while processing your request. For more information, contact your server farm administrator" This error is not coming all the time. not able to understand in which scenario i am getting this error. my environment details SP 2010, InfoPath form with browser opened and publishing using administrator approval. Having multiple WFE's and load balancer. Web application is Kerberos authentication. plz help me.