topic Re: Errors when I try to install ArcSDE 10 with Postgres 8.4.1 in RedHat 5.7 in Data Management Questions

Errors when I try to install ArcSDE 10 with Postgres 8.4.1 in RedHat 5.7

MarioBurrola — Fri, 06 Apr 2012 00:02:49 GMT

I have reinstall the Postgres 8.4.1 database in Linux RedHat 5.7 and I get this errors when I run the following command (Passwords have been change)

./sdesetup -o install -d POSTGRESQL -u sde -p sdepassword -D stormdata -s localhost -l /home/sde/sdeexe100/Authorization_ArcSDE.ecp - N

[Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist
LINE 1: select count(*) from stormdata.sde.sde_layers
                             ^

[Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from stormdata.sde.sde_server_config
                             ^

[Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist
LINE 1: select count(keyword) from stormdata.sde.sde_dbtune
                                   ^

[Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01
SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist
LINE 1: select count(1) from stormdata.sde.sde_server_config
                             ^

[Thu Apr 5 17:58:03 2012] ST_GEOMETRY support being installed...
[Thu Apr 5 17:58:03 2012] ev.SQLstate = 58P01
SDE DBMS Error: -51 ERROR: could not load library "/usr/lib64/pgsql/st_geometry.so": /usr/lib64/pgsql/st_geometry.so: wrong ELF class: ELFCLASS32

[Thu Apr 5 17:58:03 2012] ST_GEOMETRY install not completed (-51).
[Thu Apr 5 17:58:03 2012] ERROR installing/upgrading ArcSDE, Error = -51

Re: Errors when I try to install ArcSDE 10 with Postgres 8.4.1 in RedHat 5.7

VinceAngelo — Fri, 06 Apr 2012 00:40:43 GMT

Any time you get a "wrong ELF class" error, it means you're mixing application
word sizes between components. I've already directed you to the use of 'file'
to determine which is incorrect. This time it appears you have a 32-bit ArcSDE
with a 64-bit PostgreSQL, while last time you had a 64-bit ArcSDE with a 32-bit
database.

Esri always specifies "64" in the folder name for 64-bit applications; if 'file' reports
32-bit ArcSDE, try going back to your distribution media and copying the 64-bit
ArcSDE installer, then go to the support site to download the latest 64-bit service
pack (which should be installed before you run 'sdesetup -o install').

- V

Re: Errors when I try to install ArcSDE 10 with Postgres 8.4.1 in RedHat 5.7

MarioBurrola — Tue, 10 Apr 2012 21:17:23 GMT

After checking the right files for 64 libraries files and applying the update patch, the geodatabase was created and authorized.

Thanks for all your help. The issue from the beginnning was the lack of not applying the latest patch.

Mario