AnsweredAssumed Answered

Feature Service - Table does not have an OID Field error

Question asked by lostpenan on Dec 25, 2019

I published a feature service from a view table in PostgreSQL to a standalone ArcGIS Server. I was able to view the feature layer in ArcGIS Online and was able query using the where clause. 

 

However, when I open the attribute table, I get strange behaviours. 

The feature count is wrong. The source layer has 914 features, but the attribute table shows 2,000. 

When I select a row and click Center on Selection, nothing happened.

feature count 

 

So, I checked the log file in ArcGIS Server Manager and saw this "Error: The table does not have an OID Field".

Log file

 

When I try to query at the REST endpoint using the Object ID, or return ID only or return count only, I get a "Unable to complete operation" error. The same "Error: The table does not have an OID Field" error appeared in the log file.

Query objectid

 

I have confirmed the feature layer has an ObjectID.

ObjectID

 

What did I miss? 

Outcomes