Solved: Failed to get root path for 'UED'

Good afternoon.

I have a problem with my IDES installation in University.

After a server reboot, MAXDB doesn't want to give up.

This is the log:

$ tail startdb.log

Error! Connection failed to node dolphin for database UED: database not found

Opening Database...

Failed to get root path for 'UED'

Error! Connection failed to node dolphin for database UED: database not found

Fri Aug 24 17:11:11 CEST 2007

Connect to the database to verify the database is now open

dbmcli check finished with return code: 0

If I try to run dbmcli manually, I receive the same error:

$dbmcli -u control,****** -d UED

Failed to get root path for 'UED'

Error! Connection failed to node (local) for database UED: database not found

Any suggestions??

Regards,

Luca

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

As which user are you trying to execute the command?

What do you see when giving

dbmcli db_enum

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you Markus for your reply.

Commands posted before are executed with <SID>adm user.

dolphin:uedadm 3> dbmcli db_enum

Error! Connection failed to node (local) for database (no dbname): no installation found

Thanks.

Luca

It seems that a filesystem is missing, is everything correctly mounted?

Check if the following directories are there:

- /etc/opt (with a file called 'sdb')

- /usr/spool/sql

- /sapdb

Markus

Markus, It seems that all directories exist:

[root@dolphin bin]# cd /etc/opt

[root@dolphin opt]# ls

sdb sdb.rpmorig

[root@dolphin opt]tail sdb

[Globals]

IndepData=/var/opt/sdb/data

IndepPrograms=/opt/sdb/programs

SdbOwner=sdb

SdbGroup=sdba

*********************

cd /usr/spool/sql/

[root@dolphin sql]# ls

dbspeed diag fifo ini ipc pid pipe ppid

*********************

cd /sapdb/

[root@dolphin sapdb]# ls

data programs UED

Thanks again.

Ok...

what did you do prior to the reboot?

Markus

Markus this is a FRESH IDES installation on a Red Hat Enterprise Server 4.4, ended last week.

It wasn't a reboot, but a "forced shutdown" due to an eletrical problem in my University.

Any other suggestions to solve the problem?

thanks,

Luca

I see...

I just wonder those strange paths (/var/opt...) usually everything is installed under /sapdb, and I also wonder the "sdb.rpmsave", it seems, that SAPDB was not installed using official installation CDs but by using an RPM distribution from Mysql...

Markus

Markus,

IDES installation has been permormed using DVD provided directly from SAP AG.

The only rpm package installed was "MaxDB WebTools" to monitor DB.

Unistall this package could solve the problem?

If I try to access DB via sqlcli I faced the same problem.

[root@dolphin bin]# ./sqlcli

Welcome to the MaxDB interactive terminal.

Type: \h for help with commands

\q to quit

sqlcli=> \c -d UED

-10709: Connection failed (RTE:database not running: no request pipe)

If could be useful, hhese are the process running on the server right now:

root 3437 1 0 14:46 ? 00:00:00 hald

uedadm 3801 1 0 14:46 ? 00:00:00 /usr/sap/UED/DVEBMGS00/exe/sapstartsrv pf=/usr/sap/UED/S

root 3807 1 0 14:46 tty1 00:00:00 /sbin/mingetty tty1

root 3808 1 0 14:46 tty2 00:00:00 /sbin/mingetty tty2

root 3809 1 0 14:46 tty3 00:00:00 /sbin/mingetty tty3

root 3811 1 0 14:46 tty4 00:00:00 /sbin/mingetty tty4

root 3820 1 0 14:46 tty5 00:00:00 /sbin/mingetty tty5

root 4086 1 0 14:46 tty6 00:00:00 /sbin/mingetty tty6

root 4090 1 0 14:46 ? 00:00:00 /usr/bin/gdm-binary -nodaemon

root 4501 4090 0 14:46 ? 00:00:00 /usr/bin/gdm-binary -nodaemon

root 4513 4501 0 14:46 ? 00:00:13 /usr/X11R6/bin/X -audit 0 -auth /var/gdm/:0.Xauth -no

gdm 4616 4501 0 14:46 ? 00:00:00 /usr/bin/gdmgreeter

root 4963 1 0 14:50 ? 00:00:01 /usr/sap/UED/SYS/exe/run/saposcol

sdb 6329 1 0 16:50 ? 00:00:00 /opt/sdb/programs/pgm/niserver

sdb 6332 1 0 16:50 ? 00:00:00 /opt/sdb/programs/pgm/vserver start

sdb 6333 6332 0 16:50 ? 00:00:00 xserver.prt logger

root 7215 3273 0 18:26 ? 00:00:00 sshd: sozio [priv]

sozio 7217 7215 0 18:26 ? 00:00:01 sshd: sozio@pts/1

sozio 7218 7217 0 18:26 pts/1 00:00:00 -bash

