Error in MAIN_SWITCH/STARTSAP_TRANS phase...

[Former Member]

Dear All,

We're installation Ehp4 using ehpi on our ECC 6.0 system and during the DOWNTIME phase, we're facing an issue while executing the MAIN_SWITCH/STARTSAP_TRANS phase... it tries to start the SAP instance but its failed due to the below issue.

-

---

Checks after phase MAIN_SWITCH/STARTSAP_TRANS were negative!

Last error code set: RFC call to subst_get_uvers failed with key

RFC_ERROR_COMMUNICATION (open): SAP_CMINIT3 : rc=20 > Connect to SAP

gateway failed Connect_PM GWHOST=eccserver, GWSERV=sapgw00, SYSNR=00

-

---

*devw0 log*_

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 00

M sid ECD

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 111

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 94604

M

M

M Wed Jun 22 12:40:21 2011

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

M length of sys_adm_ext is 576 bytes

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

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) 17520 (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: 000000000E470050, size: 6601872)

M DpShMCreate: allocated sys_adm at 000000000E470050

M DpShMCreate: allocated wp_adm at 000000000E472270

M DpShMCreate: allocated tm_adm_list at 000000000E4766E0

M DpShMCreate: allocated tm_adm at 000000000E476740

M DpShMCreate: allocated wp_ca_adm at 000000000EA19FC0

M DpShMCreate: allocated appc_ca_adm at 000000000EA1FDC0

M DpShMCreate: allocated comm_adm at 000000000EA21D00

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000EAA8990

M DpShMCreate: allocated gw_adm at 000000000EAA8A10

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000EAA8A40

M DpShMCreate: allocated wall_adm at 000000000EAA8A50

M

M Wed Jun 22 12:40:22 2011

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

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.

X mm.dump: set maximum dump mem to 96 MB

M ThInit: rdisp/cleanup_after_crash = 1

M ThInit: running on host eccserver

M

M Wed Jun 22 12:40:23 2011

M calling db_connect ...

B Loading DB library 'H:\usr\sap\ECD\DVEBMGS00\exe\dbmssslib.dll' ...

B Library 'H:\usr\sap\ECD\DVEBMGS00\exe\dbmssslib.dll' loaded

B Version of 'H:\usr\sap\ECD\DVEBMGS00\exe\dbmssslib.dll' is "700.08", patchlevel (0.105)

C Callback functions for dynamic profile parameter registered

C Thread ID:95092

C Thank You for using the SLODBC-interface

C Using dynamic link library 'H:\usr\sap\ECD\DVEBMGS00\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C SAP patchlevel 0

C SAP patchno 111

C Last MSSQL DBSL patchlevel 0

C Last MSSQL DBSL patchno 105

C Last MSSQL DBSL patchcomment MSSQL: Unicode literals and standalone tools (1494847)

C lpc:(local) connection used on ECCSERVER

C lpc:(local) connection used on ECCSERVER

C Driver: sqlncli10.dll Driver release: 10.50.1702

C GetDbRelease: 10.50.1702

C GetDbRelease: Got DB release numbers (10,50,1702)

C ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 16778]

C (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DBPROPERTIES'.

B Connection 0 opened (DBSL handle 0)

C ERROR: -1 in function StartSelect (execute) [line 10636]

C (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SVERS'.

C ERROR: -1 in function StartSelect (execute) [line 10636]

C (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

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 1505]

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M pid = 94604

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 eccserver_ECD_00 on host eccserver (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Wed Jun 22 12:40:23 2011

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10916

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 730]

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

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 94604) [dpnttool.c 334]

-

---

R3trans -d log

H:\usr\sap\ECD\SYS\exe\uc\NTAMD64>R3trans -d

This is R3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

-

---

Could anyone help us, how to resolve this issue.

thanks in advance

regards,

Guna

[paul_power]

Hello Guna,

Please check system with this note.

Note 1294762 SCHEMA4SAP.VBS

check for results in the SCHEMA4SAP.LOG

Regards,

Paul

[sunny_pahuja2]

Hi,

Could you please check whether SVERS table exist in the database or not ?

Please also paste trans.log after running R3trans -d.

Thanks

Sunny

[Former Member]

Dear Sunny,

Thanks for your reply.

Those tables are available there.

trans.log after excuiting R3trand -d

-

---

4 ETW000 R3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 22.06.2011 - 18:11:21

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Jun 22 18:11:25 2011 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000186D40000

4 ETW000 998 0.000998

4 ETW000 [dev trc ,00000] using "H:\usr\sap\ECD\SYS\exe\uc\NTAMD64\dbmssslib.dll" 20 0.001018

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 21 0.001039

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll 21 0.001060

4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.105) 763 0.001823

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll 28 0.001851

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll 21 0.001872

