sapinst - Error in ABAP Import phase installing Solution Manager 7.1

[Former Member]

HI all,

i' ve a problem when installing SAP Solution Manager 7.1 on DB2 LUW.

At the beginning of the Import ABAP Phase, sapinst stops with the following error in the

sapinst.log:

WARNING 2013-03-07 05:45:22.734
Execution of the command "/usr/sap/RFI/SYS/exe/run/R3load -testconnect" finished with return code 2. Output:
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
/usr/sap/RFI/SYS/exe/run/R3load: START OF LOG: 20130307054521

/usr/sap/RFI/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/RFI/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Dec  1 2011 20:23:00
/usr/sap/RFI/SYS/exe/run/R3load -testconnect

DbSl Trace: DbSlConnect to 'RFI' as 'saprfi' failed

(DB) ERROR: db_connect rc = 256
DbSl Trace: DbSlConnect to 'RFI' as 'saprfi' failed

(DB) ERROR: DbSlErrorMsg rc = 29

/usr/sap/RFI/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/RFI/SYS/exe/run/R3load: END OF LOG: 20130307054522

ERROR 2013-03-07 05:45:22.739
CJS-30023  Process call '/usr/sap/RFI/SYS/exe/run/R3load -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.

ERROR 2013-03-07 05:45:24.266
FCO-00011  The step testDatabaseConnection with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|abapload|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|testDatabaseConnection was executed with status ERROR ( Last error reported by the step: Process call '/usr/sap/RFI/SYS/exe/run/R3load -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.).

R3load.exe.log:

sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
/usr/sap/RFI/SYS/exe/run/R3load: START OF LOG: 20130307054521

/usr/sap/RFI/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/RFI/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Dec  1 2011 20:23:00
/usr/sap/RFI/SYS/exe/run/R3load -testconnect

DbSl Trace: DbSlConnect to 'RFI' as 'saprfi' failed

(DB) ERROR: db_connect rc = 256
DbSl Trace: DbSlConnect to 'RFI' as 'saprfi' failed

(DB) ERROR: DbSlErrorMsg rc = 29

I found the SAP Note https://service.sap.com/sap/support/notes/1249769

.......

.......

MCOD Installation:

To avoid an error during step "testDatabaseConnection" in your MCOD installation, you have to grant a privilege to user  sap<sapsid>.

Otherwise, the following error can occur:

ERROR      <timestamp>  [sixxcstepexecute.cpp:956]

FCO-00011  The step testDatabaseConnection with step key ...

Solution:

Enter the following as user db2<dbsid>:

db2 GRANT DROPIN ON SCHEMA SAPTOOLS TO USER SAP<SAPSID>

I stop the sapinst and execute the following command as db2<dbsid>:

@ db2 GRANT DROPIN ON SCHEMA SAPTOOLS TO USER SAPRFI

I restart again the sapinst but the error still remain.

I test if user saprfi could connect to DB RFI and he could not:

ERROR:

[saprfi ~]$ db2 connect to RFI

db2: Command not found.

SUCCESS:

db2rfi 2> db2 connect to RFI USER saprfi USING xxxxxxxxxx

   Database Connection Information

Database server        = DB2/LINUXX8664 10.1.2
SQL authorization ID   = SAPRFI
Local database alias   = RFI

The software version are identical:

RDBMS

DB2/LUW:V9COMP_V10.1 FP2:RDBMS:DB2/LUW:D51045663

Client

DB2/LUW:V9COMP_V10.1 FP2:CLI/JDBC-DRIVER:DB2/LUW:CD51045665

Any idea?

Paolo

[Former Member · Accepted solution]

I solved by myself.

The right dvd for Kernel and SL_CONTROLLER are:

Kernel_720_EXT_UC_SWPM          51045218_4

SL_CONTROLLER_700_SWPM     51045218_5

[Former Member · Accepted solution]

Hi Paolo,

me alreday told that there is problem with Kernel.

Regards

Ashok

[Former Member]

Hi,

   Please set the below environmental variable before starting the SAPINST and try again.

DIR_LIBRARY

SHLIB_PATH

LD_LIBRARY

Just login to sidadm and see what is the value set...Then try the above env in the root user and check again..

I believe it should work.

Thanks and Regards,

Vimal

[Former Member]

The problem still remain.

[hugo_amo]

Hi Paolo,

This looks to be a software level mismatch problem between client and server.

You can check this by the following command:

- Output from: db2level
- trans.log from an 'R3trans -d' run performed as the <sid>adm user.

The database main release needs to be identical between client and server. The Fix Pack level of client needs to be equal or lower than the Fix Pack level of the database server.

So, the options to fix this issue would be either upgrade the server version or use a lower level client software.

Hope this helps.

Good luck!

Regards,

Hugo

[Former Member]

this is the output:

sapvm72:db2rfi 18> db2level

DB21085I  This instance or install (instance name, where applicable: "db2rfi")

uses "64" bits and DB2 code release "SQL10012" with level identifier "0203010E".

Informational tokens are "DB2 v10.1.0.2", "s121127", "IP23394", and Fix Pack "2".

Product is installed at "/db2/db2rfi/db2_software".

Which are the version of the DB and the client?

There is a mismatch?

[Former Member]

now i've:

CLIENT

sapvm72:rfiadm 3> db6level

10.01.0001

SERVER

sapvm72:rfiadm 4> de2level

de2level: Command not found.

sapvm72:rfiadm 5> db2level

DB21085I  This instance or install (instance name, where applicable: "db2rfi")

uses "64" bits and DB2 code release "SQL10012" with level identifier

"0203010E".

Informational tokens are "DB2 v10.1.0.2", "s121127", "IP23394", and Fix Pack

"2".

Product is installed at "/db2/db2rfi/db2_software".

but doesn't work!

[hugo_amo]

Hi Paolo,

We would need to know the result of trans.log from an 'R3trans -d' run performed as the <sid>adm user in order to know if there is a mismatch.

Regards,

Hugo

[Former Member]

Here is the trans.log:

rfiadm 13> R3trans -d

This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

unicode enabled version

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

R3trans finished (0012).

rfiadm 14> more trans.log

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 09.03.2013 - 04:22:09

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]  Sat Mar  9 04:22:09 2013                                                9188  0.009188

