Hello,
i have installed arcsde on windows xp sp3. Post-install program sdesetup works fine with postgresql on the same computer.
But i have to make it work with postgres on another computer (Windows 2003 server sp2, postgres 8.3 & postgis 1.3). When launching sdesetup -s 192.168.11.111, i have the message :
ERROR: Underlyinf DMS error (-51).
ERROR: SDE release install not completed.
the SDE log isn't helpfull.
the Postgres log says :
2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_server_config" does not exist
2010-04-21 10:21:23 CEST STATEMENT: select count(1) from aamp2.sde.sde_server_config
2010-04-21 10:21:23 CEST ERROR: function aamp2.sde.sde_purge_processes() does not exist at character 8
2010-04-21 10:21:23 CEST HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2010-04-21 10:21:23 CEST STATEMENT: SELECT aamp2.sde.SDE_purge_processes ()
2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_version" does not exist
2010-04-21 10:21:23 CEST STATEMENT: SELECT major, minor, bugfix, description, release, sdesvr_rel_low FROM aamp2.sde.sde_version
2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_dbtune" does not exist
2010-04-21 10:21:23 CEST STATEMENT: select count(keyword) from aamp2.sde.sde_dbtune
2010-04-21 10:21:23 CEST ERROR: relation "sde.sde_server_config" does not exist
2010-04-21 10:21:23 CEST STATEMENT: select count(1) from aamp2.sde.sde_server_config
2010-04-21 10:21:23 CEST ERROR: type "st_geometry" does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Out(st_geometry) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_in(cstring) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_In(cstring) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_recv(internal) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Recv(internal) CASCADE
2010-04-21 10:21:23 CEST ERROR: type "st_geometry" does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Send(st_geometry) CASCADE
2010-04-21 10:21:23 CEST ERROR: type "st_envelope" does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_ENVELOPE_Out(st_envelope) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_envelope_in(cstring) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_ENVELOPE_In(cstring) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_register_spatial_column(text, text, text, text, integer) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_register_spatial_column(text, text, text, text, int) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_unregister_spatial_column(text, text, text, text) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_unregister_spatial_column(text, text, text, text) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_isregistered_spatial_column(text, text, text, text, integer) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_isregistered_spatial_column(text, text, text, text, int) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_refresh_cache() does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_refresh_cache() CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_equalsrs(integer, integer) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_EqualSRS(int, int) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geo_analyze(internal) does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION st_geo_analyze(internal) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_version() does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Version( ) CASCADE
2010-04-21 10:21:23 CEST ERROR: function st_geometry_release() does not exist
2010-04-21 10:21:23 CEST STATEMENT: DROP FUNCTION ST_Geometry_Release( ) CASCADE
2010-04-21 10:21:23 CEST ERROR: could not load library "C:/Program Files/PostgreSQL/8.3/lib/st_geometry.dll": unknown error 5
2010-04-21 10:21:23 CEST STATEMENT: CREATE OR REPLACE FUNCTION ST_GEOMETRY_IN(cstring)
RETURNS opaque AS 'st_geometry', 'ST_Geometry_In'
LANGUAGE 'C' WITH (ISCACHABLE, ISSTRICT)
2010-04-21 10:21:23 CEST LOG: could not receive data from client: Unknown winsock error 10061
2010-04-21 10:21:23 CEST LOG: unexpected EOF on client connection
2010-04-21 10:21:23 CEST LOG: could not receive data from client: Unknown winsock error 10061
2010-04-21 10:21:23 CEST LOG: unexpected EOF on client connection
and I can't understand what happens.
I made that install previously on similar configuration and it worked well.
any idea ?
thanks
bertrand
