I recently ran into a scenario where a client was getting an InfoPath error after a while, when up until this point the form had been working without fail.
This can actually be surfaced as one of two error messages. The details of the errors can be seen below.
“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.”
“Cannot connect to the server at this time. You can continue working with this list, but some data may not be available.”
In this case what can be happening is that the amount of data you’re pulling back in your queries has grown to an unmanageable size. Another possibility is that you’re including additional columns that perhaps you don’t actually need to include – by removing the unnecessary fields this could immediately resolve your issue if you don’t require all the columns.
If removing unnecessary columns in your query doesn’t apply, or doesn’t resolve your issue (be sure to try this first!), then you can follow the steps below to increase your form services threshold.
- Go to Central Administration
Click on “General Application Settings”
Choose “Configure InfoPath Forms Services” under “InfoPath forms Services”
Adjust the Response Size (which is in kilobytes). The default is 1500 KB.
This should resolve your issue with being able to continue using your forms. Obviously this isn’t something you can adjust in Office 365 (or in a farm where you don’t have access to change this), so you’ll need to find a way to pull less data in by either removing columns in your query, or adding filters into your query.