SAP system not starting after restart?

[Former Member]

Hi Experts,

we are getting below error when we restarted our ECC system?

R3trans -d shows below error

This is r3trans version 6.24 (release 720 - 19.03.13 -
20:13:03 ).

unicode enabled version

sizeof(Selection_t) = 272

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor
in Commandline

2EETW169 no connect possible: "DBMS =
MSSQL                          
---  SERV

ER = 'GDCCORSAP05' DBNAME = 'SIL'"

r3trans finished (0012).

trans.log shows below error

4 ETW000 r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 26.12.2013 - 10:06:54

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]  Thu Dec 26 10:06:54 2013                                               14647  0.014647

4 ETW000  [     dev trc,00000]  db_con_init called                                                        78  0.014725

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used       118  0.014843

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  64  0.014907

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbmssslib.dll' ...                                  5794  0.027269

4 ETW000  [     dev trc,00000]  Thu Dec 26 10:06:55 2013                                              408639  0.435908

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

4 ETW000                                                                                                 120  0.436028

4 ETW000  [     dev trc,00000]      using "E:\usr\sap\SIL\SYS\exe\uc\NTAMD64\dbmssslib.dll"               35  0.436063

4 ETW000  [     dev trc,00000]  Library 'dbmssslib.dll' loaded                                            53  0.436116

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

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "720.00", patchlevel (0.218)             66793  0.502957

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

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

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  67  0.503143

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  78  0.503221

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

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  55  0.503354

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          29  0.503383

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  58  0.503441

4 ETW000  [     dev trc,00000]  Thread ID:5888                                                          8230  0.511671

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

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

4 ETW000                                                                                                  65  0.511795

4 ETW000  [     dev trc,00000]  dbmssslib.dll patch info                                                  82  0.511877

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                      179  0.512056

4 ETW000  [     dev trc,00000]    SAP patchno  300                                                        48  0.512104

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                            33  0.512137

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         218                                     31  0.512168

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment Stored procedure delivers no rows in EXEC SQL or ADBC (1330085)

4 ETW000                                                                                                  52  0.512220

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                2049  0.514269

4 ETW000  [     dev trc,00000]  lpc:(local) connection used on GDCCORSAP05                               864  0.515133

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2351]

4 ETW000                                                                                               23174  0.538307

4 ETW000  [     dev trc,00000]  (0) [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

4 ETW000                                                                                                  60  0.538367

4 ETW000  [     dev trc,00000]  1 times error (0,0) or (-1,0) in sequence                                 41  0.538408

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2351]

4 ETW000                                                                                                2613  0.541021

4 ETW000  [     dev trc,00000]  (0) [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

4 ETW000                                                                                                  58  0.541079

4 ETW000  [     dev trc,00000]  2 times error (0,0) or (-1,0) in sequence                                 32  0.541111

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2351]

4 ETW000                                                                                                2537  0.543648

4 ETW000  [     dev trc,00000]  (0) [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

4 ETW000                                                                                                  55  0.543703

4 ETW000  [     dev trc,00000]  3 times error (0,0) or (-1,0) in sequence                                 32  0.543735

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2351]

4 ETW000                                                                                                2576  0.546311

4 ETW000  [     dev trc,00000]  (0) [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

4 ETW000                                                                                                  57  0.546368

4 ETW000  [     dev trc,00000]  4 times error (0,0) or (-1,0) in sequence                                 33  0.546401

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2351]

4 ETW000                                                                                                2405  0.548806

4 ETW000  [     dev trc,00000]  (0) [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

4 ETW000                                                                                                  55  0.548861

4 ETW000  [     dev trc,00000]  5 times error (0,0) or (-1,0) in sequence                                 32  0.548893

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2351]

4 ETW000                                                                                                2952  0.551845

4 ETW000  [     dev trc,00000]  (0) [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

4 ETW000                                                                                                 106  0.551951

4 ETW000  [     dev trc,00000]  6 times error (0,0) or (-1,0) in sequence                                 35  0.551986

4 ETW000  [     dev trc,00000]  errclass set to DBSL_EC_RESTART                                           31  0.552017

4 ETW000  [     dev trc,00000]  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                           31  0.552048

4 ETW000  [     dev trc,00000]  Connection 0 failed using Driver={SQL Server Native Client 10.0};Server=GDCCORSAP05;AutoTranslate=no;Trusted_Connection=yes;WSID=GDCCORSAP05;APP=R3 00 comm rd ODBC;Database=SIL;

4 ETW000                                                                                                  68  0.552116

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error -1     performing CON                            16483  0.568599

4 ETW000  [    dblink  ,00000]  ***LOG BY0=> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed             63  0.568662

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'GDCCORSAP05' DBNAME = 'SIL'"

[AtulKumarJain · Accepted solution]

Hi ,

Please check

Starting and Stopping the SQL Server (SAP Library - BC R/3 Database Guide: MS SQL Server)

BR

atul

[Former Member · Accepted solution]

Hi Atul,

Thanks for your reply.

i have gone through the document

MSSQLServer is up and running.But,SQLServerAgent is not running.

Do you think if it is the problem with SQLServerAgent?

Thanks

SAP ADMIN

[Reagan · Accepted solution]

Do you think if it is the problem with SQLServerAgent?

Start - Run - services.msc

SQLServerAgent - Start

Restart SAP

Regards

RB

[Former Member]

Hi,

Can check the below note to identify the issue.

98678 - SQL Server Connection Issues

Thanks

RishI Abrol

[Former Member]

Hi All,

Thanks for your answers.

It was the  problem with the native client.

downloaded Security Update from below link and installed  it.(This is the existing security update level of SQL server)

http://www.microsoft.com/en-in/download/details.aspx?id=26315

Thnaks

SAP ADMIN

[former_member186228]

Hi,

Have you performed db restoration?

check below thread hope this will help you.

http://scn.sap.com/thread/3467412

Regards,

Jithin

[Former Member]

Hi,

Did you check the log area , it is not full na????

If fulll clean it then try,

Rableen

[karthikeyan_natarajan4]

Is your database is running? please check.