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
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 !
ReplyDeleteDo you know if this can be done with MO365?
ReplyDelete