AnsweredAssumed Answered

PostgreSQL - pg_geometry

Question asked by mtgabor on Sep 12, 2016
Latest reply on Sep 12, 2016 by mtgabor

Hi Experts,

 

we have ArcGIS Server 10.4.1 Advanced  with PostgreSQL 9.4.9. and PostGIS

I've created two enterprise geodatabases from ArcCatalog:

 

db1: with ST_GEOMETRY

db2: with PG_GEOMETRY

 

db1 and db2 works fine from the ArcGIS Desktop ArcCatalog (arctoolbox and also python scripts). But when I try running python scripts on the ArcGIS Server, only db1 works. Scrips couldn'nt connect to PG_GEOMETRY db2. I use .sde files generated and tested by ArcCatalog.

 

working script, running on the server (ujsde.sde points to db1 with ST_GEOMETRY):

# Import arcpy module
import arcpy
import arcserver

 

# Local variables:
input_shp = "/home/arcgis/ujshp.shp"
output_shp = "shp_new"
sde_conn = "/home/arcgis/ujsde.sde"


# Process: Feature Class to Feature Class
arcpy.FeatureClassToFeatureClass_conversion(input_shp, sde_conn, output_shp)

it works fine.

 

 

failed script, running on the server (ujsde_pg.sde points to db2 with PG_GEOMETRY):

import arcpy
import arcserver

 

# Local variables:
input_shp = "/home/arcgis/ujshp.shp"
output_shp = "shp_new_pg"
sde_conn = "/home/arcgis/ujsde_pg.sde"


# Process: Feature Class to Feature Class
arcpy.FeatureClassToFeatureClass_conversion(input_shp, sde_conn, output_shp)

error:

[arcgis@... ~]$ /home/arcgis/server/tools/python /home/arcgis/shp2sde_pg.py
Connection to database 'ujsde_pg' failed.
Traceback (most recent call last):
File "/home/arcgis/shp2sde_pg.py", line 22, in <module>
arcpy.FeatureClassToFeatureClass_conversion(input_shp, sde_conn, output_shp)
File "C:\Program Files\ArcGIS\Server\arcpy\arcpy\conversion.py", line 1694, in FeatureClassToFeatureClass
raise e
arcgisscripting.ExecuteError: ERROR 000210: Cannot create output /home/arcgis/ujsde_pg.sde\shp_new2
Failed to execute (FeatureClassToFeatureClass).

Need some extra environment settings on linux connecting with arcpy to the PG_GEOMETRY based geoadatabse...?

What is the difference between the ArcCatalog ArcPy and the ArcGIS Server ArcPy?

The lib files are in the right folder on the server....

 

Thanks,

 

Gabor

arcgis python api arcgisserver postgresql postgis* postgresql

Outcomes