Error during a system copy with HANA DB

[Former Member]

Hello,

I´m doing a system copy in a SAP ERP 6.0 EHP7 with SAP HANA DB.

During a homogeneous system copy procedure with SWPM, it show me the following error during the phase Database refresh postload-activities.

I checked some log files:

-- sapinst.log:

...

ERROR 2014-08-24 16:14:01.109
MSC-04120  Creating a license signature failed:
===...could not load SSF library S:\usr\sap\\D00\exe\sapcrypto.dll .

ERROR 2014-08-24 16:14:01.109
MSC-04120  Creating a license signature failed: 543 wlikey_sign_for_installer: Couldn't load SAPSECULIB ("S:\usr\sap\\D00\exe\sapcrypto.dll") using function SsfSupInitEx (), rc = 10 (no library).

ERROR 2014-08-24 16:14:01.109
MSC-04120  Creating a license signature failed: 542 wlikey_sign_for_installer: At least one more attempt to load the SAPSECULIB will follow.

INFO 2014-08-24 16:14:01.234
Switched to user: ASCENDUMCE\ed1adm.

INFO 2014-08-24 16:14:01.343
Creating file C:\Program Files\sapinst_instdir\BS2013\BS2013SR1\ERP607SR1\HDB\COPY\SYSTEM\STD\AS-ABAP\REF\saplikey.log.

INFO 2014-08-24 16:14:01.390
Switched to user: ASCENDUMCE\ed1adm.

INFO 2014-08-24 16:14:01.422
Output of S:\usr\sap\ED1\SYS\exe\uc\NTAMD64\saplikey pf=\\SATDCSAP3\sapmnt\ED1\SYS\profile\ED1_DVEBMGS00_SATDCSAP3 -install_first_temp F1740289712 XXXXXX is written to the logfile saplikey.log.

WARNING 2014-08-24 16:14:01.640
Execution of the command "S:\usr\sap\ED1\SYS\exe\uc\NTAMD64\saplikey pf=\\SATDCSAP3\sapmnt\ED1\SYS\profile\ED1_DVEBMGS00_SATDCSAP3 -install_first_temp F1740289712 XXXXXX" finished with return code 2. Output:
saplikey: failed to connect to the database.

ERROR 2014-08-24 16:14:01.640
CJS-30023  Process call 'S:\usr\sap\ED1\SYS\exe\uc\NTAMD64\saplikey pf=\\SATDCSAP3\sapmnt\ED1\SYS\profile\ED1_DVEBMGS00_SATDCSAP3 -install_first_temp F1740289712 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic.

ERROR 2014-08-24 16:14:01.703
FCO-00011  The step createTempLicense with step key |NW_ABAP_DB_DBRefresh|ind|ind|ind|ind|0|0|NW_ABAP_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_DBRefresh_ABAP|ind|ind|ind|ind|abap|0|NW_Temp_License_ABAP|ind|ind|ind|ind|lic|0|createTempLicense was executed with status ERROR ( Last error reported by the step: Creating a license signature failed:
===...could not load SSF library S:\usr\sap\\D00\exe\sapcrypto.dll .).

INFO 2014-08-24 16:14:02.31
Creating file C:\Program Files\sapinst_instdir\BS2013\BS2013SR1\ERP607SR1\HDB\COPY\SYSTEM\STD\AS-ABAP\REF\__instana_tmp.xml.

INFO 2014-08-24 16:14:02.734
Removed file C:\Program Files\sapinst_instdir\BS2013\BS2013SR1\ERP607SR1\HDB\COPY\SYSTEM\STD\AS-ABAP\REF\instslana.xml.

INFO 2014-08-24 16:14:02.734
Creating file C:\Program Files\sapinst_instdir\BS2013\BS2013SR1\ERP607SR1\HDB\COPY\SYSTEM\STD\AS-ABAP\REF\instslana.xml.

-- saplikey.log:

saplikey: failed to connect to the database.

-- dev_likey:

...

-> init()
  STATEMENT_CACHE_SIZE = 1000
-> init()
-> loadClientRuntime()
Loading SQLDBC client runtime ...
SQLDBC Module  : S:\usr\sap\ED1\hdbclient\libSQLDBCHDB.dll
SQLDBC Runtime : libSQLDBCHDB 1.00.80.00 Build 0391861-1510
SQLDBC client runtime is 1.00.80.00.0391861
-> getNewConnection()
<- getNewConnection(con_hdl=0)
-> checkEnvironment(con_hdl=0)
-> connect(con_info_p=0000000000000000)

