Delete Records of Delta Table (A&D)

1230
10
Jump to solution
06-14-2017 02:36 AM
Highlighted
New Contributor III

Hello,

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

Thanks.

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
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
Highlighted
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.

Highlighted
New Contributor III

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

Reply
0 Kudos
Highlighted
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.

Reply
0 Kudos
Highlighted
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 

Highlighted
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?

Reply
0 Kudos
Highlighted
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

Highlighted
New Contributor III

Thanks Asrujit SenGupta.

I'll try.

Reply
0 Kudos
Highlighted
New Contributor III

I have solved this problem.

I used Repair Version Tables tool.

Thanks.

Highlighted
MVP Regular Contributor

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