26 August, 2011

InfoPath Error: This session has exceeded the amount of allowable resources + Event ID 5737


Microsoft Office InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. InfoPath Forms Services uses session state to store the large amount of transient data generated while filling out a form. As a result, front-end Web servers can remain stateless between round trips, and each post back is not burdened with carrying large amounts of session state information over narrow bandwidth pipes.

One of the users opened a ticket with our team By mentioning that he is getting some error message while opening InfoPath forms:

Error Message: InfoPath Error: This session has exceeded the amount of allowable resources

It was a actually a new issue for me so i had started my troubleshooting by debugging the InfoPath forms.

Checked InfoPath form settings, tried to designed a new form, analyzed SharePoint logs as well as Event viewer. While analyzing the event viewer error messages, i found something which was very useful towards the case resolution. (Please refer the below mentioned trace)

Event Viewer details:

Event Type:      Error
Event Source:    Office SharePoint Server
Event Category:  Forms Services Runtime
Event ID:        5737
Description:    
Number of form actions 208, has exceeded 200, the maximum allowable value

Per request. This value is configurable and can be changed by the administrator.

Microsoft Note: In order for the session state database to be properly maintained, the SQL Agent must be turned on for the instance of Microsoft SQL Server where session data is stored. If the SQL Agent is not turned on, expired sessions are not automatically expunged from the session table and may eventually pose a storage problem.

As per the data from the event viewer, it states that we need to check something within central administration as "This value is configurable and can be changed by the administrator". When i checked the Central Administration settings then i found what i was looking for :-)

Resolution:

Increase the form actions in configuring InfoPath services section as mentioned below:-
  • Go to Central Administration of the SharePoint server.
  • Click on Application Management
  • In the section "InfoPath Forms Services"-->select Configure InfoPath Forms Services.
  • In the Number of Actions per Post back, enter some max value around 250 or 300 depends on your project form requirement.
  • There are chances that the error may retain same even after we increase the number of actions per post back. The second thing we have to increase is the value of "Maximum size of form session state" to 8192. By default it is 4092, by increasing it to 8192 the error should go away. 
If you have any queries/questions regarding the above mentioned information then please let me know...
I would be more than HAPPY to HELP You as well as RESOLVES Your Issues, Thanks

7 comments:

  1. Hi Amol,

    I have the same issue on SharePoint 2010, following is the exact error message:

    Session state size, 3815 bytes, has exceeded 1536000000 bytes, the maximum allowable valueThis value is configurable and can be changed by the administrator.

    And, I have following values configured:

    Number of postbacks per session: 1000 (I have increased it from 75 to 1000 to make this work)

    Number of actions per postback: 2000 (I have increased it from 200 to 2000 to make this work)

    Maximum size of user session data: 2000000 KB (I have increased it from 1500000 to 2000000 to make this work)

    But, I am still getting the same error. Could you please help me in resolving this issue.

    Thanks & Regards

    Saurabh Dhingra (ssaurabhdhingra@gmail.com)

    ReplyDelete
  2. sure, we will definitely resolve this issue.

    Could you please tell me the value of this section: Maximum size of form session state?? [by default it is 4092]



    ReplyDelete
  3. I am extremely impressed along with your writing skills and also with the
    layout on your weblog. Is this a paid subject or did you modify it your
    self? Anyway keep up the excellent quality writing, it is rare to see a great blog like this one these days..



    my webpage :: explanation []

    ReplyDelete
  4. Thanks for sharing this! it works for me.

    ReplyDelete
  5. I'm not positive the place you're getting your information, but good
    topic. I must spend some time studying much more or
    figuring out more. Thank you for wonderful info I used
    to be on the lookout for this information for my mission.


    Here is my web blog - godaddy review

    ReplyDelete
  6. Ηello, Neat pοѕt. There's a problem along with your web site in internet exрlοreг,
    would сheck this? IE ѕtill is the market chief and
    a large portion of other folks ωill pass оveг your magnіficent writing bеcause of this problem.


    Also visit my site - UFC 165 Live Stream free

    ReplyDelete
  7. I really like what you guys are usually up too. This kind
    of clever work and coverage! Keep up the good works guys I've added
    you guys to my own blogroll.

    My weblog :: template for business cards (activist242.org)

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.