4 ETW000  [     dev trc,00000]  db_con_init called                                                        45  0.009233

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

4 ETW000                                                                                                  36  0.009269

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

4 ETW000                                                                                                  28  0.009297

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/RFI/SYS/exe/run/dbdb6slib.so' ...            77  0.009390

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/RFI/SYS/exe/run/dbdb6slib.so"), hdl 0

4 ETW000                                                                                                1053  0.010443

4 ETW000  [     dev trc,00000]  Library '/usr/sap/RFI/SYS/exe/run/dbdb6slib.so' loaded                    17  0.010460

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/RFI/SYS/exe/run/dbdb6slib.so

4 ETW000                                                                                                  34  0.010494

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/RFI/SYS/exe/run/dbdb6slib.so' is "720.00", patchlevel (0.323)

4 ETW000                                                                                                 195  0.010689

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/RFI/SYS/exe/run/dbdb6slib.so

4 ETW000                                                                                                  30  0.010719

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/RFI/SYS/exe/run/dbdb6slib.so

4 ETW000                                                                                                  25  0.010744

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

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_o

pt = 255, occ = NO , prog = 

4 ETW000                                                                                                  37  0.010816

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

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

4 ETW000                                                                                                  17  0.010854

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          10  0.010864

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_op

t = 255, occ = NO , prog = 

4 ETW000                                                                                                  22  0.010886

4 ETW000  [     dev trc,00000]  RLIMIT_STACK: current=10485760, max=-1                                   425  0.011311

4 ETW000  [     dev trc,00000]  DB6 (DB2 UDB) UNICODE database interface 720.00 [opt]                     24  0.011335

4 ETW000  [     dev trc,00000]  DB6 shared library (dbdb6slib) patchlevels                                14  0.011349

4 ETW000  [     dev trc,00000]    (0.2) DB6: unexpected token INLINE LENGTH (note 1334179)                66  0.011415

4 ETW000  [     dev trc,00000]    (0.2) DB6: configurable cc_release attribute for UR cursors (note 1324532)

4 ETW000                                                                                                  24  0.011439

4 ETW000  [     dev trc,00000]    (0.2) DB6: cobra enhancements part 2 (note 1315762)                     14  0.011453

4 ETW000  [     dev trc,00000]    (0.5) DB6: substitution of aliases in optguidelines (note 1352458)

4 ETW000                                                                                                  34  0.011487

4 ETW000  [     dev trc,00000]    (0.9) DB6: login timeout for secondary connections (note 1364372)       21  0.011508