4 ETW000 [dev trc ,00000] New connection 0 created 42 0.001914

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 63 0.001977

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 29 0.002006

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 20 0.002026

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 56 0.002082

4 ETW000 [dev trc ,00000] Thread ID:96996 1239 0.003321

4 ETW000 [dev trc ,00000] Thank You for using the SLODBC-interface 25 0.003346

4 ETW000 [dev trc ,00000] Using dynamic link library 'H:\usr\sap\ECD\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000 35 0.003381

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 35 0.003416

4 ETW000 [dev trc ,00000] SAP patchlevel 0 18 0.003434

4 ETW000 [dev trc ,00000] SAP patchno 111 23 0.003457

4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchlevel 0 20 0.003477

4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchno 105 36 0.003513

4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchcomment MSSQL: Unicode literals and standalone tools (1494847)

4 ETW000 32 0.003545

4 ETW000 [dev trc ,00000] lpc:(local) connection used on ECCSERVER 355 0.003900

4 ETW000 [dev trc ,00000] lpc:(local) connection used on ECCSERVER 22063 0.025963

4 ETW000 [dev trc ,00000] lpc:(local) connection used on ECCSERVER 6918 0.032881

4 ETW000 [dev trc ,00000] Driver: sqlncli10.dll Driver release: 10.50.1702 7364 0.040245

4 ETW000 [dev trc ,00000] GetDbRelease: 10.50.1702 411 0.040656

4 ETW000 [dev trc ,00000] GetDbRelease: Got DB release numbers (10,50,1702) 23 0.040679

4 ETW000 [dev trc ,00000] ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 16778]

4 ETW000 4095 0.044774

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DBPROPERTIES'.

4 ETW000 36 0.044810

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 47 0.044857

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 15301 0.060158

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SVERS'.

4 ETW000 201 0.060359

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 38 0.060397

4 ETW000 [dev trc ,00000] (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

4 ETW000 34 0.060431

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

4 ETW000 63 0.060494

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 847 0.061341

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DDNTT'.

4 ETW000 44 0.061385

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 39 0.061424

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 699 0.062123

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DDNTT'.

4 ETW000 44 0.062167

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 38 0.062205

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 703 0.062908

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DDNTT'.

4 ETW000 43 0.062951

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 54 0.063005

4 ETW000 [dbntab ,01273] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#9 @ 12739]

4 ETW000 43 0.063048

4 ETW000 [twdydbacc.c ,00571] i:0 38 0.063086

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: PGMID 15 0.063101

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 13 0.063114

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 0 13 0.063127

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 0 13 0.063140

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:4 13 0.063153

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 703 0.063856

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'XXXXT'.

4 ETW000 44 0.063900

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 38 0.063938

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 696 0.064634

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'XXXXT'.

4 ETW000 44 0.064678

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 38 0.064716

4 ETW000 [dev trc ,00000] ERROR: -1 in function StartSelect (execute) [line 10636] 707 0.065423

4 ETW000 [dev trc ,00000] (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'XXXXT'.

4 ETW000 44 0.065467

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 59 0.065526

4 ETW000 [dbntab ,01273] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#9 @ 12739]

4 ETW000 38 0.065564

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0) 6559 0.072123

-

---

regards,

Guna

[sunny_pahuja2]

Could you please also share database and OS version ?

Thanks

Sunny

[Former Member]

Dear Sunny,

OS - Windows 2008 Server R2 std

DB - MS SQL 2008 R2

SAP - ECC 6.0 (Ehp4 is in process)

regards,

Guna

[Former Member]

Dear All,

Anyone please suggest for my issue.

Thanks in advance.

regards,

Guna