Error in SPAM update (connect failed due to DbSL load lib failure)

[Former Member]

Hello,

I´m trying to update the SPAM (version 620) from level 45 to the latest level 50. The OS is a Windows Server 2003 and SQL Server 2000.

I need to do this SPAM update for I can done the update of Support Packages to the latest stack for version 640 (stack 27) Web AS. This is necessary for I can do the upgrade our SQL Server from 2000 to 2005 and next I will do the upgrade SAP system from BW 3.1 Content to SAP BW 7.02 (EHP2). But first of all I need to update the SPAM, but I´m facing the following error:

-   Error in phase: CHECK_REQUIREMENTS

-   Reason for error: TP_CANNOT_CONNECT_SYSTEM

-   Return code: 0249

-   Error message: connect failed due to DbSL load lib failure

I checked some logs...

- In TP system log:

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to BWP failed (20131108212757).

- In action log:

Import phase 'CHECK_REQUIREMENTS' (08.11.2013, 21:39:48)

Error during executing the tp command 'tp CONNECT BWP   ...'

tp return code: '0249' , tp message: 'connect failed due to DbSL load lib failure' , tp output:

   This is tp version 340.16.72 (release 640)

   ERROR: No connect due to DbSl Load Lib Failure

   ERROR: environment variable dbms_type is not set.

   ERROR: Connect to BWP failed (20131108213948).

   INFO: no trace information stored

   tp returncode summary:

   TOOLS: Highest return code of single steps was: 0

   ERRORS: Highest tp internal error was: 0249

   standard output from tp and from tools called by tp:

.

Interrupt the import due to an error situation (08.11.2013, 21:39:48)

Display detailed informations concerning the error in phase 'CHECK_REQUIREMENTS'

Abort the import due to an error situation (08.11.2013, 21:39:50)

- I ran the command r3trans -d, this is the output of it:

4 ETW000 r3trans version 6.13 (release 640 - 17.09.12 - 20:12:05 ).

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

4 ETW000

4 ETW000 date&time   : 08.11.2013 - 21:41:15

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]  Fri Nov 08 21:41:19 2013                                  0.000000

4 ETW000  [dev trc     ,00000]  db_con_init called                                        0.000000

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

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

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

4 ETW000                                                                             641  0.000641

4 ETW000  [dev trc     ,00000]      using "C:\usr\sap\BWP\SYS\exe\run\dbmssslib.dll"

4 ETW000                                                                              11  0.000652

4 ETW000  [dev trc     ,00000]  Library 'dbmssslib.dll' loaded                         9  0.000661

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

4 ETW000                                                                              11  0.000672

4 ETW000  [dev trc     ,00000]  Version of 'dbmssslib.dll' is "640.00", patchlevel (0.405)

4 ETW000                                                                              88  0.000760

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

4 ETW000                                                                              12  0.000772

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

4 ETW000                                                                              11  0.000783

4 ETW000  [dev trc     ,00000]  New connection 0 created                              16  0.000799

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                                                                              27  0.000826

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

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

4 ETW000                                                                              11  0.000849

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                                                                              19  0.000868

4 ETW000  [dev trc     ,00000]  Thread ID:368                                       1358  0.002226

4 ETW000  [dev trc     ,00000]  Thank You for using the SLOLEDB-interface             12  0.002238

4 ETW000  [dev trc     ,00000]  Using dynamic link library 'C:\usr\sap\BWP\SYS\exe\run\dbmssslib.dll'

4 ETW000                                                                              17  0.002255

4 ETW000  [dev trc     ,00000]  dbmssslib.dll patch info                              40  0.002295

4 ETW000  [dev trc     ,00000]    patchlevel   0                                       9  0.002304

4 ETW000  [dev trc     ,00000]    patchno      405                                     7  0.002311

4 ETW000  [dev trc     ,00000]    patchcomment Poor performance with isolation level read committed (1721164)

4 ETW000                                                                              12  0.002323

4 ETW000  [dev trc     ,00000]  np:(local) connection used on SRVAP08                 40  0.002363

