FeatureClass registered but not visible

[SIT_AGSM_VERONA_SPAAGSM_VERONA]

Hi all... I'm trying to create a new FeatureClass on a DB Postgresql 11.12 via ArcgisPro 3.0.6 but the geoprocessing says that the name already exists.

In the catalog pane I cannot see it but if I query the sde_table_registry table, that name is present.

It's present also in sde_layers and sde_geometry_columns but not in sde_column_registry neither in gdb_items.

I don't want to change the name because there are others apps that refers to that name.

How can I reset the system tables in order to permit to create the feature class? Or how can I make it visible in the catalog pane in order to delete and recreate it?

Someone can help me?

Thanks a lot!

Matteo

[George_Thompson · Accepted solution]

Sounds like you have an orphaned record.

I would try and create a blank table with the exact same name in the same schema (i.e. GIS / DATA / whatever you have). It does not need to have any records or the same fields, just a table. Then refresh the connection in Pro. If you see the "blank table" delete it. It should remove it from all the system tables.

I have seen this with ArcMap and ArcGIS Pro over the years.

[SIT_AGSM_VERONA_SPAAGSM_VERONA]

Thanks a lot, it worked! you saved my day!!

Matteo

[George_Thompson]

Glad to hear that worked!

Please mark my response as the solution so others can find it in the future.