AnsweredAssumed Answered

Registering a view with the geodatabase

Question asked by cbsmugla on May 21, 2019
Latest reply on Sep 17, 2020 by Colli

Hi,

İ created a view with "Create Database View tool" in arccatalog.

That view uses 2 nonspatial table and i do not have an objectid field in it.

So when i try to register that view table with "register with geodatabase tool" 

i make blank Object ID Filed box for creating a new ObjectID field.

 

http://desktop.arcgis.com/en/arcmap/10.6/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm
The table or view must contain a not null, unique, integer field to be used as an ObjectID field.

If you register a table, you can specify an existing field for the ObjectID. If you do not specify an existing field for the ObjectID when registering a table, ArcGIS will add an ObjectID field to the table.

But i get this error:

ERROR 999999: Error executing function.
The current table doesn't have an ArcGIS-maintained row_id column [42S22:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'OBJECTID'.]
Failed to execute (RegisterWithGeodatabase).

İ can not supply a objectid field for the tool because i create a view using LEFT OUTER JOİN from one to may related tables to get all data in view.
any suggestions.?
Arcgis Server Enterprise 10.6
MsSQL server 2016
ArcGis 10.6

Outcomes