{"id":1416,"date":"2016-08-20T14:11:16","date_gmt":"2016-08-20T19:11:16","guid":{"rendered":"https:\/\/danvanfleet.com\/?p=1416"},"modified":"2016-08-20T14:11:16","modified_gmt":"2016-08-20T19:11:16","slug":"select-apply-template-throws-infinite-loop-detected-error","status":"publish","type":"post","link":"https:\/\/danvanfleet.com\/index.php\/select-apply-template-throws-infinite-loop-detected-error\/","title":{"rendered":"Select Apply Template throws Infinite Loop detected error"},"content":{"rendered":"

\"errorWhen applying a templete in SoftPro Select, an Apply Template Failed<\/strong> error appears showing a couple Infinite loop detected errors. This can be caused by quite literally just about anything. It is coming from either a formula or Iron Python rule attempting to access a part of the file that doesn’t quite exist yet.<\/p>\n

 <\/p>\n

<\/p>\n

\"SelectAttempting to save the file at this point can result in a “Violation of PRIMARY\u00a0KEY constraint” in “some multiple table” complaining about a “duplicate key”. Sadly that error doesn’t help find where the Infinite loop detected happened. I’ve seen it close, but never on the mark. \u00a0This error can get quite long, but remains repetitive with each Violation having a corresponding terminated . The program error log can be helpful, <ctrl><shift><L> prior to the error.<\/p>\n

What causes it<\/h2>\n

Let’s start with a bit of what is happening when an Apply Template<\/strong> is used. As Select is creating the\u00a0file, it doesn’t necessarily happen in a direct chain of events. The file is being built very fast in pieces, if part “A” attempts to use part “B” before part “B” exists, life can be very bad for the file.<\/p>\n

That minor\u00a0error\u00a0blows the whole overlay up, and we want it to. Remember Select is transactional in nature, it won’t process any part of an event unless all parts of the event succeed. Everything has a pass fail check on it. That important concept is why a partial file isn’t created. \u00a0Somewhat a\u00a0side effect is that nature\u00a0also\u00a0raises the complexity,\u00a0making\u00a0generating useful errors more difficult. \u00a0The piece of code which figures out there’s a problem, is quite far away from where on the users interface the problem originated. This is part of the reason\u00a0we see these imprecise errors in different places. Hats off to the dev team though, we’ve seen appreciated improvement in the last couple revisions, go dev go.<\/p>\n

Check before you set<\/h2>\n

When creating Iron Python formulas, you learn very quickly to check for nulls. It’s the usual development process to make sure you have something, before you do something with it. I suppose that’s useful in the real world too, there’s no reason to swing a bat if you’re not holding a bat. \u00a0In the Apply Template<\/strong> case, things are happening in parallel, but still have to work, so null checking becomes\u00a0more important. Select formulas come into play when direct index calls are made.<\/p>\n

Imagine this simple formula on a Lender<\/strong> Contact Proposed insured clause:<\/strong> field
\n
\n{{Order.Title.LoanPolicies[1].ProposedInsured}}
\n<\/code><\/p>\n

It works just fine during testing and initial roll out. Select knows during the processing of the file to not put anything in the field if a LoanPolicy doesn\u2019t exist. Apply Template<\/strong> is FAST, you might not think of it that way, but trust me, it’s blazingly fast for what it’s doing. I don’t think the same rules that exist in the user interface are fully in play. Depending on the data, the Lender Contact can come into a\u00a0file either before the LoanPolicy, or without a LoanPolicy and cause a formula like this to stop the process.<\/p>\n

How to prevent it.<\/h2>\n

Check to see you actually have something before doing any direct index calls. You might even need to check your something really has a parent something. You may be thinking, What was that again.<\/p>\n

Let’s change our code as an example.
\n
\nIf (Not IsEmpty({{Order.Title.LoanPolicies[1].ProposedInsured}})) Then
\n{{Order.Title.LoanPolicies[1].ProposedInsured}}
\nEndIf
\n<\/code><\/p>\n

Now we seem to be checking to make sure the ProposedInsured actually exists, so the problem will be fixed.<\/p>\n

It’s not.<\/p>\n

The problem here is there isn’t a LoanPolicy when the error is generated. We’re asking for LoanPolicy[1] or the first loan policy. \u00a0If there isn’t one, an error is generated before .ProposedInsured is looked at. Putting that hard coded number 1 in there is the root cause.<\/p>\n

Working Example<\/h3>\n

If ({{Order.Title.LoanPolicies.Count}} > 0) Then
\n{{Order.Title.LoanPolicies[1].ProposedInsured}}
\nEndIf
\n<\/code><\/p>\n

Is there another way?<\/h3>\n

There is always another way. For this sort of thing I’d consider using a foreach or Iterate Loop, and process only the first one. The foreach by nature will be able to deal with the null reference when no Loan Policy exists. \u00a0Plus it’s nice to know what .Count is, but it’s way more useful to know how to Iterate.<\/p>\n

That looks like this:<\/p>\n


\nIterate {{order.Title.LoanPolicies}} From 1 To 1
\n{{Order.Title.LoanPolicies[1].ProposedInsured}}
\nLoop
\n<\/code><\/p>\n

So we’re saying, Hey Select, if you have any LoanPolicies hanging about, start at the first one, and do one of them. \u00a0Note: if Title were a multiple, it would be possible for this to fail when\u00a0there were no Title’s on the file, so check the parent when necessary.<\/p>\n

Another iteration that works is a little more verbose, thus more educational.
\n
\nIterate {{order.Title.LoanPolicies}} From 1 To # \u00a0 \u00a0 \u00a0 \u00a0{{order.Title.LoanPolicies}}
\n{{Order.Title.LoanPolicies[1].ProposedInsured}}
\nBreak
\nLoop
\n<\/code><\/p>\n

So here we’re saying loop through all of the LoanPolicies if any exist, but quit (break) after the first one is processed.<\/p>\n

A little better<\/h3>\n

Finally to cross a\u00a0t or dot the i, we make sure we actually have a value before attempting to use it.
\n
\nIterate {{order.Title.LoanPolicies}} From 1 To #{{order.Title.LoanPolicies}}
\nIf (Not IsEmpty({{Order.Title.LoanPolicies[1].ProposedInsured}})) Then
\n{{Order.Title.LoanPolicies[1].ProposedInsured}}
\nEndIf
\nBreak
\nLoop<\/code><\/p>\n

As it goes, there’s another good way.<\/p>\n


\nIf ( Not IsEmpty ({{Order.Title.LoanPolicies}})) Then
\n{{Order.Title.LoanPolicies[1].ProposedInsured}}
\nEndif
\n<\/code><\/p>\n

This is a good example of checking the existence of something before using it. It is also how parent and grandparent items can be checked for null.<\/p>\n

The moral of the story is a single line formula that contains a hard index is a potential problem. It will work some of the time, it won’t for Policies and other unknown areas. So be safe, do some checking to make sure things actually exist.<\/p>\n

A quick note, I’m not using value= syntax in this example you\u00a0probably should, so the active line would be
\n
\nvalue = {{Order.Title.LoanPolicies[1].ProposedInsured}}
\n<\/code><\/p>\n

How to fix it<\/h2>\n

Search the formulas for [1]<\/strong>, any one of them could be the problem with some noted exceptions. Create a SoftPro support ticket to see\u00a0all your formulas in one text file. All Orders have a base set of multiples that would never cause this problem. \u00a0Order.Properties is one of them. All Select Order dot based “files” always have a property multiple. \u00a0I think there are a couple more,\u00a0if you have that list, send it to dan@vfinfo.com, or better yet, post a comment.<\/p>\n

I now have 130 contacts in this test file, anyone want to delete them? A special thanks to Kayla who assisted in figuring out what was causing the initial error that lead to this blog entry. I don’t typically blog on support assisted fixes, in this case the value of understanding that formulas are more complex than they may appear, was worth bending that rule.<\/p>\n","protected":false},"excerpt":{"rendered":"

When applying a templete in SoftPro Select, an Apply Template Failed error appears showing a couple Infinite loop detected errors. This can be caused by quite literally just about anything. It is coming from either a formula or Iron Python rule attempting to access a part of the file that doesn’t quite exist yet.  <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3,23],"tags":[6,39,17],"class_list":["post-1416","post","type-post","status-publish","format-standard","hentry","category-general","category-softpro-2","tag-error","tag-select","tag-tips","entry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wyVb-mQ","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/comments?post=1416"}],"version-history":[{"count":11,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1416\/revisions"}],"predecessor-version":[{"id":1429,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/1416\/revisions\/1429"}],"wp:attachment":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/media?parent=1416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/categories?post=1416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/tags?post=1416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}