You are viewing limited content. For full access, please sign in.

Question

Question

Drop down fill by lookup - validation error after time

asked on September 28, 2018

Hi - we have a recurring issue where, after a period of time, forms lose track of the values in drop-down fields that have been populated by lookup.  Specifically, the situation is:

  • A drop-down field (or more than one) has its list of available choice populated by lookup
  • User selects choice from the available list
  • If the form is submitted "quickly", the submission executes fine
  • If the form is open for a period of time (somewhere in the 30-60min range), Submit throws an error for each of the drop-down/lookup fields that the "value does not belong to the list of choices" (see attached file for error screen capture).
    • Each field reports [LFF9309-InvalidChoice] and [LFF9312-ErrorOccurredDuringFormsValidation]
    • Also get one [LFF9320-FormsValidationAggregateException]

 

By my read, the form fails during validation (setting = "validate user input"), because for one reason or another, the validation routine has lost track of the allowable lookup values.  It's not clear if it has lost connection for a real-time comparison, or a cached list.

If anyone can offer insight into this issue, or suggestions on idle/time-out/other settings to investigate or adjust, it would be much appreciated.  A few comments or observations that may help:

  • Turning off validation does appear to eliminate the problem.  However, there are many fields that benefit from the validation check and I prefer not to bypass validation for the entire form.  As an aside, if validation were available to turn on/off on a field-by-field basis, that would be a valuable feature.
  • The Idle Time-Out setting in IIS for the "FormsAppPool" is set to 1440 minutes (24hrs).
  • We are using "Laserfiche Forms Professional Version 10.3.0.975"

 

Thanks in advance for any input, .... Steven.

 

LFF9309error.png
LFF9309error.png (316.87 KB)
0 0

Replies

replied on September 28, 2018
0 0
replied on February 7, 2019

Hi Steven,

I'm experiencing a similar issue with a customer. Were you able to resolve this issue / implement a work-around?

Thanks in advance.

Tim

0 0
replied on February 8, 2019

Hi Tim,

After a *lot* of troubleshooting, I was not able to identify the exact failure mode or a fix.  In the end, I chose to turn off backend validation for each of the Forms that had one of these drop-down/lookup fields.  It wasn't my preferred solution, but it did stop the errors.  I am hoping this was addressed in 10.4, but I haven't seen it listed in the release notes.

If you have any luck with other solutions, please keep me updated.

Good luck and best regards, ..... Steven.

1 0
replied on February 10, 2019

Hi Steven,

Thanks for the reply - I think I am going to have to resort to disabling Back-end Validation as well.

Will certainly let you know if I discover something else.

Kind regards,

Tim

0 0
replied on May 12, 2019

This issue has already been fixed with Forms 10.4. Please upgrade to Forms 10.4 or you can upgrade to Forms 10.4.1 which will be available soon.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.