Try to connect via secure store (DEFAULT) on connection 0 ...
*** ERROR => Connect to database failed, rc=1, rcSQL=10
[dbhdbsql.cpp 332]
SQLCODE    : 10
SQLERRTEXT : invalid username or password:
-> SetSdbDbslCA(errcode=10)
-> freeConnection(con_hdl=0)
   close all opened locators of connection 0
} DbSlHDBConnect(rc=99)
***LOG BY2=> sql error 10     performing CON [dblink       559]
***LOG BY0=> invalid username or password:  [dblink       559]
*** ERROR => saplikey: failed to connect to the database. [saplikey.c   830]
release memory of the SIBU buffers
release memory of the STATEMENT CACHE

Can you help me please!? This is very urgent!

Thank you,

samid raif

[Former Member]

Hi Samid,

We are also facing similar issue, can you let us know what was the solution done for this.

Thanks in advance.

Regards,

Gokul.

[Former Member]

Hi,

4 ETW000  [     dev trc,00000]  Try to connect via secure store (DEFAULT) on connection 0 ...             86  0.010598

4 ETW000  [dbhdbsql.cpp,00000]  *** ERROR => Connect to database failed, rc=1, rcSQL=10                11122  0.021720

4 ETW000  [     dev trc,00000]  SQLCODE    : 10                                                           68  0.021788

4 ETW000  [     dev trc,00000]  SQLERRTEXT : invalid username or password:                                40  0.021828

I belive you need to update the useernaem and password at the secure store

Regards,

Pavan Gunda

[Former Member]

Does r3trans -d work? If not, troubleshoot this as normal first.

[former_member286941]

Hello Samid, S:\usr\sap\\D00\exe\sapcrypto.dll  is not laoded. Can you download sapcrypto files from SMP and copy them here? These files sometimes create problem in license if missing. Regards Munish

[Former Member]

Hello John Appleby,

I ran the R3trans -d and this is the output:

4 ETW000 r3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 24.08.2014 - 20:22:19

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]  Sun Aug 24 20:22:19 2014                                                 124  0.000124

4 ETW000  [     dev trc,00000]  db_con_init called                                                       103  0.000227

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

4 ETW000                                                                                                  94  0.000321

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

4 ETW000                                                                                                  44  0.000365

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

4 ETW000  [     dev trc,00000]  Loading DB library 'dbhdbslib.dll' ...                                    64  0.000455

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

4 ETW000                                                                                                5889  0.006344

4 ETW000  [     dev trc,00000]      using "S:\usr\sap\ED1\SYS\exe\uc\NTAMD64\dbhdbslib.dll"               35  0.006379

4 ETW000  [     dev trc,00000]  Library 'dbhdbslib.dll' loaded                                            36  0.006415

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbhdbslib.dll                    52  0.006467

4 ETW000  [     dev trc,00000]  Version of 'dbhdbslib.dll' is "741.10", patchlevel (0.43)                111  0.006578

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbhdbslib.dll                   39  0.006617

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbhdbslib.dll                  63  0.006680

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    81  0.006761

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=-1,command=39,arg_p=0000000000000000)            40  0.006801

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    29  0.006830

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=-1,command=10,arg_p=000000000221F280)            34  0.006864

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    29  0.006893

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  25  0.006918

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                                                                                                  63  0.006981

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=-1,command=10,arg_p=0000000141FF5E40)            49  0.007030

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    30  0.007060

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

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

4 ETW000                                                                                                  42  0.007133

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          28  0.007161

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                                                                                                 124  0.007285

