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.