topic Re: Delete Records of Delta Table (A&D) in Data Management Questions

Delete Records of Delta Table (A&D)

PhuNguyen — Wed, 14 Jun 2017 09:36:07 GMT

Hello,

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

Thanks.

Re: Delete Records of Delta Table (A&D)

Asrujit_SenGupta — Wed, 14 Jun 2017 09:43:55 GMT

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.

Re: Delete Records of Delta Table (A&D)

PhuNguyen — Wed, 14 Jun 2017 09:53:10 GMT

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

Re: Delete Records of Delta Table (A&D)

PhuNguyen — Wed, 14 Jun 2017 09:58:18 GMT

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.

Re: Delete Records of Delta Table (A&D)

Asrujit_SenGupta — Wed, 14 Jun 2017 09:59:11 GMT

This is called a Partial Compress and can be expected in multiple scenarios:

1. There are editors editing when you ran the compress

2. Because of Orphaned connections

3. ArcGIS Server services are running

Geodatabase compression—Help | ArcGIS Desktop

In a fully compressed geodatabase, there are no rows in the delta tables and the state tree is trimmed back to zero. Performance improvement is greatest if the geodatabase is fully compressed. To achieve this, do the following:
Reconcile and post all outstanding changes in child versions to the DEFAULT version. As the geodatabase administrator, you can see in what order versions should be reconciled by default by opening the Reconcile Order subtab of the Versions tab on the Geodatabase Administration dialog box. See Version properties for information on the Reconcile Order subtab.
Delete the versions themselves after you have reconciled and posted edits.
Make sure no user is connected.
Perform the compression operation.

So try these steps and then let us know if there are still records left in the Delta Tables after the Compress operation.

Re: Delete Records of Delta Table (A&D)

Asrujit_SenGupta — Wed, 14 Jun 2017 10:03:41 GMT

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

Re: Delete Records of Delta Table (A&D)

PhuNguyen — Mon, 19 Jun 2017 23:51:36 GMT

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?

Re: Delete Records of Delta Table (A&D)

Asrujit_SenGupta — Tue, 20 Jun 2017 06:00:29 GMT

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.

Re: Delete Records of Delta Table (A&D)

PhuNguyen — Fri, 23 Jun 2017 09:30:20 GMT

Thanks Asrujit SenGupta.

I'll try.

Re: Delete Records of Delta Table (A&D)

PhuNguyen — Wed, 28 Jun 2017 07:48:21 GMT

I have solved this problem.

I used Repair Version Tables tool.

Thanks.

Re: Delete Records of Delta Table (A&D)

Asrujit_SenGupta — Wed, 28 Jun 2017 15:57:07 GMT

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