<!DOCTYPE html><html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<style type="text/css">body { font-family:'Times New Roman'; font-size:13px}</style>
</head>
<body lang="EN-US" link="blue" vlink="purple"><div>Muni,</div><div><br></div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div class="WordSection1"><p class="MsoPlainText">Thank you for helping me on this. I have no issues with accessing the tables from pgadmin III. Infact I loaded the data using Postgis shapefile loader plugin. I could see, from pgadmin III, that gid is primary key. When I queried data from ArcMap, I checked gid column as only unique identifier field. I did not install ArcSDE on the machine. With regards to configuration. What configuration files (ArcSDE sever config file) I need to look to make sure no network issues are there? </p></div></blockquote><div><br></div><div>I have no specific experience with configuring access from ArcMAP to PostGIS not using an ArcSDE server (whose config settings are fine for most networks). </div><div><br></div><div>I can only assume that when you registered the table/column you told it that the GID was the unique identifier and it was "user maintained". Now, you say that the gid is the table's primary key. Did ArcGIS accept this as sufficient for a unique key? (The reason is that ESRI's GeoDatabases, as far as I can remember, are set up so that gid's are unique with an index but not database primary keys.)</div><div><br></div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div class="WordSection1"><p class="MsoPlainText">Cause the message, I get when I open the table of the queried layer in ArcMap is</p><p class="MsoPlainText">"Could not load data from the data source. If you can correct the problem, press the refresh button to reload data. Possible problems can include bad network connection, invalid field, etc. The SQL statement was not a select statement. The operation is not supported by this implementation."</p></div></blockquote><div><br></div><div>Can you turn on some sort of connection logging to see what sort of SQL is being generated and thus you can see why this is happening?</div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div class="WordSection1"><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">Any suggestions you may have? Thanks in advance.</p></div></blockquote><div><br></div><div>
I, like most on this list, don't have ArcGIS (too expensive) so it is difficult to replicate and fix. I would suggest you try appropriate ESRI forum.
</div><div><br></div><div>regards</div><div>Simon</div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div class="WordSection1"><p class="MsoPlainText">Regards,</p><p class="MsoPlainText">Muni</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">Can you interact with the postgresql/Postgis data natively (ie via pgAminIII) without error? Can't think of any case where this might not be the case. This smells very much like an ArcGIS/ArcSDE configuration problem. In the old days, when one used the ArcSDE administration command line tools, one would use sdelayer to create a layer over an existing table. That sdelayer command included arguments to tell ArcSDE what column contained the unique identifier and whether it was SDE maintained or user maintained. ArcSDE, back then, didn't require the column to be a primary key, only unique.</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">sdelayer -o add -l <table,column> -e <entity_mask> [-t <storage_type>] [Spatial_Index][{-R <SRID> | [Spatial_Ref_Opts]}] [-M <minimum_id>] [{-f <init_features,avg_points> | -k <config_keyword>}] [-E <{empty | xmin,ymin,xmax,ymax}>] [-L {ON | OFF}] [-C <row_id_column>[,{SDE|USER}[,<min_ID>]]] [-P {HIGH | BASIC}] [-S <layer_description_str>] [-i {<service> | <port#> | <direct connection>}] [-s <server_name>] [-D <database_name>] -u <DB_user_name> -p <DB_user_password> [-q]</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">For -C .....</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">Specifies the name of the row ID column of the layer's business table and the optional minimum row ID value</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">For the register operation, it also specifies whether the row ID is to be registered as user or ArcSDE maintained. If ArcSDE maintained, you can specify the starting value (min_ID) for the row ID. If no minimum ID is specified, it defaults to 1. If you intend to register the feature class with the geodatabase, you should register the row ID column as ArcSDE maintained.</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">For the feature_info operation, it specifies the name of the row ID column that will be output to a table in the database.</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">Double check that this is your table/column configuration aligns with what I have said.</p><p class="MsoPlainText"><o:p> </o:p></p><p class="MsoPlainText">regards</p><p class="MsoPlainText">Simon</p><p class="MsoNormal"><o:p> </o:p></p></div></blockquote><br><br><br><div id="M2Signature"><div>-- </div><div>Holder of "2011 Oracle Spatial Excellence Award for Education and Research."<br>SpatialDB Advice and Design, Solutions Architecture and Programming,<br>Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional<br>Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.<br>39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.<br>Website: www.spatialdbadvisor.com<br> Email: simon@spatialdbadvisor.com<br> Voice: +61 362 396397<br>Mobile: +61 418 396391<br>Skype: sggreener<br>Longitude: 147.20515 (147° 12' 18" E)<br>Latitude: -43.01530 (43° 00' 55" S)<br>GeoHash: r22em9r98wg<br>NAC:W80CK 7SWP3</div></div></body></html>