Delete Records of Delta Table (A&D)

[PhuNguyen]

Hello,

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

Thanks.

[Asrujit_SenGupta]

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]

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

[PhuNguyen]

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.

[Asrujit_SenGupta]

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]

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?

[Asrujit_SenGupta · Accepted solution]

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]

Thanks Asrujit SenGupta.

I'll try.

[PhuNguyen]

I have solved this problem.

I used Repair Version Tables tool.

Thanks.

[Asrujit_SenGupta]

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