topic Re: Troubles with feature class table in ArcGIS Enterprise Questions

Troubles with feature class table

MonicaRuiz — Fri, 23 Sep 2016 13:13:28 GMT

I am having troubles with a feature class table. I have deleted every record from ArcCatalog but in Oracle there are still more than 7 thousand records.

There are two versions:sde.default and another one called yte.mobile. And the FC was created with the user "OW".

Let me explain that I didn't install and configure this geodatabase.... just trying to solve problems

Can anyone help me how to resolve this?

Re: Troubles with feature class table

JakeSkinner — Fri, 23 Sep 2016 15:08:51 GMT

Hi Monica,

If your feature class is registered as versioned, adds and deletes are stored in the delta tables (A & D). You will need to compress your database to have the edits added or removed from the base table. Here is a helpful article that discusses how to compress your database:

How To: Compress a versioned database to state 0

Re: Troubles with feature class table

RandyKreuziger — Tue, 27 Sep 2016 15:36:36 GMT

How are you deleting the records. I'm confused. You can't delete records in a feature class or table via ArcCatalog. You have to bring it into an ArcMap edit session unless you're doing it through a geoprocessing tool.

Re: Troubles with feature class table

MonicaRuiz — Thu, 29 Sep 2016 12:33:36 GMT

Hi Randy, I deleted features from the geoprocessing tool (Data Management Tools -> Features -> Delete features) from both versions, after that I've compressed the geodatabase but the differences remains.

Re: Troubles with feature class table

MonicaRuiz — Thu, 29 Sep 2016 12:33:53 GMT

Hi Jake, It did not work . I compressed the geodatabase but I am still having differences between the table from TOAD and what I can see from ArcCatalog. I have two versions: default and one more. I deleted features from the geoprocessing tool (Data Management Tools -> Features -> Delete features) from both versions, after that I've compressed the geodatabase but the differences remains.

Re: Troubles with feature class table

BlakeTerhune — Thu, 29 Sep 2016 19:00:25 GMT

Compress is ultimately what should solve this problem. However, there are factors that might prevent you from getting a full compress (or at least compressing the feature class you are concerned with). Like the help document says, be sure you have reconciled/posted (and even deleted) all versions except sde.default and disconnected all users; then run the compress.

Managing Data‌

Re: Troubles with feature class table

MonicaRuiz — Thu, 29 Sep 2016 19:06:43 GMT

How can I realize that the other version is deleted? Which geoprocessing tool should I run to delete any other version?

Re: Troubles with feature class table

BlakeTerhune — Thu, 29 Sep 2016 19:17:54 GMT

Delete Version—Help | ArcGIS for Desktop

Re: Troubles with feature class table

MonicaRuiz — Thu, 29 Sep 2016 19:50:48 GMT

Blake, I deleted de mobile version. After that I disconnected every user and then runned the compress. Now I have consistent data. But, what if I need that version? Should I created again? And do this every week (for example)?

Re: Troubles with feature class table

BlakeTerhune — Thu, 29 Sep 2016 20:27:52 GMT

That's a strategy you'll have to discuss with your users and decide on. Every organization is a little different. This document might be helpful as a starting place for you.

Using Python scripting to batch reconcile and post versions—ArcGIS Help | ArcGIS for Desktop

You don't necessarily need to delete the version, just make sure it is reconciled and posted. Deleting the version is the way to be absolutely sure everything is compressed.

Re: Troubles with feature class table

LesHampton — Mon, 10 Oct 2016 13:33:04 GMT

I don't think Compressing is going to solve your problem. If you have a versioned Database you need to " Reconcile" and "Post" your version to see the results in the other version.