Abap Import Error - ERROR: DbSlErrorMsg rc = 29

[Former Member]

Hi All,

Iam installing erp 6 ehp 7 in windows platform. Iam getting an error in Import Abap step.  Please find the attached logs.  See trans.log as below.

4 ETW000 R3trans version 6.24 (release 741 - 04.02.14 - 20:14:02 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 12.08.2014 - 12:23:22

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]  Tue Aug 12 12:23:22 2014                                                 123  0.000123

4 ETW000  [     dev trc,00000]  db_con_init called                                                        51  0.000174

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                  97  0.000271

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

4 ETW000                                                                                                  37  0.000308

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbdb6slib.dll' ...                                    76  0.000406

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbdb6slib.dll"), hdl 0, count 1, addr 000007FEF24F0000

4 ETW000                                                                                                 725  0.001131

4 ETW000  [     dev trc,00000]      using "C:\usr\sap\EC4\SYS\exe\uc\NTAMD64\dbdb6slib.dll"               29  0.001160

4 ETW000  [     dev trc,00000]  Library 'dbdb6slib.dll' loaded                                            33  0.001193

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbdb6slib.dll                    35  0.001228

4 ETW000  [     dev trc,00000]  Version of 'dbdb6slib.dll' is "741.10", patchlevel (0.24)                146  0.001374

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbdb6slib.dll                   35  0.001409

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbdb6slib.dll                  31  0.001440

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  35  0.001475

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

4 ETW000                                                                                                  69  0.001544

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

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

4 ETW000                                                                                                  39  0.001623

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          27  0.001650

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

4 ETW000                                                                                                  60  0.001710

4 ETW000  [     dev trc,00000]  DB6 (DB2 UDB) UNICODE database interface 741.10 [opt]                   5957  0.007667

4 ETW000  [     dev trc,00000]  DB6 shared library (dbdb6slib) patchlevels                                58  0.007725

4 ETW000  [     dev trc,00000]    (0.5) 741: system does not start (note 1896684)                         42  0.007767

4 ETW000  [     dev trc,00000]    (0.5) DB6: DROP INDEX to DROP CONSTRAINT (note 1911087)                 38  0.007805

4 ETW000  [     dev trc,00000]    (0.5) DB6: messages related to SQL_ATTR_DB2TRC_STARTUP_SIZE (note 1836451)

4 ETW000                                                                                                 138  0.007943

4 ETW000  [     dev trc,00000]    (0.5) DB6: return fsupply code to caller (note 1226290)                 48  0.007991

4 ETW000  [     dev trc,00000]    (0.6) DB6: long running SQL for revalidation (note 1925706)             40  0.008031

4 ETW000  [     dev trc,00000]    (0.12) DB6: Micro outage lazy reconnect (note 1434153)                  35  0.008066

4 ETW000  [     dev trc,00000]    (0.14) DB6: slowdown due to SNAP_GET_UTIL on DPF (note 1949164)         48  0.008114

4 ETW000  [     dev trc,00000]    (0.24) DB6: FOR ALL ENTRIES using remote connection (note 1973869)

4 ETW000                                                                                                  50  0.008164

4 ETW000  [     dev trc,00000]  Supported features:                                                       31  0.008195

4 ETW000  [     dev trc,00000]  ..retrieving configuration parameters                                     49  0.008244

4 ETW000  [     dev trc,00000]  ..done                                                                  1580  0.009824

4 ETW000  [     dev trc,00000]  Tue Aug 12 12:23:23 2014                                              624056  0.633880

4 ETW000  [     dev trc,00000]  DB2 library has been loaded.                                              41  0.633921

4 ETW000  [     dev trc,00000]  Info: successfully loaded DB2 library '\\DEV\sapmnt\EC4\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\db2app64.dll'

4 ETW000                                                                                                  54  0.633975

4 ETW000  [     dev trc,00000]  Running with UTF-8 Unicode                                                30  0.634005

4 ETW000  [     dev trc,00000]  DB2 client driver version '10.05.0003'                                211031  0.845036

4 ETW000  [     dev trc,00000]  Running with CLI driver.                                               47569  0.892605

4 ETW000  [     dev trc,00000]  Tue Aug 12 12:23:29 2014                                             5469456  6.362061

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[D:/depot/bas/741_REL/src/dbs/db6/dbdb6.c, 1835] CON = 0 (BEGIN)

4 ETW000                                                                                                  55  6.362116

4 ETW000  [     dev trc,00000]  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication

4 ETW000                                                                                                  64  6.362180

4 ETW000  [     dev trc,00000]  &+     protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location where the error was detected: "

4 ETW000                                                                                                  57  6.362237

4 ETW000  [     dev trc,00000]  &+     2001:0:9d38:6ab8:30b0:254e:854f:99ce".  Communication function detecting the error: "connect".  Protocol specific

4 ETW000                                                                                                  57  6.362294

4 ETW000  [     dev trc,00000]  &+     error code(s): "10061", "*", "*".  SQLSTATE=08001                                                                

4 ETW000                                                                                                  55  6.362349

4 ETW000  [     dev trc,00000]  &+                                                                                                                      

4 ETW000                                                                                                  55  6.362404

4 ETW000  [     dev trc,00000]  &+                                                                                                                      

4 ETW000                                                                                                  60  6.362464

4 ETW000  [     dev trc,00000]  &+                                                                                                                      

4 ETW000                                                                                                  66  6.362530

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[D:/depot/bas/741_REL/src/dbs/db6/dbdb6.c, 1835] (END)

4 ETW000                                                                                                  48  6.362578

4 ETW000  [dbdb6.c     ,00000]  *** ERROR => DbSlConnect to 'EC4' as 'sapec4' failed                     353  6.362931

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'EC4'"

Thanks,

Sam

Log.txt.zip

[Former Member · Accepted solution]

Check the state of your DB2 instance.

[Former Member · Accepted solution]

Hi Deepak,

How can i make sure that ports are free.

Thanks,

Samson

[former_member188883 · Accepted solution]

Hi Samson,

Please check db2 is listening on port 5000 using the command

netstat -an | find 5000

If you find other service rather than db2 servicename then free up this port

Secondly check whether TCP/IP parameters are set correctly or not using db2 set all command

ensure following set

DB2COMM=TCPIP

svcename 50000

If not then set it using the command or modifying the windows envionment variable.

db2set DB2COMM=TCPIP

db2 update dbm cfg using svcename 50000

Also check in the /etc/drivers /services whether db2 tcp/ip port is mention as 5000

Finally ensure windows firewall is disabled to have these ports open.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

iam unable to run command netstat command and when i use

db2 update dbm cfg using svcename 50000 command getting a message as follows.

DB21061E  Command line environment not initialized.

Thanks,

Sam

[former_member188883 · Accepted solution]

Hi Samson,

Please login with sidadm

open command prompt

execute db2cmd

Then execute execute db2 command shared above

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Thanks for the quick and prompt response. Executed above command and got message as "

DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed

successfully". Firewall is also off. So now  can i start the installation again.

Thanks,

Sam

[former_member188883 · Accepted solution]

Hi Samson,

Is the ABAP import running now ?

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

No. Its not running as installation is stopped.Can i start the installation again.

Thanks,

Sam

[former_member188883 · Accepted solution]

Hi Samson,

just confirm the changes you have done one more time and then start the installation.

Regards,

Deepak Kori

[former_member188883]

Hi Samson,

Looks like the db2 tcp/ip ports are already being used by some other processes.

Please ensure these ports are free.

Refer to IBM link on tcp/ip parameters http://www-01.ibm.com/support/docview.wss?uid=swg21164785

Regards,

Deepak Kori