Archived data showing in same MSSQL table for production data?

371
2
Jump to solution
09-30-2019 08:04 AM
MollyFoley
Regular Contributor

I'm having problems... I have enabled archiving on an SDE feature class so it could be used in Collector. Now when I got to MSSQL management studio and open up the table, it's showing all the archived data that was deleted. It was my understanding that data that exists should be in one table and data that did exist but was deleted should be in a separate archive table. What's going on? How do I fix this? Just to give you an idea...

This is the table with collected, existing data. It has 13 records:

 

This is what the same feature class looks like on the backend, in SQL management studio. Note, it returns 277 rows. I had a bunch of people testing the application in the field, so they created a bunch of dummy data and then deleted it via the Collector application. Yet is still shows in the backend table?:

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

I would think this is by design. It keeps all the records in the same table for querying in the future. The ArcGIS client only shows the "valid/active" data in the view. You can query previous edits/records based on time/dates.

https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/the-archive-process.htm

I will only create a separate table when you disable archiving: https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/disabling-archiving.htm

Geodatabase

--- George T.

View solution in original post

0 Kudos
2 Replies
George_Thompson
Esri Frequent Contributor

I would think this is by design. It keeps all the records in the same table for querying in the future. The ArcGIS client only shows the "valid/active" data in the view. You can query previous edits/records based on time/dates.

https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/the-archive-process.htm

I will only create a separate table when you disable archiving: https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/disabling-archiving.htm

Geodatabase

--- George T.
0 Kudos
MollyFoley
Regular Contributor

Thanks. Kind of sucks if you will never care about archived records. Maybe I can make a view in SQL Mgmt studio that only shows active records that updates everyday...

0 Kudos