Infopath Error: The amount of data that was returned by a data connection has exceeded - SharePoint2010/SharePoint2013

I have designed one InfoPath form which is trying to fetch number of items via data connection from SharePoint list which consist of more than 10,000 items. When I designed the form 6-7 months before then it was working fine without any issues but over the period of time, we have modified the InfoPath form with certain number of fields and this is a starting point of error – when published the form without any issues but the form is not opening in browser mode functionality and throwing the following exception.

Error message#1:

The amount of data that was returned by a data connection has exceeded the maximum limit that was configured by the server administrator. Form elements, such as drop-down lists, may be blank.

Error message#2:

Cannot connect to the server at this time. You can continue working with this list, but some data may not be available.

It took little time to figured out the resolution for this issue let me share the resolution in detail and Yes, step by step so that there will be no confusion.

Resolution:

1.   Open the central administration

2.   General Application Settings

3.   InfoPath Form Services

4.   Configure InfoPath Form Services

5.   Data Connection Response Size

6.   By default it is 1500 kilobytes -> Here is little bit testing you need to do with respect to your form. Like try to change it to 2000 and check the results.

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, Thank you.

IMP:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product Applies To:

o   SharePoint Server 2010

o   SharePoint Server 2013

InfoPath form library forms cannot be filled out in a Web browser

Today I was monitoring the SP servers along with some regular sanity checks that need to be carried out on daily basis. While doing that, I noticed one error based on this InfoPath rendering in the Health check analyzer!  But let me tell guys InfoPath is perfectly working in our environment without any issues and nobody has reported any incident also then why this error is showing in the health analyzer? – you must be thinking the same but no need to worry about as this is not a big one which will take lot of your time, some minor checks and you are done.

Error message:

InfoPath Forms Services forms cannot be filled out in a Web browser because no State Service connection is configured.

If this is your new configuration then you need to follow this existing official documentation from Microsoft which is pretty awesome!

http://technet.microsoft.com/library/ff805082.aspx

In our case, we have already done this configuration long time back and as I said, it’s working fine. The error message is little bit misleading one as its asking you to check the “state service” service application to be online or not but that’s not the case. We have already configured this service application long time back so where exactly the issue is and why it’s throwing the error?

Let me tell you the trick which we sometimes ignored – Look out the error in the HAL rule – see the below:

You will notice that it’s also giving you the URL of the web application for whom its failing and name of the servers also.

In our case, we have recently created a new web application in the farm and its been reflected in that! What it means? Pretty simple – the ‘state service’ service application is not configured for the same.

So what we need to do now for this re-association? Here are the details:

Resolution:

1.   Open the central Administration

2.   Application management

3.   Service applications

4.   Configure service application associations

5.   Select the web application for whim it’s failing

6.   Click on custom

7.   It will open the service application options

8.   Select the state service check box and click OK

Once you are done with the above steps then come back to health analyzer list, click on the same rule and hit “Reanalyze now” – that’s it, you are done.

That error won’t be there! Happy SharePoint once again…

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, Thank you.

Note:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product Applies To:

o   SharePoint 2010

o   SharePoint 2013

o   SharePoint Foundation 2013

o   SharePoint Foundation 2010

There was an error retrieving data from a datasource + An entry has been added to the Windows event log of the server + Event ID-7893

Problem Description:

I have a browser enabled InfoPath form loading in a Form web Part in a webpart page with another connecting web part. When users try to open the form they get:

"An error occurred querying a data source"

Sympton-1: Occasional error when opening an InfoPath form

Sympton-2: InfoPath timeout random error first time form is loaded

Sympton-3: An error occurred querying a data source

Sympton-4: There was an error retrieving data from a datasource.

Click OK if you want to resume filling in the form.  Possibly you might want to check the form for errors.

Sympton-5: There was an error retrieving data from a datasource. An entry has been added to the Windows event log of the server.

Log ID: 7893

Troubleshooting:

Best suggestion / recommended one is check the SharePoint ULS logs and find out the exact root cause behind this error message. I also did the same and found out that it is happening because of data connection time outs.

Resolution:

The Maximum data connection timeout value you modified is used to override all data connection time out values that specified within form template code. If you are not specified the time out value within form template code, please increase the default data connection timeout in Central Administration.

-Central Administration

-General Application Settings

-Configure InfoPath Forms Services

-Increase the time out value and try again.

If you have any queries/questions based on the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you.

Product Applies To:

-SharePoint Server 2010

-SharePoint foundation 2010

References:

http://technet.microsoft.com/en-us/library/cc262263(v=office.14).aspx