Connect to database failed,rc=-10709 Connection failed (RTE:Database name)

[s0007045141]

Hi gurues, I'm facing this issue with an IDES on MaxDB with Windows.

System was up and running until someone tries to make an upgrade of the kernel. Since then we can not start our system. we tried to rollback kernel release to the previous one but it didn't work.

When we start our system from MMC console we can see all process in green but work processes are in RUN state and after a few minutes they goes down with the following error

-

---

trc file: "dev_w0", trc level: 1, release: "701"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Mon May 16 23:57:31 2011

B create_con (con_name=R/3)

B Loading DB library '
sirillium1\sapmnt\SED\SYS\exe\uc\NTAMD64\dbsdbslib.dll' ...

B Library '
sirillium1\sapmnt\SED\SYS\exe\uc\NTAMD64\dbsdbslib.dll' loaded

B Version of '
sirillium1\sapmnt\SED\SYS\exe\uc\NTAMD64\dbsdbslib.dll' is "700.08", patchlevel (0.24)

B New connection 0 created

M sysno 00

M sid SED

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 32

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 212

M

M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 212) [dpxxdisp.c 1348]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 22784 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000B2C0050, size: 6607136)

M DpShMCreate: allocated sys_adm at 000000000B2C0050

M DpShMCreate: allocated wp_adm at 000000000B2C2270

M DpShMCreate: allocated tm_adm_list at 000000000B2C7B70

M DpShMCreate: allocated tm_adm at 000000000B2C7BD0

M DpShMCreate: allocated wp_ca_adm at 000000000B86B450

M DpShMCreate: allocated appc_ca_adm at 000000000B871250

M DpShMCreate: allocated comm_adm at 000000000B873190

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000B8F9E20

M DpShMCreate: allocated gw_adm at 000000000B8F9EA0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000B8F9ED0

M DpShMCreate: allocated wall_adm at 000000000B8F9EE0

M

M Mon May 16 23:57:32 2011

M rdisp/queue_size_check_value : -> off

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host sirillium1

M

M Mon May 16 23:57:33 2011

M calling db_connect ...

C

C DBSDBSLIB : version 700.08, patch 0.024 (Make PL 0.32)

C MAXDB shared library (dbsdbslib) patchlevels (last 10)

C (0.024) Default value for max. input variables is 2000 (note 655018)

C (0.024) Profile parameter to define max. input variables (note 655018)

C (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841)

C (0.024) Input parameters for SQL statements increased (note 655018)

C (0.018) Create index serial for MaxDB 7.6 (note 1267841)

C (0.018) More trace in case of packed to string conversion error (note 1262799)

C (0.016) R3trans export aborts with signal 6 (note 1262245)

C (0.009) IA64 alignment errors (note 1245982)

C (0.007) Support DB-Type 'SAP DB' by UPDSTAT (note 1225668)

C

C

C Loading SQLDBC client runtime ...

C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 015-123-202-938

C SQLDBC client runtime is MaxDB 7.6.5.015 CL 202938

C SQLDBC supports new DECIMAL interface : 0

C SQLDBC supports VARIABLE INPUT data : 1

C SQLDBC supports keepAlive indicator : 0

C INFO : SQLOPT= -I 0 -t 0 -S SAPR3

C Try to connect (DEFAULT) on connection 0 ...

C *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Database name is missing))

[dbsdbsql.cpp 137]

B ***LOG BV3=> severe db error -10709 ; work process is stopped [dbsh#2 @ 1203] [dbsh 1203 ]

B ***LOG BY2=> sql error -10709 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]

M

M Info for wp 0

M

M pid = 212

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server sirillium1_SED_00 on host sirillium1 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Mon May 16 23:57:33 2011

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10783

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 212) [dpnttool.c 334]

We check several entries on this SDN site, and look for a lot of notes on the marketplace, and they always are related to default user in xuser files, but our xuser list output is ok. We have a DEFAULT connection to SAPSID user, a DBM connection to CONTROL user and a USERDBA connection.

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPSID

