AnsweredAssumed Answered

Error reading OID from table

Question asked by csgeosol1 Champion on Dec 14, 2015
Latest reply on Nov 21, 2017 by CNA303@mt.gov_MTDNRC

I am trying to direct connect to a table on an MS SQLSERVER 2008 slice. I would like to create an x,y event layer to display on a web map using the JavaScript API. I am, however, receiving an error message when I attempt to open the table:

 

Error reading OID from table. Reading rows has been stopped. Check that the datasource is valid. OID mapped column has null value. The operation is not supported by this implementation.

 

From what I can tell, it's an issue with including the PK on the table:

 

 

Here's the data type:

 

idnum (PK, FK, numeric(18,0), not null)

 

I am unable to change structure - is there any way to work around this? My dev environment is using ArcGIS Server 10.2 - my production environment is 10.3 if this is a bug of some sorts in 10.2.

 

Any help is appreciated! Thanks!

Outcomes