ArcSDE10 for PostgreSQL - Failed Post-installation on Red Hat

simonebalbo · ‎07-29-2011

Hello,

I'm installing ArcSDE10 for PostgreSQL on a server with Red Hat OS.
While launching the postinstallation command (sdesetup -o install...) the process fails with an error -51.

Does anyone have any suggestion for solving it? I have been thinking about file ownerships, environmental variables and I checked everything that came in my mind...

I report here the content of the sde_setup.log file:

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist
LINE 1: select count(*) from drr_sde.sde.sde_layers
                             ^

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from drr_sde.sde.sde_server_config
                             ^

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist
LINE 1: select count(keyword) from drr_sde.sde.sde_dbtune
                                   ^

[Fri Jul 29 13:55:35 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from drr_sde.sde.sde_server_config
                             ^

[Fri Jul 29 13:55:35 2011] ST_GEOMETRY support being installed...
[Fri Jul 29 13:55:35 2011] ev.SQLstate = 58P01
SDE DBMS Error: -51 ERROR: could not access file "st_geometry": No such file or directory

[Fri Jul 29 13:55:35 2011] ST_GEOMETRY install not completed (-51).
[Fri Jul 29 13:55:35 2011] ERROR installing/upgrading ArcSDE, Error = -51

Many Thanks

Simone

VinceAngelo · ‎07-29-2011

Check your environment variables again, especially LD_LIBRARY_PATH. As the postgres
user, execute 'ldd st_geometry.so' -- Do all the DLLs resolve?

Did you forget to copy the ArcSDE application libraries into the PostgreSQL shared libraries
directory? Remember that libsg.so and libpe.so are dependencies for st_geometry.so.

- V

simonebalbo · ‎08-02-2011

vangelo,

executing 'ldd st_geometry.so' as postgres user I get:
        linux-vdso.so.1 => (0x00007fffcec8e000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00002ada0dbd5000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00002ada0ddf0000)
libm.so.6 => /lib64/libm.so.6 (0x00002ada0e0f1000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002ada0e374000)
libc.so.6 => /lib64/libc.so.6 (0x00002ada0e582000)
/lib64/ld-linux-x86-64.so.2 (0x000000392e400000)

I was still stuck at the same problem...

I decided to restart from scratch and now I get this error while executing the command:
sdesetup -o install -d POSTGRESQL...

ESRI ArcSDE Server Setup Utility Tue Aug 2 14:38:56 2011
----------------------------------------------------------------
Install or update ST_GEOMETRY, ArcSDE, GDB schema objects: Are you sure? (Y/N): Y

Checking INSTALL privileges for geodatabase ...
Current user has privilege to install geodatabase instance.

Checking geodatabase XML datatype support...
Underlying RDBMS database instance supports XML data type.

Creating ST_GEOMETRY and ArcSDE schema.....
Segmentation fault

Some relations have been created in the database, in fact executing '\d' from postgresql command line I get this list:
                      List of relations
Schema |              Name               |   Type   | Owner
--------+---------------------------------+----------+-------
public | sde_spatial_references          | table    | sde
public | sde_spatial_references_srid_seq | sequence | sde
sde    | sde_coordinate_systems          | table    | sde
sde    | sde_geometry_columns            | table    | sde
sde    | st_geometry_columns             | view     | sde
sde    | st_spatial_references           | view     | sde
(6 rows)

The relations listed seem to be all empty, only the schema has been created.

[Tue Aug 2 14:09:47 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist

[Tue Aug 2 14:09:47 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist

[Tue Aug 2 14:09:47 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist

[Tue Aug 2 14:09:47 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist

[Tue Aug 2 14:09:47 2011] ST_GEOMETRY support being installed...
[Tue Aug 2 14:09:47 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_coordinate_systems" does not exist

[Tue Aug 2 14:09:47 2011] COORDINATE_SYSTEMS table being created...
[Tue Aug 2 14:09:47 2011] COORDINATE_SYSTEMS table created...
[Tue Aug 2 14:09:47 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "public.sde_spatial_references" does not exist

[Tue Aug 2 14:09:47 2011] SPATIAL_REFERENCES table being created...
[Tue Aug 2 14:09:47 2011] SPATIAL_REFERENCES table created...
[Tue Aug 2 14:09:47 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_geometry_columns" does not exist

[Tue Aug 2 14:09:47 2011] GEOMETRY_COLUMNS table being created...
[Tue Aug 2 14:09:47 2011] GEOMETRY_COLUMNS table created...
[Tue Aug 2 14:09:47 2011] ST_GEOMETRY install not completed (-1015).
[Tue Aug 2 14:09:47 2011] ERROR installing/upgrading ArcSDE, Error = -1015
[Tue Aug 2 14:26:24 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist

[Tue Aug 2 14:26:24 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist

[Tue Aug 2 14:26:24 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist

[Tue Aug 2 14:26:24 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist

[Tue Aug 2 14:26:24 2011] ST_GEOMETRY support being installed...
[Tue Aug 2 14:26:24 2011] ST_GEOMETRY install not completed (-1015).
[Tue Aug 2 14:26:24 2011] ERROR installing/upgrading ArcSDE, Error = -1015
[Tue Aug 2 14:38:59 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist

[Tue Aug 2 14:38:59 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist

[Tue Aug 2 14:38:59 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist

[Tue Aug 2 14:38:59 2011] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist

[Tue Aug 2 14:38:59 2011] ST_GEOMETRY support being installed...
[Tue Aug 2 14:38:59 2011] ST_GEOMETRY install not completed (-1015).
[Tue Aug 2 14:38:59 2011] ERROR installing/upgrading ArcSDE, Error = -1015

Any suggestion?

VinceAngelo · ‎08-02-2011

Starting over "from scratch" involves first dropping every object previously created during
the original 'sdesetup'.

At this point you should probably start an incident with Tech Support.

- V

simonebalbo · ‎08-02-2011

vangelo,

with "starting from scratch" I meant that I unistalled both arcsde and postgresql, cleaned all the dependencies and installed them again.
I followed all the installation instructions.
The postgresql relations that I posted where created during the latest execution of "sdesetup -o install".

If nobody has any further suggestion, probably the Tech Support would be the only solution.
How can I contact it?

Thanks

VinceAngelo · ‎08-02-2011

You contact Tech Support through the mechanism prescribed by your license agreement. For most
US sites, this is through the toll-free number; for international sites, through your local distributor.
Most organizations with site licenses (e.g. universities) have a central tier-1/contact person who in
turn makes the call if it's out of their league. Evaluation installs are sometimes supported by the
local marketing office.

- V

VinceAngelo · ‎10-02-2012

Since I ran into this same error using PostgreSQL 8.3.8 with ArcSDE 10.0 SP5 on 64-bit CentOS 5.8,
I'll provide my solution -- I updated my shell script that created tablespaces, logins, roles, schemas
and granted permissions to include:

psql -d gis100 -U sde <<EOI
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
  HANDLER plpgsql_call_handler
  VALIDATOR plpgsql_validator;
\q
EOI

(change 'gis100' to your database or a variable, of course). After that, the 'sdesetup -o install' ran
cleanly to completion.

I didn't have the same issue with the ArcSDE 10.1 install in PostgreSQL 9.0.5, though it's uncertain
whether this was due to the Create Enterprise Geodatabase toolbox taking care of the issue, or
changes at 9.x that make plpgsql more generally available.

- V

NOTE: If the CREATE TRUSTED PROCEDURAL LANGUAGE above fails with
NOTICE: using pg_pltemplate information instead of CREATE LANGUAGE parameters
try just: "CREATE LANGUAGE plpgsql;" instead.