UsernameUCS2:S.A.P.S.E.D. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SID

Nodename :server1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SID

Nodename :server1

Sqlmode :INTERNAL

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SID

Nodename :server1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SID

Nodename :server1

Sqlmode :INTERNAL

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

Any idea? we are out of ideas at this moment.

Regards

Edited by: Gustavo Goicochea on May 17, 2011 6:37 PM

[former_member485744]

Thanks for the answer .

Same error resolved for me in Hana DB as well after setting the DEFAULT key on central instance.

We were facing this issue

==========

** ERROR => Connect to database failed, rc=1, rcSQL=-10709

========= after seperating the ci from DB server.

when I saw the R3trans log it was showing

=========

========

4 ETW000  [     dev trc,00000]   -> checkEnvironment(con_hdl=0)                                           95  0.035289

4 ETW000  [     dev trc,00000]   -> connect(con_info_p=(nil))                                             62  0.035351

4 ETW000  [     dev trc,00000]  Try to connect via secure store (DEFAULT) on connection 0 ...            130  0.035481

4 ETW000  [     dev trc,00000]  no connection data found for key (DEFAULT) in HANA secure store          588  0.036069

4 ETW000  [     dev trc,00000]  connect via secure store, rc = -10104 (Invalid value for KEY (DEFAULT))

4 ETW000                                                                                                  22  0.036091

4 ETW000  [     dev trc,00000]  Try to connect via environment (localhost:7878) on connection 0 ...       21  0.036112

4 ETW000  [dbhdbsql.cpp,00000]  *** ERROR => Connect to database failed, rc=1, rcSQL=-10709             1219  0.037331

4 ETW000  [     dev trc,00000]  SQLCODE    : -10709                  

============

So, issue resolved after setting the DEFAULT key on ci.

Regards

Prashasti

[Former Member]

Dear Prashasti

Thanks for the answer .

I faced Same error resolved for me in Hana DB ,but I don't know how to set the DEFAULT key on central instance, please give me help, thanks.

Best Regards,

Bill Chen

[markus_doehr2]

> C Try to connect (DEFAULT) on connection 0 ...

> C *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Database name is missing))

> [dbsdbsql.cpp 137]

> B ***LOG BV3=> severe db error -10709 ; work process is stopped [dbsh#2 @ 1203] [dbsh 1203 ]

> B ***LOG BY2=> sql error -10709 performing CON [dblink#3 @ 431] [dblink 0431 ]

> B ***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink#3 @ 431] [dblink 0431 ]

> M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]

> M in_ThErrHandle: 1

> M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]

It seems your xuser data got hosed.

I would

- change the user SAPService<SID> and enable it to logon

- logon with that user

- open a cmd.exe and execute

xuser -U DEFAULT -u <sapschema>,<password> -d <SID> -n <hostname> set

Then try to connect using "r3trans -d".

Markus

[s0007045141]

Hi Mark, thanks for your help, I did what you told me, but now I get this error

DB max. input host variables : 2000

C INFO : SAP DB Packet_Size = 131072

C INFO : SAP DB Min_Reply_Size = 4096

C INFO : SAP DB Comm_Size = 126976

C INFO : DBSL buffer size = 126976

C INFO : SAP DB MaxLocks = 300000

C INFO : Connect to DB as 'SAPSED'

C *** ERROR => the connected user (SAPSID) does not work with the right user/schema

[dbslsdb.cpp 4818]

C *** ERROR => application has to work with schema SAPR3 (dbs/ada/schema)

[dbslsdb.cpp 4820]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]

M

M Info for wp 0

M

I have this parameters on the start profile

rsdb/dbid = SED

dbs/ada/schema=SAPR3

and xuser list shows

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPSED

UsernameUCS2:S.A.P.S.E.D. . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SED

Nodename :sirillium1