4 ETW000  [     dev trc,00000]  { DbSlHDBConnect(con_info_p=0000000000000000)                             61  0.007346

4 ETW000  [     dev trc,00000]  DBHDBSLIB : version 741.10, patch 0.043 (Make PL 0.43)                    65  0.007411

4 ETW000  [     dev trc,00000]  HDB shared library (dbhdbslib) patchlevels (last 10)                      37  0.007448

4 ETW000  [     dev trc,00000]    (0.043) R3szchk with partitioned tables (note 2040561)                  32  0.007480

4 ETW000  [     dev trc,00000]    (0.031) New DBCON syntax for HANA (note 1983389)                        50  0.007530

4 ETW000  [     dev trc,00000]    (0.028) Bulk insert stop on duplicate, dbsl returncode corrected (note 1996982)

4 ETW000                                                                                                  51  0.007581

4 ETW000  [     dev trc,00000]    (0.027) Set DBAREQ class (note 1991383)                                 35  0.007616

4 ETW000  [     dev trc,00000]    (0.022) Get database version via dbsl call (note 1976918)               36  0.007652

4 ETW000  [     dev trc,00000]    (0.020) FDA: Core Dump in SELECT ... FOR ALL ENTRIES for tables with strings (note 1970276)

4 ETW000                                                                                                  53  0.007705

4 ETW000  [     dev trc,00000]    (0.020) SQL DDL with data aging (note 1897636)                          35  0.007740

4 ETW000  [     dev trc,00000]    (0.017) Datatype NCLOB missing in tablesize calculation (note 1952609)

4 ETW000                                                                                                  52  0.007792

4 ETW000  [     dev trc,00000]    (0.014) Tablesize calculation for HANA optimized (note 1952609)         36  0.007828

4 ETW000  [     dev trc,00000]    (0.014) Native SQL UPSERT with DataAging (note 1897636)                 32  0.007860

4 ETW000  [     dev trc,00000]                                                                            22  0.007882

4 ETW000  [     dev trc,00000]   -> init()                                                                33  0.007915

4 ETW000  [     dev trc,00000]    STATEMENT_CACHE_SIZE = 1000                                            212  0.008127

4 ETW000  [     dev trc,00000]   -> init()                                                               615  0.008742

4 ETW000  [     dev trc,00000]   -> loadClientRuntime()                                                   46  0.008788

4 ETW000  [     dev trc,00000]  Loading SQLDBC client runtime ...                                         31  0.008819

4 ETW000  [     dev trc,00000]  SQLDBC Module  : S:\usr\sap\ED1\hdbclient\libSQLDBCHDB.dll              1327  0.010146

4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 1.00.80.00 Build 0391861-1510               84  0.010230

4 ETW000  [     dev trc,00000]  SQLDBC client runtime is 1.00.80.00.0391861                               50  0.010280

4 ETW000  [     dev trc,00000]   -> getNewConnection()                                                    37  0.010317

4 ETW000  [     dev trc,00000]   <- getNewConnection(con_hdl=0)                                          100  0.010417

4 ETW000  [     dev trc,00000]   -> checkEnvironment(con_hdl=0)                                           53  0.010470

4 ETW000  [     dev trc,00000]   -> connect(con_info_p=0000000000000000)                                  42  0.010512

4 ETW000  [     dev trc,00000]  Try to connect via secure store (DEFAULT) on connection 0 ...             86  0.010598

4 ETW000  [dbhdbsql.cpp,00000]  *** ERROR => Connect to database failed, rc=1, rcSQL=10                11122  0.021720

4 ETW000  [     dev trc,00000]  SQLCODE    : 10                                                           68  0.021788

4 ETW000  [     dev trc,00000]  SQLERRTEXT : invalid username or password:                                40  0.021828

4 ETW000  [     dev trc,00000]   -> SetSdbDbslCA(errcode=10)                                              41  0.021869

4 ETW000  [     dev trc,00000]   -> freeConnection(con_hdl=0)                                             43  0.021912

4 ETW000  [     dev trc,00000]     close all opened locators of connection 0                              60  0.021972

4 ETW000  [     dev trc,00000]  } DbSlHDBConnect(rc=99)                                                   65  0.022037

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 10     performing CON                               68  0.022105

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>invalid username or password:                                 35  0.022140

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=41,arg_p=0000000140541C48)            107  0.022247

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    79  0.022326

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=14,arg_p=0000000002215998)             38  0.022364

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    28  0.022392

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=50,arg_p=0000000002215990)             33  0.022425

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    43  0.022468

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=13,arg_p=00000000022159B0)             35  0.022503

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    27  0.022530

4 ETW000  [     dev trc,00000]  { DbSlHDBControl(con_hdl=0,command=52,arg_p=0000000002215A00)             33  0.022563

4 ETW000  [     dev trc,00000]  } DbSlHDBControl(rc=0)                                                    28  0.022591

2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"

4 ETW000  [     dev trc,00000]  release memory of the SIBU buffers                                      2900  0.025491

4 ETW000  [     dev trc,00000]  release memory of the STATEMENT CACHE                                     91  0.025582

[Former Member]

This is a SSFS error. Normally this comes from a mistake in the migration process. Check the following for assistance if you prefer not to start the migration from scratch.

http://service.sap.com/sap/support/notes/1639578

[Sriram2009]

Hi Samid

I thing you may require to upgrade the latest kernel & DBSL patch.stop

BR

SS