I've followed the instructions for getting ArcSDE to work with PostgreSQL 9.1 and PostGIS 2.0 and I can make direct connections from ArcMap with no issue. However, I'm unable to view feature classes in the geodatabase through an ArcSDE Service connection.
I've used the Create ArcSDE Connection file tool to create a connection to my server with the service set to 5152. The initial connection is fine, but trying to add any feature classes to ArcMap returns an ArcMap error saying "One or more layers failed to draw. <<Feature Class>>: Function or procedure does not exist [<<Feature Class>>]".
In my PostgreSQL logs I can see the SQL statement that fails. It says "ERROR: function setsrid(geometry, integer) does not exist at character 19". My understanding is the setsrid function in PostGIS was renamed to st_setsrid in version 2.0. The direct connection does not give this error, likely due to the updated client libraries at SP1.
Is there a way for me to provide the updated client libraries for the ArcSDE Service?
While geodatabase upgrades happen from the Desktop client, you still need to apply the service pack to the application server install before those binaries are updated (and re-copy the revised ST_GEOMETRY library as well).
While geodatabase upgrades happen from the Desktop client, you still need to apply the service pack to the application server install before those binaries are updated (and re-copy the revised ST_GEOMETRY library as well).
- V
Is there a separate service pack for ArcSDE? I've installed ArcGIS Server with SP1 and the service pack for License Manager. Now the only item in Patchfinder on my server without a service pack is ArcSDE.
Yes, there are dozens of different ArcSDE service packs (apply the one appropriate to your platform/release).
- V
Beg your pardon, Vince. I don't see where there is an ArcSDE service pack for 10.1. I only see 10.1 service packs for ArcGIS Desktop, Engine and Server and I've already installed all of those. Can you assist me with finding the correct service pack?
Thanks, Asrujit and Vince. I installed ArcSDE SP1 and I also performed the ST_Geometry upgrade using the instructions Vince provided. Looks like everything is working now.