Sqlmode :<unspecified>

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

-

---

R3trans -d, ends with (000) code

any idea?

regards

[markus_doehr2]

then please use

xuser -U DEFAULT -u SAPR3,<password> -d <SID> -n <hostname> set

Markus

[s0007045141]

Mark, it seems to be SAPR3 but right now we face this new error

C INFO : Connect to DB as 'SAPR3'

C Command info enabled

C Now I'm connected to SAP DB

C 00: sirillium1-SED, since=20110517203314, ABAP= <unknown> (0)

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20110517 203314 sirillium1

C *** ERROR => prepare() of C_0000, rc=1, rcSQL=-942 (POS(28) Unknown table name:SVERS)

[dbsdbsql.cpp 1531]

C *** ERROR => SQL PREPARE on connection 0, rc=-942 (POS(28) Unknown table name:SVERS)

[dbslsdb.cpp 7201]

C sc_p=000000000CF8E0C0,no=0,idc_p=0000000000000000,con=0,act=0,slen=34,smax=256,#vars=0,stmt=0000000002E8EC40,table=SVERS

C SELECT VERSION INTO ? FROM SVERS ;

B ***LOG BZA=> table SVERS does not exist on database [dblink#3 @ 1299] [dblink 1299 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1449]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]

any new idea.

regards

[markus_doehr2]

SAPR3 may be available but apparently it's the wrong user.

Are you sure you just exchanged the kernel binaries? Seems to me like other things were changed too.

I'd now use DBStudio and check whether SAPR3 is the proper user and whether table SVERS is available for that user.

Markus

[s0007045141]

Mark, let me ask you, could a DB restore solve this at this point? what do you think?

It is very strange this error.}

regards

[former_member229109]

Hello,

1. Did you downgrade the SAP kernel? Or database kernel?

I recommend to create the SAP message and get SAP support.

2. Before to change the XUSER entry run the checks on the database server:

• Use sdbverify as root user to check the installation of the database software;

• Check what is the name of the database & if it's registered.

• Check if your database is restartable.

Check the database users - "select * from users", and if you know the database user's passwords to connect to the

database.

• What is the schema user in your database, the owner of the application data ?

3. Did you initialize the database using "db_activate" command?

If yes => database is empty.

Then you need to look for the databackup which has your data & restore your database, first check the backup history,

dbm.prt, dbm.utl < database version <= 7.6 >.

Please review the note:

1377148 FAQ: SAP MaxDB backup/recovery

Regards, Natalia Khlopina

[s0007045141]

Natalia, this system was not resored nor copied, it was up and running before kernel update. We did some of the tests you said and someothers, here are some outputs.

We update kernel to release 142

R3trans -d and -x exit with (all with user SIDADM)

SVERS table does exist and belongs to SAPSID

dbmcli on SID>sql_execute select * from domain.tables where tablename='SVERS'

OK

END

'SAPSID';'SAPSID';'SVERS';'';'TABLE';'TABLE';'20100406';'00054637';'20100406';'00054637';'20100406';'00054638';'NO';(null);20000;(null);x'0000000000004842';'NO';'NO';'YES';'NO';(null)

Why it still says that SVERS table does not exist and SQL error 942?

C Now I'm connected to SAP DB

C 00: server1-SID, since=20110518015619, ABAP= <unknown> (0)

B Connection 0 opened (DBSL handle 0)

C *** ERROR => prepare() of C_0000, rc=1, rcSQL=-942 (POS(28) Unknown table name:SVERS) [

dbsdbsql.cpp 1604]

C *** ERROR => SQL PREPARE on connection 0, rc=-942 (POS(28) Unknown table name:SVERS) [dbslsdb.cpp 7253]

C sc_p=000000000CFAECC0,no=0,idc_p=0000000000000000,con=0,act=0,slen=34,smax=256,#vars=0,stmt=0000000002EA0AF0,table=SVERS