4 ETW000  [     dev trc,00000]    (0.13) DB6: revalidate views in status active=N (note 1376439)          21  0.011529

4 ETW000  [     dev trc,00000]    (0.13) DB6: create index with 9.7 and virtual tables (note 1371882)

4 ETW000                                                                                                  22  0.011551

4 ETW000  [     dev trc,00000]    (0.14) DB6: optimized performance for R3load with DEF_CRT (note 1378018)

4 ETW000                                                                                                  20  0.011571

4 ETW000  [     dev trc,00000]    (0.18) DB6: timeout for CREATE/DROP TRIGGER (note 1387865)              19  0.011590

4 ETW000  [     dev trc,00000]    (0.22) DB6: patch collection 10/09 (note 1397804)                       26  0.011616

4 ETW000  [     dev trc,00000]    (0.25) DB6: Potentially unnoticed rollback during array operation (note 1406740)

4 ETW000                                                                                                  28  0.011644

4 ETW000  [     dev trc,00000]    (0.30) DB6: client affinity support (note 1414616)                      25  0.011669

4 ETW000  [     dev trc,00000]    (0.32) DB6: CLI TraceRefreshInterval during parallel import (note 1426985)

4 ETW000                                                                                                  33  0.011702

4 ETW000  [     dev trc,00000]    (0.39) DB6: patch collection 03/10 (note 1447436)                    20843  0.032545

4 ETW000  [     dev trc,00000]    (0.49) DB6: patch collection 05/10 (note 1364372)                       39  0.032584

4 ETW000  [     dev trc,00000]    (0.49) DB6: patch collection 05/10 (note 1470824)                       16  0.032600

4 ETW000  [     dev trc,00000]    (0.51) DB6: return original schema in shadow system (note 1474361)

4 ETW000                                                                                                  28  0.032628

4 ETW000  [     dev trc,00000]    (0.53) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000                                                                                                  20  0.032648

4 ETW000  [     dev trc,00000]    (0.54) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000                                                                                                  29  0.032677

4 ETW000  [     dev trc,00000]    (0.54) DB6: literals for decimal columns of value 0 (note 1482790)

4 ETW000                                                                                                  26  0.032703

4 ETW000  [     dev trc,00000]    (0.57) DB6: tolerate client deletes on virtual tables (note 1484286)

4 ETW000                                                                                                  26  0.032729

4 ETW000  [     dev trc,00000]    (0.65) DB6: SQLE_CLIENT_INFO_USERID including quotes (note 1508803)

4 ETW000                                                                                                  26  0.032755

4 ETW000  [     dev trc,00000]    (0.66) DB6: revalidation of view failed (note 1376439)                  14  0.032769

4 ETW000  [     dev trc,00000]    (0.67) DB6: DROP INDEX on virtual table ignored (note 1514380)          18  0.032787

4 ETW000  [     dev trc,00000]    (0.69) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

4 ETW000                                                                                                  33  0.032820

4 ETW000  [     dev trc,00000]    (0.71) DB6: SQL0301N after LONG to LOB conversion (note 1524339)        20  0.032840

4 ETW000  [     dev trc,00000]    (0.84) DB6: patch collection 03/11 (note 1568512)                     5492  0.038332

4 ETW000  [     dev trc,00000]    (0.87) DB6: REORG table causes SQL0108 (note 1575617)                   86  0.038418

4 ETW000  [     dev trc,00000]    (0.89) DB6: FOR ALL ENTRIES with SUBSTITUTE VALUES (note 1587338)       23  0.038441

4 ETW000  [     dev trc,00000]    (0.92) Secondary connection to HANA (note 1481256)                      26  0.038467

4 ETW000  [     dev trc,00000]    (0.104) DB6: collection of network statistics (note 1625157)            22  0.038489

4 ETW000  [     dev trc,00000]    (0.105) DB6: refresh connection infos on seamless failover (note 1629682)

4 ETW000                                                                                                  27  0.038516

4 ETW000  [     dev trc,00000]    (0.112) DB6: Galileo patch collection (note 1649831)                    19  0.038535

4 ETW000  [     dev trc,00000]    (0.120) DB6: reexecution of DELETE statement fails (note 1672007)      699  0.039234

4 ETW000  [     dev trc,00000]    (0.200) Take care of warnings during database connect (note 1600066)

4 ETW000                                                                                                  49  0.039283

4 ETW000  [     dev trc,00000]    (0.210) DB6: isolation RS for select in INDX type cluster tables (note 1678935)

4 ETW000                                                                                                  29  0.039312

4 ETW000  [     dev trc,00000]    (0.211) DB6: Global Compression Option (note 1690077)                   20  0.039332

4 ETW000  [     dev trc,00000]    (0.310) DB6: suppress location for internal SQL statements (note 1736676)

4 ETW000                                                                                                  29  0.039361

4 ETW000  [     dev trc,00000]    (0.311) DB6: reload connect passwords for table materialization (note 1746047)

4 ETW000                                                                                                  21  0.039382

4 ETW000  [     dev trc,00000]    (0.312) DB6: DBSL trace enhancements (note 31707)                       20  0.039402

4 ETW000  [     dev trc,00000]    (0.315) DB6: patch for DB6_DBSL_CLP_COMMAND (note 1755738)              21  0.039423

4 ETW000  [     dev trc,00000]    (0.318) DB6: enhanced micro outage feature (note 1434153)               29  0.039452

4 ETW000  [     dev trc,00000]    (0.323) DB6: patch collection 11/12 (note 1780383)                      22  0.039474

4 ETW000  [     dev trc,00000]  Supported features:                                                       35  0.039509

4 ETW000  [     dev trc,00000]  ..retrieving configuration parameters                                     12  0.039521

4 ETW000  [     dev trc,00000]  ..done                                                                   107  0.039628

4 ETW000  [     dev trc,00000]  DB2 library has been loaded.                                           30192  0.069820

4 ETW000  [     dev trc,00000]  Info: successfully loaded DB2 library '/usr/sap/RFI/SYS/global/db6/LINUXX86_64/db6_clidriver/lib/libdb2.so'

4 ETW000                                                                                                  58  0.069878

4 ETW000  [     dev trc,00000]  Running with UTF-8 Unicode                                                13  0.069891

4 ETW000  [     dev trc,00000]  DB2 client driver version '10.01.0001'                                  9359  0.079250

4 ETW000  [     dev trc,00000]  Running with CLI driver.                                                2284  0.081534

4 ETW000  [     dev trc,00000]  Sat Mar  9 04:22:10 2013                                              657562  0.739096

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[dbdb6.c, 1865] CON = 0 (BEGIN)                    54  0.739150

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

4 ETW000                                                                                                  25  0.739175

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

4 ETW000                                                                                                  20  0.739195

4 ETW000  [     dev trc,00000]  &+     161.27.205.72".  Communication function detecting the error: "recv".  Protocol specific error code(s): "*", "*", "

4 ETW000                                                                                                  20  0.739215

4 ETW000  [     dev trc,00000]  &+     0".  SQLSTATE=08001                                                                                              

4 ETW000                                                                                                  19  0.739234

4 ETW000  [     dev trc,00000]  &+                                                                                                                      

4 ETW000                                                                                                  20  0.739254

4 ETW000  [     dev trc,00000]  &+                                                                                                                      

4 ETW000                                                                                                  29  0.739283

4 ETW000  [     dev trc,00000]  &+                                                                                                                      

4 ETW000                                                                                                  20  0.739303

4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[dbdb6.c, 1865] (END)                              15  0.739318

4 ETW000  [    dbdb6.c ,00000]  *** ERROR => DbSlConnect to 'RFI' as 'saprfi' failed                     128  0.739446

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

[Former Member]

Hi,

Please try the following and see whether it works.

Please try to download dbdb6slib.* file and try to extract to kernel and check again.. You should restart both SAP & DB after updating the file.

Secondly, please check whether the user which is trying to connect to SAP has changed. Please see the 1634289 - CMS Lost Connection to DB2 Database.. This note seems to be of your issue..

Thanks and Regards,

Vimal

[Former Member]

Hi Vimal,

I'm in the installing phase so SAP is not installed yet. I already patched the kernel with the last patch so it doesn't matter installing another time the db6* file.

The Note yoiu gave me doesn't resolve the problem. It concernerd about CMS and i don't have CMS.

[Former Member]

Hi Paolo,

try to change kernel files...may be some times there may be kernel problem for Load test..if we have another system runing same kernel version try to replace the files here..may it will helpful sometimes.

Regards

Ashok

[Former Member]

I've put new kernel but the problem still remain.

Now i'm on kernel 402 uc.