November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Deleted submissions don't get removed from DDS

HSBallina
HSBallina
Vote:
 

Hi!

I'm having issues deleting form submissions from the DDS. Submissions are stored in the tblBigTable with a store name of 'FormData_guid'. I use the statement below for deleting submission data from the DDS.

SubmissionInfo is populated from SubmitActionResult.Data and formIdentity is created with new FormIdentity(formInfo.FormGuid, submissionInfo.FormLanguage). They seem to point to the right data, but apparently I'm missing something because the submission data (records) remain in the table and the DeleteSubmissionData doesn't throw any errors.

FormDataRepository.DeleteSubmissionData(formIdentity, new[] { submissionInfo.SubmissionId.ToString() });

Any ideas would be greatly appreciated :)

#219683
Apr 01, 2020 11:48
valdis - Apr 01, 2020 19:37
Are you able to run SQL Profiler and see what's been executed against storage?
HSBallina
HSBallina
Vote:
 

Yes, I've run Profiler and I can see statements and SP's being executed for storing the submission but no delete statement or any delete SP executed.

If I delete from the 'Form submissions' page in Epi I can see the delete SP being executed in the Profiler:

exec [dbo].[BigTableDeleteItem] @StoreId=2008
#220686
Apr 03, 2020 9:37
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.