Error Reading Oid From Table Arcgis
Contents |
Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about arcmap error reading oid from table hiring developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask
Arcgis Oid Mapped Column Has Null Value
Question _ Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a error reading oid from table arcgis 10 minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Defining OID causes Query Layer on PostGIS to disappear from ArcMap? up vote 3
Arcgis Oid Field
down vote favorite I used query layer to load my layer from PostGIS and show it in ArcMap 10, I had two cases; if I defined the OID in the configuration of connection, there was no problem with the attribute table of the layer but my layer disappeared from the map. if I didn't define the OID, then the layer appeared in the map but when I try to open the attribute table of my layers the following error message occurs: Error reading OID form table. Reading rows has been stopped. Check that the datasource is valid. OID mapped column has null value ... in the table was empty. arcgis-desktop arcgis-10.0 postgis arcmap query-layer share|improve this question edited Jul 5 '14 at 4:42 PolyGeo♦ 39.2k1357144 asked Jul 5 '14 at 2:19 Yahia El Haddad 119112 1 What version of PostgreSQL are you using? What is the definition and content of the "OID" column? Does a spatial index exist on the geometry column? –Vince Jul 5 '14 at 3:50 - i use PostgresSQL 9.1. - i have a id in my table and i specify it in configuration connection. - what do you mean by a spatial index (my table in postgis contain a identifical column (id type:serial) and a geometry column (shape type:geometry) ) –Yahia El Haddad Jul 5 '14 at 9:30 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote the problem is solved , i described what I did exactly ,in first i change the type of the id from the serial to integer in the table , i tried to load it with defining the OID in querylayer's advanced option, but without defining the srid or the spatial reference ,the result was: the layer appear in the map & i can open my attribute table wothout any problem,but my new prbleme now is : where i define the srid & the spatial referenc
without it enabled. Please turn JavaScript back on and reload this page.All Places > ArcGIS Server with JavaScript API > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.AnsweredAssumed AnsweredError reading OID from tableQuestion asked by csgeosol1 on Dec 14, 2015Latest reply on Dec 15, 2015 by csgeosol1 Like • Show 0 Likes0 Comment • 1I 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 http://gis.stackexchange.com/questions/104236/defining-oid-causes-query-layer-on-postgis-to-disappear-from-arcmap 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 https://geonet.esri.com/thread/169740 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!No one else has this questionMark as assumed answeredOutcomesVisibility: ArcGIS Server with JavaScript API1917 ViewsLast modified on Dec 14, 2015 1:05 PMTags:sqlContent tagged with sqlqueryContent tagged with queryevent layerContent tagged with event layerpkContent tagged with pkprimary keyContent tagged with primary keysql connectionContent tagged with sql connectionnumeric data typeContent tagged with numeric data typeThis content has been marked as final. Show 1 comment1 ReplyNameEmail AddressWebsite AddressName(Required)Email Address(Required, will not be published)Website Addresscsgeosol1 Dec 15, 2015 2:45 PMMark CorrectCorrect AnswerUnless someone has a better idea, I'm just going to create a view in SQL with an integer data type for ID.Like • Show 0 Likes0 Actions Related ContentRetrieving data ...Recommended ContentUse Secured Service with Citizen Service Request ApplicationCommunity Weekly Discussion: How is GIS, geospatial analysis impacting and evolving disaster response?Attribute table Vs LayerList (open Attribute table)ArcGIS 10.5Count number of features in FeatureClasses GeoNet Home | Terms of Use | Privacy | Legal Follow Us EmailTwitterFacebookLinked InPinterestPinterestRSS Understanding GIS What is GIS? Live User Sites Map Book Gallery Video Library Company Information About Esri Careers Esri Insider Blog Esri International User Conference Services Professional Services Project Serv
messages) 1. 2012-10-31 Re: [postgis-users] Error reading OID error reading oid from Table. OID postgis-u Nicolas Ribot 2. 2012-10-31 Re: [postgis-users] Error reading OID from Table. OID postgis-u Nicolas Ribot 3. 2012-10-30 [postgis-users] Error reading OID from Table. OID Col postgis-u Mark Volz Configure | About | News | Addalist | SponsoredbyKoreLogic