4 ETW000  [dev trc     ,00000]  CopyLocalParameters: dbuser is 'bwp'                   9  0.002372

4 ETW000  [dev trc     ,00000]  Provider SQLNCLI could not be initialized. See note #734034 for more information.

4 ETW000                                                                            4987  0.007359

4 ETW000  [dev trc     ,00000]  Using provider SQLOLEDB instead.                      10  0.007369

4 ETW000  [dev trc     ,00000]  OpenOledbConnection: MARS property was not set.      119  0.007488

4 ETW000  [dev trc     ,00000]  Provider Release:08.10.3959                         8931  0.016419

4 ETW000  [dev trc     ,00000]  Provider SQLNCLI could not be initialized. See note #734034 for more information.

4 ETW000                                                                             539  0.016958

4 ETW000  [dev trc     ,00000]  Using provider SQLOLEDB instead.                      10  0.016968

4 ETW000  [dev trc     ,00000]  Cache sizes: header 88 bytes, 100 names (140800 bytes), 100 dynamic statements (551200 bytes), total 692088 bytes

4 ETW000                                                                            3084  0.020052

4 ETW000  [dev trc     ,00000]  Initializing private procedure name cache.            11  0.020063

4 ETW000  [dev trc     ,00000]  procedure cache created/attached                      10  0.020073

4 ETW000  [dev trc     ,00000]  Connected to db server : [SRVAP08] server_used : [np:(local)], dbname: BWP, dbuser: bwp

4 ETW000                                                                              14  0.020087

4 ETW000  [dev trc     ,00000]  pn_id:SRVAP08_BWPBWP                                   8  0.020095

4 ETW000  [dev trc     ,00000]  Not using MARS (on sql 8.0)                            9  0.020104

4 ETW000  [dev trc     ,00000]  Connection 0 opened (DBSL handle 0)                   11  0.020115

4 ETW000  [dev trc     ,00000]  NTAB: Structure of NTAB on DB is VERS_B             6012  0.026127

4 ETW000  [dev trc     ,00000]  NTAB: UNICODELG(SVERS) = 1, SAP_UC_LN = 1             15  0.026142

4 ETW000  [dev trc     ,00000]  NTAB: standalone processing                           27  0.026169

4 ETW000  [dev trc     ,00000]  NTAB: read profile                                    13  0.026182

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/entrycount 1000.                      11  0.026193

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/ftabsize 500.                         12  0.026205

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/irbdsize 100.                         11  0.026216

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/sntabsize 100.                        11  0.026227

4 ETW000  [dev trc     ,00000]  NTAB: compute_hash_card: 2003.                       109  0.026336

4 ETW000  [dev trc     ,00000]  NTAB: maxcnt 1000.                                    18  0.026354

4 ETW000  [dev trc     ,00000]  NTAB: hfactor 2003.                                    8  0.026362

4 ETW000  [dev trc     ,00000]  NTAB: mem_protocol_size 104                            6  0.026368

4 ETW000  [dev trc     ,00000]  NTAB: hdr_backpack_offset 0                            7  0.026375

4 ETW000  [dev trc     ,00000]  NTAB: hdr_backpack_size 0                              7  0.026382

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: header_size 80.                            6  0.026388

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: item_size 64.                              7  0.026395

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: item_cnt 1000.                             7  0.026402

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: unit_size 4                                7  0.026409

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: unit_cnt 128000.                          11  0.026420

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: data_size 512000.                          9  0.026429

4 ETW000  [dev trc     ,00000]  NTAB: IREC: header_size 80.                            7  0.026436

4 ETW000  [dev trc     ,00000]  NTAB: IREC: item_size 64.                              7  0.026443

4 ETW000  [dev trc     ,00000]  NTAB: IREC: item_cnt 250.                              6  0.026449

4 ETW000  [dev trc     ,00000]  NTAB: IREC: unit_size 8                               10  0.026459

4 ETW000  [dev trc     ,00000]  NTAB: IREC: unit_cnt 12800.                            7  0.026466

4 ETW000  [dev trc     ,00000]  NTAB: IREC: data_size 102400.                          6  0.026472

