4

I'm running a PostgreSQL database on my local machine and have set up an connection to it from ArcMap 10.1. I can see all of my tables in the Catalog pane. There is one table that I cannot seem to load into ArcMap. When I drag it onto the map I get the error "Error Opening Feature Class, Attribute Column Not Found"

enter image description here

Other feature classes in the same database load without incident. The feature class is a relatively (~40 rows) small with point geometry. It loads without any problems in QGIS. Also, I can load the feature class from a query layer using SELECT * FROM [Feature Class].

So what's going on with ArcMap that I can't just load the FC straight in like I can with the other FCs in the database?

I'm running ArcMap 10.1, on a Windows 7 machine, with NO instance of ArcServer, PostgreSQL is running locally. I have the Postgres client files installed.

Thanks!

---------- EDIT ----------

The table has 14 columns: enter image description here

The spatial reference is 32613 (WGS 84 NAD 83 Zone 13N) and the permissions are no different than others in the database. Typically, I just drag the tables in from the Catalog pane to load them into ArcMap - perhaps Arc is building a query layer in the background, I don't know. However, when I do the drag-and-drop with this error it won't load. When I create a query layer using the "Add Query Layer..." dialog from the File menu it at least loads the points, however, I can't do any kind of selecting and the attribute table is empty.

An example of the columns for a table that I can simply drag-and-drop: enter image description here

|improve this question
  • 1
    I think in order to troubleshoot this, we need more information about this table. It really isn't a featureclass until it is in ArcMap, but that is semantics. What attributes does it have? Spatial reference? What is different compared to the other spatial tables that load in correctly? Are permissions different somehow? Basically, you need to provide these sorts of comparisons to figure out what is causing the behavior. A last bit... Since it is a table from PostgreSQL, isn't a Query Layer the default way of loading a spatial table in, when not using ArcServer, SDE or the like? – Get Spatial Sep 30 '13 at 16:45
  • Thank you for adding that information. For comparison purposes, would you add the same sort of screenshot, but for a layer that you are able to just drag and drop in with no difficulties? – Get Spatial Sep 30 '13 at 17:56
8

You might want to try dropping the column "Discard".

I've only just started to figure out the solution to this myself but dropping columns that begin with a capital letter seems to be working for me so far.

EDIT: I realise now that ArcCatalog will not consume quotation marks in a query layer. Seeing as Postgres works with columns in lower case and that when a capital letter is required it encases it quotation marks, you can see where the problem lies.

The solution is to ensure that all column names are lower case and that no quotation marks exist in the SQL statement.

|improve this answer
  • 1
    I had the same issue and landed here trying to fix it. I did the test and deleted the fields with a capital letter and it solved the problem. – Gob Tron Feb 2 '17 at 4:44
1

I had the same issue going from SQLServer2012 to ArcMap. The fix I found was to remove a space in one of the column names.

|improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.