Error at SAP installation

[Former Member]

Hello gurus

I'm installing a Central Instance of SAP R3 4.7 Enterprise Edition, the central instance in one host and the database in another host. I'm getting the error below and the installation stops.

ERROR 2012-01-26 17:52:04

FKD-00034 Query returned more than one result.

ERROR 2012-01-26 17:52:04

FKD-00035 Query did not return a result. Select attribute WHERE WapsInstanceName = getContextParameter ('WapsInstanceName' ) AND WapsSystemName = getContextParameter ('WapsSystemName' ) , statement:

ERROR 2012-01-26 17:52:04

FKD-00029 Subselect for table t_SAPComponent_Waps_Instance_SHARED, column WapsExeDir with WHERE clause WHERE WapsInstanceName = getContextParameter ('WapsInstanceName' ) AND WapsSystemName = getContextParameter ('WapsSystemName' ) failed.

ERROR 2012-01-26 17:52:04

MUT-02010 Internal error: Access to key db failed. Original message: Subselect to table >t_SAPComponent_Waps_Instance_SHARED< column name >WapsExeDir< using where clause >WHERE WapsInstanceName = getContextParameter ('WapsInstanceName' ) AND WapsSystemName = getContextParameter ('WapsSystemName' ) < ends with an exception. ExceptionText :single select returns more than on row .

WARNING 2012-01-26 17:52:04

The step diPrepareDbEnvironment with step key SAPSYSTEM_CI|ind|ind|ind|ind|ind|0|SAPSYSTEM|ind|ind|ind|ind|ind|0|SAPComponent|ind|ind|ind|ind|ind|0|DatabaseSystem|ind|ind|ora|ind|ind|0|DatabaseCommonParameters|ind|ind|ora|ind|ind|0|diPrepareDbEnvironment was executed with status ERROR.

WARNING 2012-01-26 17:54:09

An error occurred during the installation.

Do you have any ideia what could it be?

Regards

[Former Member]

Hi experts,

Im getthing the same error. i already set the env LD_LIBRARY_PATH did you resolve this issue?

how do you doit?

Regards,

Alejandro.

[Former Member]

Hello,

As Juan already suggested, please check environment variables and make sure all are set as per installation guide.

Thanks,

Siva Kumar

[JPReyes]

Can you post your env variables at the time of the installation?

Regards

Juan

[Former Member]

here are the environment variables

VNCDESKTOP=sapdst1:1 (root)

HOSTNAME=sapdst1

TERM=xterm

SHELL=/bin/bash

HISTSIZE=1000

WINDOWID=6291495

XTERM_SHELL=/bin/bash

USER=root

LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:.cmd=00;32:.exe=00;32:.com=00;32:.btm=00;32:.bat=00;32:.sh=00;32:.csh=00;32:.tar=00;31:.tgz=00;31:.arj=00;31:.taz=00;31:.lzh=00;31:.zip=00;31:.z=00;31:.Z=00;31:.gz=00;31:.bz2=00;31:.bz=00;31:.tz=00;31:.rpm=00;31:.cpio=00;31:.jpg=00;35:.gif=00;35:.bmp=00;35:.xbm=00;35:.xpm=00;35:.png=00;35:.tif=00;35:

LD_LIBRARY_PATH=/etc/emc/rsa/cst/lib:/etc/emc/rsa/cst/lib

PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/etc/opt/emcpower/bin:/root/bin:/usr/local/sbin:/usr/local/bin

MAIL=/var/spool/mail/root

PWD=/sapmnt/TRN/instdir

INPUTRC=/etc/inputrc

LANG=en_US.UTF-8

XTERM_VERSION=XTerm(215)

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

HOME=/root

SHLVL=4

LOGNAME=root

LESSOPEN=|/usr/bin/lesspipe.sh %s

DISPLAY=:1.0

G_BROKEN_FILENAMES=1

_=/bin/env

OLDPWD=/sapmnt/TRN

[JPReyes]

You haven't maintained the env variables required for the installation. Read and follow the installation guide.

Regards

Juan

[Former Member]

Juan

The installation guide informs to change the environment variable LD_LIBRARY_PATH and I changed as suggested in installation guide, but the error persists.

There are another environment variables besides LD_LIBRARY_PATH that I have to change?

VNCDESKTOP=xxx

HOSTNAME=xxx

TERM=xterm

SHELL=/bin/bash

HISTSIZE=1000

WINDOWID=6291495

XTERM_SHELL=/bin/bash

USER=root

LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:.cmd=00;32:.exe=00;32:.com=00;32:.btm=00;32:.bat=00;32:.sh=00;32:.csh=00;32:.tar=00;31:.tgz=00;31:.arj=00;31:.taz=00;31:.lzh=00;31:.zip=00;31:.z=00;31:.Z=00;31:.gz=00;31:.bz2=00;31:.bz=00;31:.tz=00;31:.rpm=00;31:.cpio=00;31:.jpg=00;35:.gif=00;35:.bmp=00;35:.xbm=00;35:.xpm=00;35:.png=00;35:.tif=00;35:

LD_LIBRARY_PATH=/sapmnt/TRN/exe:/oracle/10.2.0.5.5/lib

PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/etc/opt/emcpower/bin:/root/bin:/usr/local/sbin:/usr/local/bin

MAIL=/var/spool/mail/root

PWD=/sapmnt/TRN/instdir/inst5

INPUTRC=/etc/inputrc

LANG=en_US.UTF-8

XTERM_VERSION=XTerm(215)

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

HOME=/root

SHLVL=4

LOGNAME=root

LESSOPEN=|/usr/bin/lesspipe.sh %s

DISPLAY=:1.0

ORACLE_HOME=/oracle/10.2.0.5.5

G_BROKEN_FILENAMES=1

_=/bin/env

[JPReyes]

LD_LIBRARY_PATH=/sapmnt/TRN/exe:/oracle/10.2.0.5.5/lib

ORACLE_HOME=/oracle/10.2.0.5.5

to start thats not a valid ORACLE_HOME if you are using Oracle 10g it should be /oracle/<SID>/102_64

Do you have any other application running on the server using Oracle?

Regards

Juan