The reason I ask is because there were times where forms were being submitted but not showing up until restarting the Forms Routing Service. So I was wondering if they were saved to a temporary location before getting written to the Forms database.
Question
Question
Is there a temporary holding place that forms get stored to before before getting written to the db?
Answer
They are saved to the C:\ProgramData\Laserfiche Forms\RoutingError in xml, I am not sure how their folder scheme works, but you will see XML files pop in here if the service is unable to process new submissions but is accepting them still.
Replies
Are you saying that the submitted form doesn't show up when you go look directly at the tables?
Restarting the Forms Routing Service resolved this for us.
We became aware of the issue because we had one form that we noticed was not coming in. When submitting a test via a link on our website (like the public would do) it appeared to be submitted as usual. End event confirmation message etc. However, no evidence of the form in "Forms" (nothing showed up in the Monitor tab).
The first thing I did was to unpublish and republish the form. I was then able to submit a test form successfully, that showed up in Forms (in the Monitor tab).
However, the forms that had been submitted as tests, were nowhere to be seen. Found this posting and my coworker restarted the Forms Routing Service on the DMZ server (thanks John!). Voila! All the test forms (and some others that were queued up that we did not know were hanging) showed up.
Turns out we had some maintenance over the weekend, that could have impacted our Forms processing. The thought was possibly the DMZ server came back up before our Internal Forms server? Passing that along in case it is useful.
The great news is that no forms were lost, they do go to the Routing Error holding place described above in John C's post. They will continue on once the Routing Service is restarted. At least they did for us. :)
Thanks so much! This post was a great help!
Christine