topic Broken Tables in Data Management Questions

Broken Tables

RichNezelek — Mon, 07 Nov 2011 19:54:32 GMT

Aloha,

I seem to have a broken table somewhere in my Postgres database. I cannot see it using ArcCatalog but when I try to load a table with that name SDE thinks it already exists. Command line calls are a bit schizo too:

D:\>sdetable -o truncate -t h_radar ....
        Error: DBMS table not found (-37).
        Error: Unable to truncate table h_radar.

D:\>sdetable -o create -t h_radar ...
        Error: Table already exists (-62).
        Error: Cannot create table h_radar.

I tried digging out any rows in the SDE tables (sde_table_registry, sde_layers, etc) referencing this name but it's still hiding somewhere.

Thanks for any help,
Rich

Re: Broken Tables

VinceAngelo — Tue, 08 Nov 2011 10:00:00 GMT

Was this instance operating previously?

Does the table in question exist (as seen from pgAdmin III)?

The easiest way to fix registration issues is to create a nominal table via SQL, then use the
highest level where it was registered (probably ArcGIS) to delete it. Then you should be
able to rebuild from scratch (providing your schema is the same as the login user, etc...).

- V

Re: Broken Tables

RichNezelek — Tue, 08 Nov 2011 17:48:31 GMT

Thanks for the reply, Vince.

I finally found one last entry in sde.gdb_items. After dropping that row I was able to reload the layer using Catalog.