4 ETW000  [dev trc     ,00000]  NTAB: STAB: header_size 80.                            7  0.026479

4 ETW000  [dev trc     ,00000]  NTAB: STAB: item_size 64.                              7  0.026486

4 ETW000  [dev trc     ,00000]  NTAB: STAB: item_cnt 250.                              6  0.026492

4 ETW000  [dev trc     ,00000]  NTAB: STAB: unit_size 4                                7  0.026499

4 ETW000  [dev trc     ,00000]  NTAB: STAB: unit_cnt 25600.                            6  0.026505

4 ETW000  [dev trc     ,00000]  NTAB: STAB: data_size 102400.                          7  0.026512

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: header_size 184.                           7  0.026519

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: item_size 40.                              7  0.026526

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: item_cnt 1000.                             6  0.026532

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: unit_size 152                              7  0.026539

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: unit_cnt 1000.                             6  0.026545

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: data_size 152000.                          7  0.026552

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: hh_p 29f540, hh_len 80                   427  0.026979

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: aa_p 2a5b80, aa_len 16024                 14  0.026993

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: ia_p 2a9a30, ia_len 64000                  7  0.027000

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: dat_p 9f70080, dat_len 512000              8  0.027008

4 ETW000  [dev trc     ,00000]  NTAB: IREC: hh_p 29f5a0, hh_len 80                     7  0.027015

4 ETW000  [dev trc     ,00000]  NTAB: IREC: aa_p 2b9a30, aa_len 16024                  7  0.027022

4 ETW000  [dev trc     ,00000]  NTAB: IREC: ia_p 2bd8e0, ia_len 16000                  7  0.027029

4 ETW000  [dev trc     ,00000]  NTAB: IREC: dat_p 9fee080, dat_len 102400              7  0.027036

4 ETW000  [dev trc     ,00000]  NTAB: STAB: hh_p 29f600, hh_len 80                     7  0.027043

4 ETW000  [dev trc     ,00000]  NTAB: STAB: aa_p 2c1770, aa_len 16024                  8  0.027051

4 ETW000  [dev trc     ,00000]  NTAB: STAB: ia_p 2c5620, ia_len 16000                  7  0.027058

4 ETW000  [dev trc     ,00000]  NTAB: STAB: dat_p a008080, dat_len 102400              7  0.027065

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: hh_p 285d60, hh_len 184                    7  0.027072

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: aa_p 2c94b0, aa_len 16024                  7  0.027079

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: ia_p a022080, ia_len 40000                 8  0.027087

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: dat_p a02c080, dat_len 152000              7  0.027094

4 ETW000  [dev trc     ,00000]  NTAB: ntab_mem_protocol 285d60, ntab_mp_p 285d60, ntab_proc_id 0

4 ETW000                                                                              16  0.027110

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: hh_p 29f540, ha_list 2a5b80, hi_list 2a9a30, buffer 9f70080

4 ETW000                                                                              57  0.027167

4 ETW000  [dev trc     ,00000]  NTAB: IREC: hh_p 29f5a0, ha_list 2b9a30, hi_list 2bd8e0, buffer 9fee080

4 ETW000                                                                              12  0.027179

4 ETW000  [dev trc     ,00000]  NTAB: STAB: hh_p 29f600, ha_list 2c1770, hi_list 2c5620, buffer a008080

4 ETW000                                                                              11  0.027190

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: hh_p 285dc8, ha_list 2c94b0, hi_list a022080, buffer a02c080

4 ETW000                                                                              14  0.027204

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000                                                                              15  0.027219

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000                                                                              18  0.027237

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000                                                                              16  0.027253

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000                                                                              16  0.027269

4 ETW000  [dev trc     ,00000]  Found proc Y3I0000036CMAEK0013DDNTFi1o4ns on db - doesn't exist in cache

4 ETW000                                                                             233  0.027502

4 ETW000  [dev trc     ,00000]  DbSlBegRead[0]: Y3I0000036CMAEK0013DDNTFi1o4ns        12  0.027514

