topic Blank/Empty Attribute table in ArcMap on ST_GEOMETRY table in Data Management Questions

Blank/Empty Attribute table in ArcMap on ST_GEOMETRY table

WendyTurner — Tue, 20 Sep 2011 15:00:42 GMT

I have added ST_GEOMETRY columns to a few tables in my Oracle 10g database, and populated the geometry using SQL. Everything in Oracle looks good when performing selections using ST functions. I registered the table with sdelayer - o register...and everything looks fine. In ArcGIS 10, I can add the layers to ArcMap, view, identify, pan. All works as expected. BUT, when I open the attribute table, it is blank. No records at all.
When I did my "register", i chose -C USER with the primary key field of the table. If I look in the SDE metadata tables, it shows my PK field as the rowid field.
I must be missing something, but I have double checked everything and I added/populated/registered the tables as described in the Esri Help.
Any tips for troubleshooting are appreciated!

ArcSDE 10
Oracle 10.2.0.4

Wendy

Re: Blank/Empty Attribute table in ArcMap on ST_GEOMETRY table

WendyTurner — Tue, 20 Sep 2011 17:43:51 GMT

Ok, figured out my original problem. The rowid field i was using, even though SDE was ok with it (number, not null); ArcGIS didn't like it. If I look in the sde.column_registry, it is showing the decimal_digits = 10 for my rowid. I am guessing ArcGIS doesn't like that. I can't seem to figure out how to get rid of the entries in the column_registry table...sdelayer only gets rid of the layer info. I can't drop the table and start over. I did alter the Oracle table to make the rowid field a number(38), so ArcGIS should be happy now.

Re: Blank/Empty Attribute table in ArcMap on ST_GEOMETRY table

VinceAngelo — Tue, 20 Sep 2011 19:50:25 GMT

While it might seem like ArcSDE was okay with it, NUMBER is not a valid rowid column type,
since it maps to SE_FLOAT64_TYPE.

You can't remove entries in the column registry without risking your ArcSDE instance, but
you may be able to update the row to contain the modified type information (but this should
be done under the guidance of Tech Support).

- V