21 April, 2014

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

2 comments:

  1. Thank you for the explanation! I looked for this information hours and I tried to do a lot of things but nothing worked. On your blog I can always find what I need. Thank you so much !

    ReplyDelete
  2. Do you know if this can be done with MO365?

    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.