topic Re: Registering a view with the geodatabase in ArcGIS Enterprise Questions

Registering a view with the geodatabase

MuglaCbs1 — Tue, 21 May 2019 08:58:17 GMT

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

Re: Registering a view with the geodatabase

George_Thompson — Tue, 21 May 2019 11:34:22 GMT

Geodatabase‌ - adding a broader audience

Re: Registering a view with the geodatabase

BugPie — Thu, 17 Sep 2020 18:15:02 GMT

poking around for a similar solution. Any chance there is one out there someone following can point me towards?

Re: Registering a view with the geodatabase

AdelaideZumwalt1 — Wed, 10 Mar 2021 23:42:00 GMT

Hello - were you able to figure this out? I am on SQL 2019 and ArcGIS Server 10.6. I'm getting the same error in ArcGIS Pro and ArcMap. My tables registered without issue. My view (which is just an INNER JOIN of the two tables) will not register.

ArcGIS Pro Error:

ERROR 160236: The operation is not supported by this implementation.
Failed to execute (RegisterWithGeodatabase).

https://pro.arcgis.com/en/pro-app/latest/tool-reference/tool-errors-and-warnings/160001-170000/tool-errors-and-warnings-160226-160250-160236.htm

I should also add, when I right click the View in Catalog and try to register it that way I get the following error:

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
The current table doesn't have an ArcGIS-maintained row_id column
Failed to execute (RegisterWithGeodatabase).

Re: Registering a view with the geodatabase

AdelaideZumwalt1 — Thu, 11 Mar 2021 15:59:25 GMT

So - in case anyone runs into the same thing, I figured it out. I needed to have both ObjectID fields from both tables visible in the view in order to register it.

Re: Registering a view with the geodatabase

RandyKreuziger1 — Wed, 03 Nov 2021 23:10:15 GMT

What if the table the view is based on is just a table with no ObjectID? That the situation I'm dealing with.

Re: Registering a view with the geodatabase

Oliver_Sandoval_e — Wed, 23 Oct 2024 22:02:16 GMT

Hey Randy! Were you able to figure this out? I have a similiar situation where i have a database view based off of a join of two tables without an objectID.

Re: Registering a view with the geodatabase

Bud — Thu, 31 Oct 2024 01:43:39 GMT

You need to generate a row number column in your query using SQL: