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

Question

Question

Feature request: Poll RoutingError on idle, not just on startup

asked on October 22, 2020

Per this post, the Forms Routing Service processes any outstanding files in \RoutingError on startup. If these wayward forms were processed as soon as the Routing Service went idle, it'd probably never be noticed.

If instead, for example, 45 of these accumulated over the course of a month or so, then were all processed as new submissions after an unexpected server restart, the data on those forms would likely be badly out of date, and in many cases would already have been entered on duplicate forms.

0 0

Replies

replied on October 22, 2020 Show version history

The forms cannot be processed while the routing service is idle, that's why they accumulate and are run once the service is started up again.

EDIT: Sorry, after discussing with a team member, I may have misinterpreted your post. When the server is down (not idle), it obviously cannot process submissions. We do have plans to improve some of this in Forms 11 where we can process the error submissions without restarting the service. 

0 0
replied on April 14, 2021

Can you elaborate on how this has changed in LF11? 

The folder seems to have moved from ProgramData\Laserfiche Forms\RoutingError to ProgramData\Laserfiche\Forms\RoutingError, and I haven't seen anything accumulating there.

Instead, submission errors appear to accumulate in InvalidSubmissions. So far, everything I've found here has coincided with the approximate time of a SQL or Forms server restart, and moving the XML file from InvalidSubmissions to the corresponding folder under RoutingError has ended up processing the submission within a few seconds without further issue.

I'm just trying to understand how these files are supposed to work, so that I can adjust the notifications we have in place to catch them. At this point, I'm not sure how much of what we're observing is caused by the routing service instability we're dealing with.

0 0
replied on April 14, 2021

You are correct on RoutingError folder that it is moved to ProgramData\Laserfiche\Forms\RoutingError.

 

In Forms 11, we make some changes to RoutingError submissions:

1. First of all, the RoutingError name is misleading, we actually use the folder to store submissions that IIS received in first hand. 

2. Further more, we've add a new db table submission_recovery in Forms database, that's now where unprocessed submissions are located, Forms web server will scan RoutingError folder regularly and move submissions that does not occur in Forms database in submission_recovery table.

3. Routing will read from submission_recovery table and try to process submissions inside it when it is idle so that you do not need to restart Routing Service to do recovery.

4. About InvalidSubmissions, we put submissions that occurred unexpected errors while processing in InvalidSubmissions folder. In our experience, these are mostly unrecoverable items such as invalid xmls saved. Routing does not try to recover items inside InvalidSubmissions folder. While in your case, you put them in RoutingError and routing processed them successfully, because they are acutally just unlucky valid submissions processed at a bad time.

1 0
replied on April 15, 2021

Thanks for the info; this sounds like a good change!

Sounds like I still need to monitor the InvalidSubmissions folder, though. Some of the ones I found were initial form submissions, which I'm sure would have eventually been reentered. And since this folder doesn't get reprocessed, it avoids the problem that sparks my original post.

The others stalled a user task with the message "This task has been locked because a submission has already occurred but has not been processed."

Assuming that there will always be some sort of error condition from which Forms can't automatically recover a submission, I'd really like some built-in notification that a submission was lost, so I can at least attempt to parse out enough information to have someone contact the user and let them know their form needs to be resubmitted.

1 0
replied on April 16, 2021 Show version history

I think that is a possible place we can have some enhancements.

I noticed that you say

"So far, everything I've found here has coincided with the approximate time of a SQL or Forms server restart". 

Do you still have eventlogs for that time? It would be helpful if you can share error logs when submissions moved to InvalidSubmissions, so that we can probably handle the situation.

0 0
replied on April 16, 2021

I do. If you can have someone send me contact info, I'll happily share what we have.

1 0
replied on April 16, 2021

A support case was opened up through your SP so we can collect the files and further investigate the issue. Case 216586

0 0
replied on January 8, 2023

This has been improved with Forms 11 Update 3.  The submission files will no longer be moved to InvalidSubmission folder when stop MSSQL then start MSSQL after a while

You can see other changes of Forms 11 Update 3 from  https://support.laserfiche.com/kb/1014413/list-of-changes-for-laserfiche-forms-11-update-3 and get Forms 11 Update 3 from Laserfiche 11 package  https://support.laserfiche.com/kb/1014263/software-versions-and-fixes-included-in-the-laserfiche-11-download-package

 

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

Sign in to reply to this post.