4 ETW000  [dev trc     ,00000]  Found proc Y3I00002B9DMAEK0009DDNTTut01i1o21ns on db - doesn't exist in cache

4 ETW000                                                                             561  0.028075

4 ETW000  [dev trc     ,00000]  { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:695}

4 ETW000                                                                             326  0.028401

4 ETW000  [dev trc     ,00000]  Found proc Y3R40000001C7QB0615TADIRut01i3o17ns on db - doesn't exist in cache

4 ETW000                                                                             215  0.028616

4 ETW000  [dev trc     ,00000]  } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )

4 ETW000                                                                             248  0.028864

4 ETW000 Connected to DBMS = MSSQL ---  SERVER = 'srvap08' DBNAME = 'BWP' --- SYSTEM = 'BWP'.

4 ETW000  [dev trc     ,00000]  { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1353}

4 ETW000                                                                             180  0.029044

4 ETW000  [dev trc     ,00000]  DbSlBegRead[0]: Y3I0000036CMAEK0013DDNTFi1o4ns       288  0.029332

4 ETW000  [dev trc     ,00000]  Found proc Y3R10000000C24K2842PATCHHIST on db - doesn't exist in cache

4 ETW000                                                                             462  0.029794

4 ETW000  [dev trc     ,00000]  } db_rtab( fcode = 'RT_INSERT', retcode = 0 )        219  0.030013

4 ETW000  [dev trc     ,00000]  dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000                                                                              28  0.030041

4 ETW000  [dev trc     ,00000]  dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8)         27  0.030068

4 ETW000  [dev trc     ,00000]  Provider SQLNCLI could not be initialized. See note #734034 for more information.

4 ETW000                                                                             115  0.030183

4 ETW000  [dev trc     ,00000]  Using provider SQLOLEDB instead.                       9  0.030192

4 ETW000  [dev trc     ,00000]  DbSlBegRead[2]: ##Y3SRVAP08bwp00000021920000000003214119

4 ETW000                                                                            2494  0.032686

4 ETW000  [dev trc     ,00000]  dsql_close (con_da=(0,R/3),cu_id=1)                 2634  0.035320

4 ETW000  [dev trc     ,00000]  { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1465}

4 ETW000                                                                              30  0.035350

4 ETW000  [dev trc     ,00000]  Found proc Y3R30000001C24K2842PATCHHIST on db - doesn't exist in cache

4 ETW000                                                                             219  0.035569

4 ETW000  [dev trc     ,00000]  } db_rtab( fcode = 'RT_DELETE', retcode = 0 )        218  0.035787

4 ETW690 "0" "0"

4 ETW000  [dev trc     ,00000]  db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)

4 ETW000                                                                              69  0.035856

4 ETW000 COMMIT (0).

4 ETW000  trace to file pointer closed

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

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time   : 08.11.2013 - 21:41:19

4 ETW000 function    : CONNECT

4 ETW000 buffersync  : YES

4 ETW000 clients     : default

4 ETW000 l.s.m.      : VECTOR

4 ETW000 commit      : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000  [dev trc     ,00000]  Disconnecting from ALL connections:                   77  0.000077

4 ETW000  [dev trc     ,00000]  Disconnected from connection 0                       511  0.000588

4 ETW000  [dev trc     ,00000]  statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000                                                                              37  0.000625

