Unable to start the work process

[Former Member]

Dear All,

When I start my sap instance, its unable to start. All the work process are ENDED with the below error messages.

developer trace

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 ]

could any suggest me what could be the problem.

thanks & regards,

Guna

[former_member185031]

What is your Database version?

You should execute R3trans -d and check the trans.log

Regards,

Subhash

[Former Member]

Hi,

Thanks for your reply.

OS : Windows 2008 R2 Std

DB : MS SQL 2008 R2

R3trans -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: 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

Waiting for your suggestion.

regards,

Guna

[vincentlim826]

Hi,

did you do any DB restore and recovery or upgrade ?

check your MSSQL env setting variables, ie:

MSSQL_SCHEMA

MSSQL_DBNAME

MSSQL_SERVER

DBMS_TYPE

and also review SAP note 128126 & 592514 & 1294762

Hope this helps.

Regards,

Vincent