C SELECT VERSION INTO ? FROM SVERS ;

B ***LOG BZA=> table SVERS does not exist on database [dblink#4 @ 1301] [dblink 1301 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1515]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10824]

M

Users seem to be ok

dbmcli on SID>sql_execute SELECT username, usermode FROM users

OK

END

'CONTROL';'ADMIN'

'SUPERDBA';'SYSDBA'

'SAPSID';'DBA'

'SAPR3';'DBA'

User SAPR3 does not have anything on database

dbmcli on SID>sql_execute select * from domain.tables where owner='SAPR3'

ERR

-24988,ERR_SQL: SQL error

100,Row not found

Any idea?

regards

[former_member229109]

Hello,

1. Is your database SID?

Why it was SED with schema user - SAPSED at the beginning of the thread?

Why did you change the XUser entry for the default key to SAPR3, if the SAPSID user is the schema user?

2. Please check first, what is the database name and schema user, which is the owner of the application data.

Check that you know the passwords of the all database users & able to connect to the database using those users/passwords.

Then change the XUSER entries - SAP note 39439.

Login as <SID>adm user and check if you connect to the database with default key:

dbmcli -d SID -U c -USQL DEFAULT sql_execute "select * from users"

<enter>

Regards, Natalia Khlopina

[s0007045141]

Hi Natalia, this is what you ask for, I think

C:\Documents and Settings\sedadm.SIRILLIUM1>dbmcli -d SED -U c -USQL DEFAULT sql

_execute "select * from users"

OK

END

'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'201004

05';'00232333';'20100405';'00232333';'20100405';'00232333';'SED';'sirillium1';0;

'NO';(null)

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'201

00405';'00232332';'20100405';'00232332';'20100405';'00232332';'SED';'sirillium1'

;10;'NO';(null)

'SUPERDBA';'';'SAPSED';'DBA';'MULTIPLE';(null);(null);(null);'UNICODE';'20100405

';'00232343';'20100405';'00232343';'20100405';'00232343';'SED';'sirillium1';28;'

NO';(null)

'SUPERDBA';'';'SAPR3';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20110516'

;'00215710';'20110516';'00215710';'20110516';'00215710';'SED';'sirillium1';32;'N

O';(null)

In fact our system is called SED.

I can not attached images to this post but when database is started and SAP starts we can see conenctions and sessions, but after a few second WPs die

thanks a lot for your help

[former_member229109]

Hello,

so you corrected the XUSER entry. Correct?

What is the error now?

Check the dev log => Did you see the database errors?

Regards, Natalia Khlopina

[s0007045141]

Hi Natalia, we restore a Database backup but now we face this error

C Tue May 24 14:02:46 2011C *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination) [dbsdbsql.cpp 137]

We test all users/password, and everything is ok, but SAPR3 is not a defined user on the restore. We are thinking about to reinstall the whole system again

Regards

[former_member229109]

Hello,

Did you follow all steps of the note:

129352 Homogeneous system copy with MaxDB (SAP DB)

?

Please pay attention to 2.d) step of this note.

Please post the output of the SQL command "select * from users".

What are the versions of the source and target database?

What are the database users in the source database?

Regards, Natalia Khlopina

[Former Member]

Hi Natalia,

I have created Development server from Offline backup of Prd server with backup restore method.

i have changed the SID & restored the backup successfully, then i proceed as per the step mentioned in the note 129352 & 39439.

however after successful restoration R3trans working fine but i am not able to start SAP instance dispatcher stopped after

& process get ended with err1.

source System information

SID: PST

Os: win 2003

database: max db 5.0

Backup type: Offline full backup

Target system

SID: DST

Os: win 2003

database: max db 5.0

Backup type: Offline full backup

may i know why this is happening.

Regards

Amol

[Former Member]

Hi Natalia,

I am also facing the same issue my db is MAXDB 7.7. if your issue was solved . please provide the solution

regards,

krishna