Archived Forms Still Visible in DET & SQL Database After Sync

Developers
1

Hi everyone,

I’ve encountered an issue where archived forms in CommCare are still appearing in my SQL database even after several days have passed and multiple syncs have been performed.

Here are some details about the problem:

  1. When a form is archived in CommCare, I expect it to no longer appear in the SQL database, as it is no longer needed.
  2. The DET files in the directory seem to be duplicating for each sync, which might be causing some issues. Could this duplication be related to the problem?
  3. I noticed that there is no deleted column or metadata in my SQL table to indicate whether a form is archived.

My questions are:

  1. How can I configure the DET or CommCare export process to include the deleted property for archived forms?
  2. What’s the best way to ensure that archived forms are removed from the SQL database automatically during syncs?
  3. Could the DET file duplication issue be causing old, archived data to remain in the database? If so, how can I resolve this?

I’d appreciate any guidance or suggestions on how to fix this issue.

Best regards,
İzettin