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

Question

Question

DBUpdateConcurrency exception after Save and Resume

asked on January 22, 2018

Hi,

We are experiencing an error on submission of a Form.  The form submits fine and the Thank You page is displayed, but in the event log and in the bp_instance_errors table in the Forms database there is a DBUpdateConcurrencyException message: Store update, insert or delete statement affected an unexpected number of rows (0).

This is intermittent and only happens after a Save and Resume.  The problem is that the dataset seems to disappear from the cf_submissions table - I was hoping that maybe the draft data would remain and be recoverable.

Is this something that anyone else has seen or could suggest where i look next to identify the source of the problem ? 

From investigations so far the error seems to be suggesting that there may be multiple versions of the form open (hence a possible conflict due to different data in memory for the same form).  I don't think this is the case, but even if it was shouldn't an old copy of the data survive in the database ?

 

thanks,

Ian

0 0

Replies

replied on January 23, 2018

Hi Ian,

Can you open a support case on the issue? We need the detailed error log and backup of database to identify the issue.

As for the draft data, the field values are saved in [cf_bp_data] table but if the entry in cf_submission is gone, I don't think the field value could remain.

0 0
replied on January 24, 2018

Thanks Rui - i'll raise a case.

0 0
replied on May 23

Was there a resolution found for this issue?

0 0
replied on May 25

We haven't seen this issue reported for some time; are you still able to reproduce it in recent version of Forms? If so, what is the detailed error message?

0 0
replied on October 12, 2021

Does Save and Resume mean Save as Draft, and re-opening a draft to submit?

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

Sign in to reply to this post.