InfoPath Error: The number of calculations used for a single action exceeded the maximum limit.

I've got a very complex form in InfoPath.  At first everything was working fine.  Then the end user asked for more and more functionality.  Where I am now...

The form has 6 sheets (views).  Where I am having an issue is with the number of calculations.  I've read that the limit is 16 however, I've exceeded that BIG TIME which makes me wonder what the 16 is supposed to apply to.

On the view I'm working on, I have 3 rules set up on one field to change 75 fields per rule on a different view.  On the view with the 75 fields, there are 9 rules per field that does a calculation depending on the results of the first rule. 

Where I'm having an issue is I need to have the rules apply to two additional fields making the total 77 instead of 75 however I get the error that "A calculation in the form has not been completed.  The number of calculations used for a single action exceeded the maximum limit."  Once I click "OK" on the error screen I get another one that says "Some rules were not applied.  Operation aborted"

I'm in the testing phase of this form and have not run across this before.  Does anyone know what the maximum calculations / rules / etc, InfoPath has?

How can I get around this error?  Any information would be much appreciated.


  • Edited by Debra Gayle Saturday, March 09, 2013 10:46 PM
March 8th, 2013 9:06pm

The only time I've seen that is when I've caused rules to loop. In other words, field A changes field B which changes field C which changes field A.
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2013 2:38am

Roland,

Thanks for this.  However, I can't find the loop.  The formulas (rules) I have applied are exactly the same for all fields involved however when I add two certain fields, the error occurs.  I've searched and searched and can't find what would cause the difference.

I'll keep looking. 

Thanks again.

March 12th, 2013 5:45pm

Can you add rules or split actions per rule?
Free Windows Admin Tool Kit Click here and download it now
March 13th, 2013 1:20am

Yes.  I'm able to add more rules... it seems to be two particular fields that are causing the issue.  The calculations around those two fields are exactly the same as the other rules.  Which is why I'm not sure what loop is being created.

I have found a work around in the meantime.

Thanks for your help.

March 15th, 2013 7:49pm

Hi,

I've got a complex form in Infopath 2010. It has around 45 rules bound to it based on user selection. 

Is actually there any limitations to have maximum number of rules for an Infopath form. Because I hear people say there are limitations to 16 rules per form and some say there are no limitations on maximum rules for any Infopath forms.

But I did found that my form with 45 rules does work fine in Google Chrome browser and NOT in IE browser. 

My concern here is, Is there a way to override that limitation in IE because IE is the organization's standard browser and I cannot request users to try in Chrome.

Please help me close this issue. 

@Debra Gayle, You said you have found a workaround for your issue. It would be grateful if you can share it with everyone. Thank you.

 


Free Windows Admin Tool Kit Click here and download it now
September 18th, 2013 7:44am

FYI: I had this issue and discovered that I had accidentally done this:

  • had a field that I was just using to display the state of a column/field, but I had modified the default to be something like [concat("Current State of field -", '.']
  • turns out that I had the "field" bound to this same control and so it was trying to assign itself to itself...

That's when I got that error at runtime.

Just posting this here because (a) it was difficult to spot as nothing hints it at you and (b) caused weird behavior setting things that I didn't want set even thought the field was read only (this obviously only applies to UI and the code still "takes" the default setting...)

Hoping this might help someone in what to look for...

August 24th, 2015 7:16pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics