Delete Records of Delta Table (A&D)

1902
10
Jump to solution
06-14-2017 02:36 AM
PhuNguyen
New Contributor III

Hello,

Can i delete records of Delta table (A & D) in SQL Enterprise Geodatabase using SQL?

Thanks.

0 Kudos
1 Solution

Accepted Solutions
Asrujit_SenGupta
MVP Regular Contributor

I believe that you shared the results from the Diagnose tools. You can take a full DB backup and then execute the Repair tool. Repair Version Tables—Help | ArcGIS Desktop 

However, I'll recommend that if you are not completely sure, contact Esri Tech Support and they can guide you on a call and a quick screen sharing session.

View solution in original post

10 Replies
Asrujit_SenGupta
MVP Regular Contributor

No. You should not play with the Tables in a Geodatabase from the database end. Inconsistencies may occur later.

Maybe you can share the issue, which is leading you to delete the records from the Delta tables and can find a solution for that here.

PhuNguyen
New Contributor III

I used the Compress Geoprocessing Tool to compress a geodatabase but sde compress didn't empty delta table.

0 Kudos
PhuNguyen
New Contributor III

And I can't Full Compress because I can't delete version tree in enterprise geodatabase. It relate to my replication geodatabase, map services and feature services when I published.

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

Partial Compress is not an issue.

You can do the Full Compress later sometime by deciding upon a convenient downtime for that geodatabase. take a look at this link:

Acheiving Full Compress on Geodatabases with Existing Replicas | Support Services Blog 

PhuNguyen
New Contributor III

I used Partial Compress but not work. This is version diagnose:

74309 rows referencing nonexistent states found in PHUWAGISV1.SDE.a73 (PHUWAGISV1.SDE.FCDONGHOKHACHHANG)
74309 rows referencing nonexistent states found in PHUWAGISV1.SDE.d73 (PHUWAGISV1.SDE.FCDONGHOKHACHHANG)
Diagnose Tables: 99 multiversioned tables examined,
1 multiversioned tables had orphaned, duplicate, missing or redundant rows.

Can you help me next steps?

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

I believe that you shared the results from the Diagnose tools. You can take a full DB backup and then execute the Repair tool. Repair Version Tables—Help | ArcGIS Desktop 

However, I'll recommend that if you are not completely sure, contact Esri Tech Support and they can guide you on a call and a quick screen sharing session.

PhuNguyen
New Contributor III

Thanks Asrujit SenGupta.

I'll try.

0 Kudos
PhuNguyen
New Contributor III

I have solved this problem.

I used Repair Version Tables tool.

Thanks.

Asrujit_SenGupta
MVP Regular Contributor

Great! Close the thread if your question has been answered by marking the appropriate response as "Mark Correct"