root 7244 7218 0 18:26 pts/1 00:00:00 su - uedadm

uedadm 7245 7244 0 18:26 pts/1 00:00:00 -csh

root 7360 7245 0 18:29 pts/1 00:00:00 su -

Check the following path:

/sapdb/data/config

There should be a "Database.ini" file with the content of your database.

Markus

Markus, yes there is.

cd /sapdb/data/config

[sozio@dolphin config]$ ls -l

total 192

-rw-rw---- 1 sdb sdba 54 Aug 2 21:03 Databases.ini

-rw-rw-rw- 1 sdb sdba 68 Aug 11 12:10 Databases.ini_lock

drwxr-x--- 2 root sdba 4096 Aug 2 21:03 install

-rrr-- 1 sdb sdba 54 Aug 2 21:03 Installations.ini

-rw-rw-rw- 1 root sapinst 68 Aug 6 21:52 Installations.ini_lock

-rrr-- 1 sdb sdba 48 Aug 2 21:03 Runtimes.ini

-rw-rw---- 1 sdb sdba 11670 Aug 11 09:40 UED

-rr--- 1 sdb sdba 11670 Aug 5 17:32 UED.01

-rr--- 1 sdb sdba 11086 Aug 2 22:19 UED.02

-rw-rw---- 1 sdb sdba 48 Aug 11 09:40 UED.cfg

-rw-rw---- 1 sdb sdba 121382 Aug 5 04:48 UED.pah

-rw-rw---- 1 sdb sdba 2048 Aug 2 22:19 UED.upc

tail /sapdb/data/config/Databases.ini

[Databases]

.M760018=/sapdb/UED/db

UED=/sapdb/UED/db

Moreover, If It could be useful..

tail Runtimes.ini

[Runtime]

/sapdb/programs/runtime/7500=7.5.0.0,

tail Installations.ini

[Installations]

/sapdb/UED/db=7.6.0.18,/sapdb/UED/db

Thanks a lot for your help.

This look good - at least your registry is intact.

I have only one thing left - you can try to start the database as sqd<SID>, try manually

dbmcli -u control,<controlpassword> -d UED db_online

Markus

Always the same result! 😕

su - sqdued

Password:

dolphin:sqdued 1> dbmcli -u control,****** -d UED db_online

Failed to get root path for 'UED'

Error! Connection failed to node (local) for database UED: database not found

I think, that you have no more idea, to solve the problem..

The last solution could be to re-install MaxDB, without re.-install all IDES?

Thanks

You can to run "sdbverify" (/sapdb/programs/bin) to check your installation.

Markus

sdbverify

path "/var/opt/sdb/data/config/install" not found

MaxDB install registry verification exited abnormally at Fr, Aug 24, 2007 at 19:53:37

dolphin:sqdued 3> cd /var/opt/sdb/data/config/install

/var/opt/sdb/data/config/install: No such file or directory.

The lackness of this file, could be the problem... Right?

It seems to me, that the installation of the "WebDBM"-RPM has overwritten the paths, that are usually in those directory.

We can try one thing:

copy the file /etc/opt/sdb to another name

and change it so it looks like

[Globals]
IndepData=/sapdb/data
IndepPrograms=/sapdb/programs

and then execute sdbverify again.

Markus

YES marKUS, now It seems that everythings works!!

./sdbverify

Server Utilities 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

DB Analyzer 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

PCR 7300 7.3.00.54 in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

Base 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

Redist Python 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

PCR 7301 7.3.01.18 in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

JDBC 7.6.00.16 in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

PCR 7500 7.5.00.24 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

Messages MSG 0.3017 in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

ODBC 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

Database Kernel 7.6.00.18 64 bit in /sapdb/UED/db

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

Loader 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

SQLDBC 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

SQLDBC 7600 7.6.00.18 64 bit in /sapdb/programs

check files... ok

check dependencies... ok

package data is consistent

VERIFICATION SUMMARY:

*********************

INVALID PACKAGES: 0

VALID PACKAGES: 14

INCONSISTENT PACKAGES: 0

TOTAL FILES: 317

MISSED FILES: 0

MODIFIED FILES: 0

FILES WITH MODIFIED PERMISSIONS: 0

Now I give again "startsap" command as uedadm user. Thingers crossed!!!

I'll keep you inform.

Thank you very much!

I am pretty sure that the "sdb.rpmsave" contains exactly the information, you just changed, that was the original file being overwritten by the installation of WebDBM.

That problem didn't arise earlier because your machine was kept running and thus the software registry was not used.

Markus

Hi Markus,

I think that my problem is not completely solved.

In fact, now the IDES system is on , but I'm not able to login into it.

When I select UED system on menu of my JAVA GUI and press "connect button", I can't access to SAP login window. (see )

I'm sure that is not a "network problem" of my laptop. (the problem persist also with others SAPGUI).