4 ETW000  [dev trc     ,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000                                                                              12  0.000637

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 08.11.2013 - 21:41:19

- I checked the environment variable DBMS_TYPE and everything is OK:

- I also check the STMS and the transport tool show me the following error:

So... any tips about this error?! Can you help me please, how can I solve this problem?!... this is urgent... please!!!

Thank you in advance,

regards,

samid raif

[joo_migueldimas · Accepted solution]

Hello raif,

You posted this:

- In TP system log:
ERROR: No connect due to DbSl Load Lib Failure
ERROR: environment variable dbms_type is not set.
ERROR: Connect to BWP failed (20131108212757)

Have you check the environment variables in regedit!? Sometimes you can see them in Operation System properties in MS Windows environment variables settings but in fact when you start a SAP system, the system will read first this environment variables in regedit through the SAPService<SID> user! So maybe that´s the problem here!

Try this... go to the following path in regedit and check if you see any environment variable set:

HKEY_LOCAL_MACHINE/Software/SAP/<SID>

If not see them there, you need to recreate them like you exactly see in the operation system environment variables settings!! After that, reboot your server and try again the SPAM importing!

Please, also read the following notes:

128126  - Database connect for external tools

31559  - NT: Setting environment variables for R/3 kernel

1921560 - <sid>adm environment variable is not read when SAP  starting

Kind regards,

João Dimas

[Former Member · Accepted solution]

Hello João Dimas,

Wow... that´s it!! 
It´s solved!
I followed what you recommended. In fact I didn´t had any environment variable in that location, in regedit!! Therefore, I created them and now everything is ok, I can continue with SPAM importation without problems!

So, thank you very much for your awesome tip! And I also thank to all you that tried to help me!

regards

samid raif

[Sriram2009]

Hi

1.  Have you updated the latest kernel & DBSL patch? 

2. In your Transport Domain controller client 000 add the parameters "system_pf= \\<localhost>\sapmnt\<SID>\sys\profile\default.pfl

3. Kindly refer the SAP Note 734034  - Native OLEDB provider SQLNCLI

Regards

Sriram

[Former Member]

Hello Aidan and Sriram,

Yes, I performed a kernel update before the error (from level 390 to the latest one the level 427 - Kernel version 640), I don´t know if this is related with that or not... the system starts well without problems, so I concluded that everything is fine...!

... any tip?

Kind regards,

samid raif

[Sriram2009]

Hi Samid

What about point number 2 & 3 ?

2. In your Transport Domain controller client 000 add the parameters "system_pf= \\<localhost>\sapmnt\<SID>\sys\profile\default.pfl

3. Kindly refer the SAP Note 734034  - Native OLEDB provider SQLNCLI

Regards

Ram

[Former Member]

Hi,

For the kernel i was able to find kernel 414(database dependent and independent) and then dw patch of 429 but dint find any 427 patch in the kernel for 640.

Check what patch level you have for R3trans ,Tp and dbsl. And try the latest that you can find.

Thanks

Rishi Abrol

[Former Member]

Hello Sriram,

I did those two recomendations... but it doesn´t solved the error in SPAM update 😞

Any tips?

Kind regards,

samid

[Former Member]

Hello Rishi,

I downloaded the latest kernel patch as you recommended, now my system runs with the 429 patch level the DBSL patch level is 405! But unfortunatelly the SPAM update still show me the same error!

I have one question regarding one thing that is for me very strange! The Kernel directory where I updated the SAP Kernel files is in C:\usr\sap\BWP\SYS\exe\run but the DIR_CT_RUN in transaction AL11 has this value -->  C:\usr\sap\BWP\SYS\exe\NUC\NTAMD64

But I don´t have in the server that path, it doesn´t exist --> C:\usr\sap\BWP\SYS\exe\NUC\NTAMD64

The DIR_EXECUTABLE has the value --> C:\usr\sap\BWP\SYS\exe\run

It was in this path that I applied the Kernel files that I updated to the latest patch level.

Can you tell me if this the problem... this is normal!?

kind regards

samid raif

[Former Member]

Hi,

If <DIR_CT_RUN> above is the value of DIR_CT_RUN profile parameter.

If this directory is not present or empty, use <DIR_EXECUTABLE> instead.

Usually the Default location is /usr/sap/<SID>/SYS/exe/[uc/NUC]/<platform>.

But usually files should be copied in dir /sapmnt/SID/exe

This note will explain you that this is not the issue.

664679 - Installing 6.40 kernel in SAP WEB AS 6.10/6.20

Thanks

Rishi Abrol

[former_member264034]

Hi,

Note regarding the issue tp is failing to connect due to lack of some
important db related environment variable. So hence in order to rectify
the error kindly check oss note:

128126     Database connect for external tools
and set the environment variable written there and try again .

Regarding the error
"connect failed due to DbSL load lib failure"

Did you update your kernel and/or tp/R3trans?

Regards,

Aidan