Error Reading Oid
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 hiring developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a 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 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 sr
message: [postgis-users] Null results from geocode_intersection, postgis 2.0.1, postgreSQL 9.1.6 Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] By the way, as the error occured when reading the table, did you check your table have a primary key ? (mine had integer one) Nicolas On 31 October 2012 17:17, Nicolas Ribot wrote: > Hi Mark, > > Just quickly tested ArcGIS 10.1 with Postgis and query layers: > > The table for the test comes from a http://gis.stackexchange.com/questions/104236/defining-oid-causes-query-layer-on-postgis-to-disappear-from-arcmap shapefile, loaded into postgis (WGS84). > I can define a query layer from it and display it in ArcGIS (ArcMap ArcInfo). > > The error you mentioned rise when trying to export this layer to a File GDB. > I then recreate the postgis table, forcing OIDS to be added to the > table (with oids clause) and the export went http://lists.osgeo.org/pipermail/postgis-users/2012-October/035607.html fine. > > So I understand that Query layers need to work on tables defined with > OIDS (which is not the default since several releases of PG) > > HTH > > Nicolas > > On 30 October 2012 14:38, Mark Volz wrote: >> Hello, >> >> >> I am still trying to figure out query layers and ArcGIS, I am getting an error when I try to open up a table: "Error reading OID from Table.... OID Column has null value." I noticed that when the table opens (blank) that there is an additional column called ESRI_OID. How can I add the missing column? >> >> Thanks >> >> >> >> >> Mark Volz >> GIS Specialist >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users at postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users Previous message: [postgis-users] Error reading OID from Table. OID Column has null value Next message: [postgis-users] Null results from geocode_intersection, postgis 2.0.1, postgreSQL 9.1.6 Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] More information about the postgis-users mailing list
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
Found '' at 81036527"? Next message: [ZODB-Dev] How to fix "CorruptedDataError: Error reading unknown oid. Found '' at 81036527"? Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] On Thu, Jul 14, 2011 at 10:12 AM, Andreas Jung wrote: > > > Jim Fulton wrote: >>> >>> 2011-07-14 13:36:22 INFO Z2 Shutting down >> >> That error message seems rather weird. WTF SIGINT? > > Likely caused during the Zope shutdown amd unrelated). I find this a bit unlikely, unless there was also a system shut down. FileStorage goes to great pains to prevent this sort of corruption. I don't think it's possible for a process shut down alone to cause this. I could imagine this sort of corruption if the system was shut down before data could be synced to physical disk. >> >> Use multi-zodb-check-refs with the -r option to get a database of >> reverse references. >> Use that do figure out what's refering to the missing object and fix >> that object(s) so that >> it no longer does. > > This gives me one reference: > > plone at web1:~/poskeyerror-check$ cat Out >>>> for x in refs.items(): print x > ... > ('1', ) That's sort of interesting. So my guess is that the missing object is a bucket and was the first bucket in the BTree, otherwise there'd also be a reference from the previous bucket. > > > I followed the documentation at > > http://pastebin.com/bL0CbBm2 I don't know where you got that. I didn't write it. :) > So what do I do with the oid 0xe7a850 in this case? Well, ideally, you'd update it to not include a reference to the broken object. > Trying to load the referenced object gives me of course a PosKey error: Dang. I would want it to give you a broken object. I think there might be a launchpad issue for that. Not sure if 3.10 has the fix (not sure what you're using). I wouldn't normally suggest what I'm about to suggest, but I think you have enough ZODB foo. :) I would try adding a new bucket with that oid. Maybe you can even stuff it in the connection cache to avoid committing it to the database. I'm not sure off hand what the steps required would be, but I think you can figure it out. Once you get an object in the cache, you should be able to load the container, modify it to not include the subobject, and commit it. You may also need to follow references to the container, using the reverse-references database to get a han