topic Re: The current table doesnt have an ArcSDE-maintained rowid column. in Data Management Questions

The current table doesnt have an ArcSDE-maintained rowid column.

LakshmananVenkatesan — Mon, 19 May 2014 14:49:58 GMT

Hi All,

I am in process of upgrading my project (Arcobjects) code from ArcGIS 10 to 10.2. During this process one my functionality where data (geometry) is inserted to SDE Feature class (not registered as versioned) has been failed with below message The current table does not have an SDE-maintained row_id column [SCHEMA.TABLE_1]. This was perfectly working in 10.0.

Only change I have done during the migration process is Connection property INSTANCE name has been changed.
I have could able to connect

Database : Oracle 10.2.2 running on Linux box.

                                    featureBuffer.set_Value(insertUserIndex, insertUser);
                                    featureBuffer.set_Value(index, "Type1");
                                    featureBuffer.set_Value(versionIndex, "1");
                                    featureBuffer.set_Value(nameIndex, shapeName);
                                    featureBuffer.set_Value(originalSourceIndex, "Project");
                                    featureBuffer.set_Value(sourceIndex, "Project");

                                    featureBuffer.set_Value(insertDateIndex, DateTime.Now);
                                    id = Convert.ToInt64(featureCursor.InsertFeature(featureBuffer)); // Code fails here.

Re: The current table doesnt have an ArcSDE-maintained rowid column.

VinceAngelo — Mon, 19 May 2014 15:02:07 GMT

Your post doesn't give enough information for us to help you.

Which database were you using? What are you using now? (complete description
needed, e.g., "Oracle 11.2.0.2.2" or "SQL-Server 2008 R2 SP1")

Did you leave the geodatabase at 10.0, or did you port that as well?

What does 'sdetable -o describe' report on the table?

- V

Re: The current table doesnt have an ArcSDE-maintained rowid column.

LakshmananVenkatesan — Mon, 19 May 2014 15:10:44 GMT

Vince:

I am only migrating the source code to ArcGIS 10.2. The underlying database is same.
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit.

I will provide you sdetable report shortly.

FYI,
a) when I insert a record using ArcGIS 10.0, it was successful.
b) For code migration I have changed instance property name in IpropertySet parameter.

Re: The current table doesnt have an ArcSDE-maintained rowid column.

LakshmananVenkatesan — Mon, 19 May 2014 17:54:58 GMT

ArcSDE 10.0 for Oracle10g Build 2004 Fri Jan 13 11:45:40 2012
Layer    Administration Utility
-----------------------------------------------------
Layer Description ....: Created by layer gen
Table Owner ..........: PROJECT_SCHEMA
Table Name ...........: TABLE1_
Spatial Column .......: SHAPE
Layer Id .............: 2
SRID .................: 2
Auth SRID.............: 2
Minimum Shape Id .....: 1
Offset ...............:
falsex:       -180.000000
falsey:        -90.000000
System Units .........:    1000000.000000
Z Offset..............:    -100000.000000
Z Units ..............:      10000.000000
Measure Offset .......:    -100000.000000
Measure Units ........:      10000.000000
XY Cluster Tolerance .:          0.0
Z Cluster Tolerance .:          0.0
M Cluster Tolerance .:          0.0
Spatial Index ........:
parameter:    SPIDX_GRID,GRID0=0.4163038,FULL
exist:        Yes
array form:   0.4163038,0,0
Layer Envelope .......:
minx:      -155.92042,        miny:       -27.33888
maxx:        25.56671,        maxy:        73.00019
Entities .............: na3+M
Layer Type ...........: Extended SQL Type/ST_GEOMETRY
Creation Date ........: Sun Sep 25 20:13:28 2011
I/O Mode .............: NORMAL
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.01745329251994
33]]

Layer Configuration ..: DEFAULTS

Re: The current table doesnt have an ArcSDE-maintained rowid column.

VinceAngelo — Mon, 19 May 2014 18:13:12 GMT

'sdetable -o describe' would include the rowid type, and 'sdetable -o describe_reg'
gives the full monty. The above is 'sdelayer' output.

- V

Re: The current table doesnt have an ArcSDE-maintained rowid column.

LakshmananVenkatesan — Mon, 19 May 2014 18:23:48 GMT

OK. I need someone else help to get this info. Here it is. Let me know if you need additional details

ArcSDE 10.0 for Oracle10g Build 2004 Fri Jan 13 11:45:40 2012
Attribute        Administration Utility
-----------------------------------------------------

Created by layer gen
----------------------------------------------------------------
Table Owner            : PROJECT_SCHEMA
Table Name             : TABLE1_
Registration Id        : 7
Row ID Column          : ID
Row ID Column Type     : User Maintained
Row Lock               :
Minimum Row ID         :
Dependent Objects      : Layer
Registration Date      : Sun Sep 25 20:13:28 2011
Config. Keyword        : DEFAULTS
User Privileges        : SELECT, UPDATE, INSERT, DELETE
Visibility             : Visible

Re: The current table doesnt have an ArcSDE-maintained rowid column.

LakshmananVenkatesan — Mon, 19 May 2014 20:42:05 GMT

Vince - Any more info required?.

Re: The current table doesnt have an ArcSDE-maintained rowid column.

VinceAngelo — Mon, 19 May 2014 22:41:10 GMT

Row ID Column Type : User Maintained

This pretty much tells the tale. The error message is informative and correct --
ArcGIS cannot insert into tables that don't have an SDE-set rowid column.

- V

Re: The current table doesnt have an ArcSDE-maintained rowid column.

LakshmananVenkatesan — Tue, 20 May 2014 01:31:43 GMT

Ok. Now, how come ArcGIS 10.0 version can able to insert a record?. What has changed in 10.2?
Do you have any information on this?. I will talk to SDE admin to see if I can set row-id column.