I've tried to <b>reboot</b> the server, but the situation is always the same. No way to access into the system, popup "connecting" reman.

If I try to see process that are running in the server, via "top -u uedadm" command, this is the situation:

3791 uedadm 16 0 87988 9768 1996 S 0 0.2 0:00.00 sapstartsrv

4775 uedadm 15 0 54664 1580 904 S 0 0.0 0:00.04 csh

4911 uedadm 16 0 54664 1604 920 S 0 0.0 0:00.05 csh

5388 uedadm 20 0 26788 1896 1064 S 0 0.0 0:00.04 sapstart

5408 uedadm 16 0 35736 5748 3024 S 0 0.1 0:00.06 ms.sapUED_DVEBM

5409 uedadm 16 0 4480m 100m 86m S 0 2.5 0:00.95 UED_00_DP

5410 uedadm 16 0 27528 2988 2224 S 0 0.1 0:00.05 co.sapUED_DVEBM

5411 uedadm 16 0 27488 2952 2216 S 0 0.1 0:00.04 se.sapUED_DVEBM

5412 uedadm 18 0 17620 2432 1800 S 0 0.1 0:00.01 ig.sapUED_DVEBM

5413 uedadm 16 0 210m 12m 3352 S 0 0.3 0:00.20 igsmux_mt

5414 uedadm 16 0 183m 18m 10m S 0 0.5 0:00.16 igspw_mt

5415 uedadm 16 0 183m 18m 10m S 0 0.5 0:00.19 igspw_mt

5430 uedadm 15 0 188m 8296 5972 S 0 0.2 0:00.05 gwrd

5431 uedadm 18 0 164m 4376 2844 S 0 0.1 0:00.63 icman

5432 uedadm 17 0 4486m 22m 7988 S 0 0.6 0:00.01 UED_00_DIA_W0

5433 uedadm 17 0 4486m 22m 7976 S 0 0.6 0:00.01 UED_00_DIA_W1

5434 uedadm 16 0 5201m 79m 63m S 0 2.0 0:00.82 UED_00_DIA_W2

5435 uedadm 17 0 4486m 22m 7976 S 0 0.6 0:00.01 UED_00_DIA_W3

5436 uedadm 17 0 4486m 22m 7980 S 0 0.6 0:00.02 UED_00_DIA_W4

5437 uedadm 16 0 4486m 22m 7980 S 0 0.6 0:00.02 UED_00_DIA_W5

5438 uedadm 16 0 4486m 22m 7976 S 0 0.6 0:00.01 UED_00_DIA_W6

5439 uedadm 16 0 4486m 22m 7976 S 0 0.6 0:00.02 UED_00_DIA_W7

5440 uedadm 17 0 4486m 22m 7980 S 0 0.6 0:00.01 UED_00_DIA_W8

5441 uedadm 16 0 4486m 22m 7976 S 0 0.6 0:00.02 UED_00_DIA_W9

5442 uedadm 17 0 4486m 22m 7976 S 0 0.6 0:00.02 UED_00_DIA_W10

5443 uedadm 17 0 4486m 22m 7984 S 0 0.6 0:00.01 UED_00_DIA_W11

5444 uedadm 17 0 4486m 22m 7972 S 0 0.6 0:00.02 UED_00_UPD_W12

5445 uedadm 17 0 4486m 22m 7972 S 0 0.6 0:00.01 UED_00_UPD_W13

5446 uedadm 17 0 4486m 22m 7976 S 0 0.6 0:00.01 UED_00_UPD_W14

5447 uedadm 16 0 4486m 22m 7976 S 0 0.6 0:00.02 UED_00_ENQ_W15

5448 uedadm 16 0 4486m 22m 7976 S 0 0.6 0:00.02 UED_00_BTC_W16

5449 uedadm 17 0 4486m 22m 7980 S 0 0.6 0:00.01 UED_00_BTC_W17

5450 uedadm 17 0 4486m 22m 7976 S 0 0.6 0:00.01 UED_00_BTC_W18

I think that is not a performance problem of server, because

"free -m" command

total used free shared buffers cached

Mem: 3946 2249 1697 0 50 950

-/+ buffers/cache: 1247 2699

Swap: 8001 0 8001

Can you please me, give some suggestions?

Thank you very much.

try to login as <sid>adm and start the program

dpmon

then use the menu point "p" and see if your workprocesses are running (same as transaction SM50 in the system).

also check if you have a "LOG FULL" situation:

use <sid>adm and execute

x_cons <SID> show ac 1

when you try to login.

Do you see any activity?

Markus

Answers (0)

Ask a Question

Failed to get root path for 'UED'

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: ASEGURAMIENTO DE TABLAS

Re: Getting error while Creating role in BRM

Re: How to enable the add, delete,edit system on s...

Re: CJS-30252 Running priviledged function stop of...

Successfactors login issue.