Critical error while retrieving values from data connection

Question

My data connection is returning around 1000 values which populates three dropdowns based on certain criteria.

I am facing issue while retrieving the data

Following is the error I got

Critical Error

There has been a critical error while processing the form.

Click Start over to load a new copy of the form.

Error details

The form could not be displayed because default values or rules are taking too long to evaluate. To correct this, simplify the expressions or reduce the size of the data sets that they depend on.

Correlation ID:cadfd89c-0039-1000-aab2-254a197ec65b

Is there any restriction on the number of values a data connection returns??

I am using sharepoint 2013 and Office 365. The custom list form is designed using Infopath 2013.

What can be the solution for this issue??

Please suggest

Answer 1

The issue should not be with the data connection or the 1000 values being returned. These should all be fine unless the 1000 values are incredibly massive in size. If you believe there is an issue here, modify the data connection so that it returns 2 very small values (like the values "1" and "2"). If it persists, that is not your issue.

From the error message, you might try looking into the rules inspector and evaluating whether you have any circular rules (i.e. A updates B, B updates A... or A updates B, B updates C, and C updates A). These would cause such an error.

Answer 2

Try limiting the number of rows the data connection retrieves down to a small number, like 50, and see if things work again. If not, that is not your issue. Then it will be a matter of tracking down what did go wrong.

If it works at 50 rows, or 100, or 200, but then again, not at 1000, that seems strange, and the first place I would look is the data itself for some strange characters (even hidden ones that look like blank space). If it is not that it will take more investigation to find out what is going on, and the next thing I would do is to create a new blank test form that did nothing but pull in the 1000 items to a dropdown to see if that works.

Answer 3

Hi,

Thanks fro your response,

I have 44 fields in my form and there are 3 views.

The form is tightly bound to workflows.

For 200 list items everything worked fine.

On button click my dropdowns gets filled with options to select from .

Like this I have three dropdowns populating from a single list.

Now i have almost 1000 list items and the dropdown does not get filled and the error is thrown.

Please let me know if you need more information.

Thanks in advance..