topic Re: ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0 in Data Management Questions

ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0

deleted-user-1T_bOHag6M8d — Fri, 18 Jan 2013 22:18:32 GMT

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?

Thanks.

Re: ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0

VinceAngelo — Fri, 18 Jan 2013 23:47:46 GMT

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

Re: ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0

deleted-user-1T_bOHag6M8d — Thu, 24 Jan 2013 14:32:09 GMT

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.

Re: ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0

VinceAngelo — Thu, 24 Jan 2013 14:35:08 GMT

Yes, there are dozens of different ArcSDE service packs (apply the one appropriate
to your platform/release).

- V

Re: ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0

deleted-user-1T_bOHag6M8d — Thu, 24 Jan 2013 14:53:41 GMT

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.

Re: ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0

AsrujitSengupta — Thu, 24 Jan 2013 15:01:41 GMT

Nicholas,

Here is a link to download the ArcSDE 10.1 SP1:

http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1914

Regards,

Re: ArcSDE Service won't work with PostgreSQL 9.1/PostGIS 2.0

deleted-user-1T_bOHag6M8d — Thu, 24 Jan 2013 16:09:33 GMT

Nicholas,

Here is a link to download the ArcSDE 10.1 SP1:

http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1914

Regards,

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.