Skip to main content

"Missing" Submissions

Bill Rossi

v6.2

 

We have had multiple reports of users submitting a form, reaching our "Thank You" page after submitting the form, but the entries never existing in the database.

 

1) Is this possible? I know a lot of things are processed server-side.

2) Are there specific logs where we could see if there were database errors when submitting, or is there somewhere to look to see errored/failed sessions?

3) Is it possible to  INSERT into a database when the form is unloading? We can use something like that as another way to confirm if the users actually hit submit.

 

There's no strange configuration or anything, and we have considered Client-Side issues as well.

0

Comments

3 comments

Date Votes
  • Prajakta

    Hi Bill,

    I would recommend that you look into the frevvo submission repository to see if there were any submission errors. This documentation explains how to see the submission errors. If you see the submission in submission repository, then that means that users did click on the Submit button and submitted the form.

    Apart from that, you can also check all the frevvo log files around the time when users submitted these forms. You will see messages that start like this for the forms that were submitted:

    11:16:17.281 |-INFO [http-nio-8082-exec-2] [c.f.f.a.t.u.ActionTypeUtil] - doFormAction: Post Submit page: 

    If there were any errors during the submission, you should see messages starting like this in the logs:

    11:19:01.281 |-INFO [http-nio-8082-exec-2] [c.f.f.a.t.u.ActionTypeUtil] - doErrorAction: Post Submit page: 

    You can use business rules to insert data into the database at form.unload. But this approach would require a Stored Procedure to do that. Please see this KB article which explains how to do this.

     

    -Prajakta

    0
  • Bill Rossi

    Thanks. That helped!

    Are there any suggested settings to use for things like memory (like the setenv.bat I've seen mentioned for things like the heap), or CPU core counts/system memory for high traffic?

    Is there some sort of concurrent user count that would come into play? We have Public forms, and we can have any number of people actively in and filling out a form. They aren't signed in or anything. For example, if let's say 10 people have accessed the form and are in it, the 11th won't be able to submit?

    Or as long as the server has enough resources, Live Forms will scale and be able to handle dozens of requests from the outside with default configurations?

    0
  • Prajakta

    Hi Bill,

    Yes, as long as the server has enough resources, Live Forms will scale and be able to handle any number of requests from public forms.

    Thanks,

    Prajakta

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post