Skip to main content

I am joining a data table with polygons, via a FeatureJoiner using a common value between the two datasets, both data sources come from a sql database. 
I am outputting a spatial table (the polygons, joined with the data) to another database.

I am encountering a strange issue when I try to open this data with ArcGIS Pro, I have never come across this before - The ESRI_OID does not exist. I was not aware this was required previously either.

This is causing various issues with viewing the data and publishing it, or joining it within ArcPro. I am getting this error on the esri GIS server when I try to view the polygons/or view the table. 


here is what the output data rows look like:


It is a very simple dataset with geometry. 

I’ve never had to make esri_oids before in any of my workbenches, does anyone have any insight to what might be going wrong? 
 

I think you are writing to SDE? Do you use the SDE writer?


I think you are writing to SDE? Do you use the SDE writer?

I think this was the issue! I was writing to the sde using a spatial sql writer, when I should have been using a SDE writer. Thank you!


Cheers!


Reply