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

Question

Question

Form Submission with no trace of submitted form

asked on December 29, 2016

I have an instance where a user submitted a form,   they got to the thank you page that states that the form was submitted,  but the message Your submission cannot be previewed at this time is displayed.    I have looked through the event viewer in the Windows Logs - Application and System,  I also looked through the Applications and Services Logs - LFForms with no trace of errors or warnings.

I cannot find the document in the repository.

I can find no trace of the submission.

Any suggestions where else to look for cause.

 

Attached is screenshot of thank you page.

 

 

 

adams online listing.JPG
0 0

Replies

replied on December 29, 2016

Hi Michael,

Have you checked whether the forms routing service is running? You can go to "local services" in your windows explorer to see a list of services that are running by making sure that their status indicate "started". 

 

 

Forms.png
Forms.png (81.93 KB)
0 0
replied on December 29, 2016

Yes routing service is running,   i have had several forms submitted before and after the one in question.   So i know the process is working,  i just can not find any trace of this submission.   

 

0 0
replied on December 29, 2016

Is this happening with multiple processes or just 1. How large are the forms that are being submitted that are having the problem?

0 0
replied on December 29, 2016

Check the Event Viewer to see if there are any errors. It is possible if the error is generated before the Form Server generates an Instance that this is why you are not finding it.

 

0 0
replied on December 29, 2016

Blake,

Just one process that I am aware of.  Forms are very small,  one of the smaller forms i have published to the public.    

 

It is very critical since it is a tax listing form.

 

Steve,

I have checked through all the event Viewer,  there are no errors,  I tend to agree with your statement if the error is generated before the Form Server generates an Instance then no error is logged.

 

The problem with this is that the citizen is told that the form was submitted,    So if this is the case,  is there a way to detect the problem in the thank you message to clearly state to citizen that the form failed to submit.

0 0
replied on December 29, 2016

Do you have custom JavaScript on the form?

0 0
replied on December 29, 2016

Yes,    fortunately this form was entered by internal user,  so we recreated the process of submitting with same data and it submitted fine,  so i don't see any issues with process or logic.

I am putting text in the thank you message that if form preview does not show then there may have been an issue with submitting form.   But that is not great solution,  alot of users will not even read the text, they will only see Form has been submitted and stop reading.    

 

0 0
replied on December 29, 2016

What version of Forms are you using?

0 0
replied on December 29, 2016

Did the form show up Under the logged in users History Tab in the Task Inbox?

0 0
replied on December 29, 2016

The user was not logged in,  they submitted through the public portal link.    

0 0
replied on December 29, 2016

Using Laserfiche Forms Version 10.1.0.619

 

0 0
replied on December 29, 2016

Are you able to check with the users and see what browser and version they were using?

0 0
replied on December 29, 2016

the form is question was retried on the same machine,  with same browser, and submitted successfully.   Browser was Chrome.

I am pretty confident it is not a problem with the form or process,  about 100 submitted in the past few days,  about 20 since this one was attempted with no problems.   

 

 

 

0 0
replied on December 29, 2016 Show version history

An additional place to look might be the folder C:\Program Files\Laserfiche\Laserfiche Forms\Forms\RoutingError to see if the submission was registered there.

One possibility, since you mention that these were submitted via the Public Portal from unauthenticated users, is that they may have been made with an unexpected browser, for instance an older version of IE or some particular combination of mobile device and mobile browser. You can add the following to the form to get additional information of this sort:

1. Add a new single-line field/variable to the starting form. Give it the name and label "Browser" and assign to it the CSS class "browser". Do not mark it as read-only.

2. Add the following to the custom CSS, to hide the field so no one sees/modifies it:

.browser {display: none;}

3. Add the following to the custom JavaScript, to populate this field with details of the browser in use:

$(document).ready(function() {$(.browser input').val(navigator.userAgent)});

This can be merged with existing JavaScript code but there would be no harm in adding it directly, outside of everything else.

Then when reviewing submissions moving forward, you can look for the Browser variable which will include the user agent string of their browser and operating system. It can be interpreted at sites like useragentstring.com. You might find a pattern there.

Note: It should be said, this won't give the browser data for the completed submissions, only new ones made after the change.

Hope this helps!

0 0
replied on December 29, 2016

The message "Your submission can not be viewed at this time" may appear if user submit a form but the Laserfiche Forms Routing Service doesn't process it in time especially if the workload for the Laserfiche Forms Routing Service is high. How many concurrent submissions there was when user submit that form. You can check from the instances table to see whether the submission was processed later. If the submission was not processed in time for some reason, the submission should be saved under C:\ProgramData\Laserfiche Forms\RoutingError, so please check whether there is any XML file. And restart the Laserfiche Forms Routing Service can recovery these submissions.

0 0
replied on December 30, 2016

There is nothing in the RoutingError folder,   but this is great information to have.

 

James,

It was an unauthenticated user,  but it was done on a internal computer,  the submission was retried on same machine with the same browser and submitted correctly.  so the browser is not the issue.

 

This may be more than just a one time occurence,  I am being told of others that have submitted but there is no trace of the submission.

 


 

 

 

0 0
replied on January 3, 2017 Show version history

If you check from the instances list of the process, can you find the instance submitted by that user? It may just because it is time consuming to process the submission and generate the submitted form but the submission is actually be processed later.

0 0
replied on January 3, 2017 Show version history

I have had one of my developers sitting with the employee who keys the requests,  so i can know exactly when a form is submitted and it not showing up.   It logged the following warning in the event viewer.

 

You do not have sufficient rights to view this page. [LFF8-NoAuthority]

Details:
URL: /Forms/Form/showformsubmission/6c328cfd-df48-4682-83a3-2665ce8cdf23/cbfa5992-603d-426e-91fc-0b2dfb86e0a4
Error: NoAuthority
Date: 1/3/2017 3:08:23 PM (Eastern Standard Time)
HTTP Status Code: 403
User: 
IP: 10.0.5.116
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36

Other:
Authorization key cannot be found: ShowFormSubmission

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: You do not have sufficient rights to view this page. [LFF8-NoAuthority]
   at E_Forms.Controllers.FormController.VerifySubmitAuth(String authKey, String submitAuthKey, CommonIdentity identity, Dictionary`2& formdata, Int32 MaxAttempts)

 

There is nothing in the instances list or the routing errors folder,  the thank you page shows and says form was submitted but does not load a image of the submission below.

 

 

This is what is logged in the iis log file

 

2017-01-03 20:08:23 172.20.20.16 GET /Forms/Form/showformsubmission/6c328cfd-df48-4682-83a3-2665ce8cdf23/cbfa5992-603d-426e-91fc-0b2dfb86e0a4 - 80 - 10.0.5.116 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/55.0.2883.87+Safari/537.36 http://forms.brunswickcountync.gov/Forms/Form/Submit 403 0 0 40828

 

This user has been keying forms all day with no problem,  so it is intermittent.  same data was submitted 2 minutes later and worked no problem.  

 

Have had 119 submissions today with 11 warning of this type.

0 0
replied on January 5, 2017 Show version history

Is the Laserfiche Routing Engine located on a different machine as the IIS Host Forms Application?  One possible explanation is that the submissions are currently located in the routing error folder on the IIS machine.   How Forms normally works is that all submissions are saved locally on the machine before the thank you page is loaded.  If the file cannot be saved locally then the thank you page is not supposed to show so the person submitting doesn't get a false positive.  A message is then sent to Routing engine machine with the submission contents.  After the routing engine receives the data a message is sent back to the IIS machine to delete the file locally.

 

If this the case then you need to manually copy the files from the IIS machine to the Routing engine machine Routing error folder and they will be processed.

0 0
replied on January 5, 2017

I have 2 forms server,  one internal and one external.   The internal is the primary.   This problem is occurring from submissions for the external forms server.   I am not sure what you mean by Is the Laserfiche Routing Engine located on a different machine as the IIS Host Forms Application?   Does the external use the routing engine of the internal or does each server runs its own routing engine.   If each uses its own routing engine then routing engine and iis host is on same machine.

I have checked the RoutingError folder on both machines and nothing in either.

Where locally does the forms save submissions?

Also from my previous post the url logged is 

URL: /Forms/Form/showformsubmission/6c328cfd-df48-4682-83a3-2665ce8cdf23/cbfa5992-603d-426e-91fc-0b2dfb86e0a4 with the error
Authorization key cannot be found: ShowFormSubmission

This authorization key (6c328cfd-df48-4682-83a3-2665ce8cdf23/cbfa5992-603d-426e-91fc-0b2dfb86e0a4) exists in the cf_sessions table with a last_active value of 1/3/2017 3:05:26 PM,  couple minutes before event viewer error log entry.

Something else i have found is that the authentication on the forms application directory has anonymous, forms and windows enabled.   Since this is a public facing forms server does forms and windows need to be enabled?

 

 

 

 

 

 

0 0
replied on January 5, 2017

Hi Michael,

A support case has been opened for you and we will be working with your VAR moving forward.

This thread will be updated again after we have found a resolution.

Regards

0 0
replied on September 28, 2017

What was the resolution here?

0 0
replied on October 3, 2017

Jeremy,

 

LF had determined that the issue appeared to be caused from communication drops between the external LF forms server and the Forms routing service on the internal LF server.

I did find all the missing forms in the C:\ProgramData\Laserfiche Forms\RoutingError folder.   I copied the xml files to the internal forms server and restarted the service and most processed successfully,  the ones that did not process i found had been submitted with attachements.  I then copied them back and restarted the service on the public forms server and they processed.   Never did get an answer why copying them back worked the second time.   

The issue has only occurred a couple of times since,   we did create a powershell script that monitors the C:\ProgramData\Laserfiche Forms\RoutingError folder and sends an email to the dev team if it finds a file not processed.   

Bottom line is we never really found an answer to what caused the communication error.

 

   

 

 

 

1 0
replied on August 2, 2022 Show version history

Michael, THANK YOU for this idea! We have been having random issues with this and while resetting the server solves the problem, we needed a way to regain confidence it was running without having to check. This is going to be a great solution for us. So simple and effective! Thank you!!

0 0
replied on January 5, 2017

I am not very good at the troubleshooting, HOWEVER i had this very same issue when I upgraded to forms 10. We have hundreds of forms go missing, we opened a case, we send screenshots, and went round and round. 

The team at laserfiche had us put it in debug mode, and all of a sudden all my missing forms started submitting, and appeared in laserfiche, and we have had no problems since.

There is no reason for our failure that we could replicate, the same form submitted 10 times, would fail some times. Ours was not limited to one form, it would happen on various forms, at various times. 

Might help you too.

0 0
replied on January 5, 2017

Thanks laura,

How did you put it in debug mode?

0 0
replied on January 5, 2017

Hi Laura,

In reviewing the support case that you had opened, we believe that what actually resolved the matter for you was just restarting the Forms Routing service. The steps about putting Forms into debug mode just changes the amount of information it logs into the Windows event viewer and wouldn't impact the issue. However, after you make this change, it needed the Forms Routing service to be restarted and that should have been what actually resolved the matter.

Regards

1 0
replied on January 5, 2017

in the sql datbase we changed

 cf_options table and change the value of the "LogPolicyThreshold" from the present value to "Debug"

 

Alexander, I feel you may have your records show it was restarting the service, however we restarted the service many times, restarted our server, and it was not resolving the problem. Right after putting it in debug mode, forms appeared, we had not restarted anything. It was the most baffling things.

 

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

Sign in to reply to this post.