Migration process License Key

[Former Member]

Hello,

I've get an error during migration to Hana db.

During Create ICM userstore phase I get and error, and the output of saplikey.log is:

SAP License Key Administration  -  Copyright (C) 2003 - 2012 SAP AG

Could not install temporary license key - error code: 2.
E 96 likey_admin_clt: Couldn't get the list of all records from the persistence.

There is the errors in log

ERROR 2014-09-19 11:13:13.491
MSC-04120  Creating a license signature failed:
===...could not load SSF library D:\usr\sap\\D00\exe\sapcrypto.dll .

ERROR 2014-09-19 11:13:13.491
MSC-04120  Creating a license signature failed: 543 wlikey_sign_for_installer: Couldn't load SAPSECULIB ("D:\usr\sap\\D00\exe\sapcrypto.dll") using function SsfSupInitEx (), rc = 10 (no library).

ERROR 2014-09-19 11:13:13.491
MSC-04120  Creating a license signature failed: 542 wlikey_sign_for_installer: At least one more attempt to load the SAPSECULIB will follow.

Any suggestion?

[andreas_zigann]

Hello,

I have solved my problem by repeating the migration.

I have implemented some notes with corrections listed at note 1908075.

Further I did no table Splitting, but I think the solution was to implement the notes.

Best Regards

Andreas

[Former Member]

My Problem was related to the DDNTF and DDNTT tables.  For us we did a Unicode conversion with the export and the DDNTF_CONV_UC table did not export for some reason, the prereq jobs did create entries for it.  Reran export now, almost done, hopefully it will export this time.

In short, DDNTF and DDNTT tables contain your data dictionary.  If they are missing in a system after import your system will not start up.  It will seem like many tables like SAPLIKEY are missing, but infact your DDNTF or DDNTT are probably empty.

[Former Member]

I´ve looking in dev_w0 log and the system falls to shutwon and shows this error:

C  *** ERROR =>   prepare() of C_0001, rc=1, rcSQL=259

[dbsdbsql.cpp 1397]

C  *** ERROR => PREPARE C_0001 on connection 0, rc=259

[dbslsdb.cpp  9139]

C  SQLCODE    : 259

C  SQLERRTEXT : invalid table name:  Could not find table/view DDNTT in schema SAPH00: line 1 col 32 (at pos 31)

C  sc_p=0000000021ED9208,no=1,idc_p=0000000000000000,con=0,act=0,slen=63,smax=256,#vars=0,stmt=00000000220190B0,table=DDNTT                        

C  SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS' ;

B  *** ERROR => NTAB: SELECT COMPCNT, UNICODELG FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

I've checked the table with Hana studio and the table doesn't exist.

In the file ESTIMATED_ROUD_COUNT.txt only appears table:

DDNTDONE;0

DDNTLANG;0

Table DDNTT doesn't appear. Any suggestion?

System version is Netweaver 7.40 SPS07.

Thanks a lot

[andreas_zigann]

Hello Ruben,

do you have a solution yet? I have got the same problem when swpm tries to install a temporary license key of a SAP HANA.

I have got the tables SVERS and DDNTT.

My System Version ist NW 7.31 using kernel package 721_EXT PL 300 and SWPM SP06 PL5

Best Regards

Andreas

[former_member182657]

Hi Ruben,

Could you please check with SAP Note   556232 - Environment settings for R/3/Oracle on Windows

Regards,

Gaurav

[Former Member]

Hello Gaurav,

The db is hana. I don't see any of this environment variables.

[Former Member]

I am getting exactly the same on Sybase.  I will also raise a ticket with SAP Support.

This part is a bit worying (dev_likey log):

*** ERROR => dbrsql ERROR LOG (TABLE_NOT_FOUND): Table: 'SAPLIKEY                      '

[dbrsql.c     9050]

*** WARNING => SlicLikeyGetRecord: RS_READ failed rc=32 [sliclikey.c  863]

***LOG BZ9=> table SAPLIKEY                       does not exist in nametab [dbtran       11018]

*** ERROR => SlicLikeyGetAllRecords: RS_OPEN failed rc=32 [sliclikey.c  1049]

*** ERROR => 96 likey_admin_clt: Couldn't get the list of all records from the persistence. [likeylat.c   508]

saplikey.log:

E 96 likey_admin_clt: Couldn't get the list of all records from the

  persistence.

SAP License Key Administration  -  Copyright (C) 2003 - 2012 SAP AG

Could not install temporary license key - error code: 2.

sapinst_dev.log

ABAP > Standard System( Last error reported by the step: Creating a license signature failed:

===...could not load SSF library /usr/sap//D00/exe/libsapcrypto.so .)</i>. You can now: </p> <ul> <li> Choose <i>Retry</i> to repeat the current step. </li> <li> Choose <i>Log Files</i> to get more information about the error. </li> <li> Stop the option and continue with it later. </li> </ul> <p> Log files are written to <code>/tmp/sapinst_instdir/BS2013SR1/ERP607SR1/SYB/COPY/SYSTEM/STD/AS-ABAP/</code>. </p> </body></html>

[Former Member]

I have cleared the licenses in the SAPLIKEY table, but the same error is still there.  I have also tried to run a license key install with saplikey program on os, but did not help.  Same error is given.  With SAPSR3 user I can see the table, and I could see the contents of it as well.  All the licenses within this table were for _ORA or _DB6.

[Former Member]

Hi Ruben.

I have logged a call with SAP on Saturday morning.  I did not yet get a reply.  When I do I will let you know.  If you could please do the same, I would appreciate it.

Thank you.

[Former Member]

Found this note for Hana, might help you Ruben:

1938060

[Former Member]

Thanks Tinus for your help.

I've got Hana client version 82. Then it should be resolved however the scope is not the same...

[divyanshu_srivastava3]

Hi Ruben,

Goto SMP and download the SAPCRYPTOLIB for Windows.

You can get this under support packs section, under character 'S'.

Download and uncar in exe.

Regards,

[Former Member]

I get the same error with an import of EHP7 ERP6 with 741_50_unicode kernel.  Does not make sense as to why I would need files from cryptolib that are from 2013.  The error is looking for a path that does not exist. //D00.  That path seems to be a path hardcodes somewhere from a saplab.  PS: My import to Sybase is on SUSE Linux.

[Former Member]

Hello Divyanshu,

The sapcryptolib version under exe directory is more recent that the avalaible version in SMP...

[Former Member]

Tried to replace the files in any case, did not work.

[Sriram2009]

Hi Ruben

Could you check this SAP Note

  1010966 - License key 7.10: SAPSECULIB, SAPCRYPTOLIB, sapsecin

BR

SS

[Former Member]

There aren't the same errors.

[Sriram2009]

Hi Ruben

Could you attach or paste the latest full log?

BR

[Former Member]

Thanks  Sriram,

sapinst.log

ERROR 2014-09-19 19:17:53.620
MSC-04120  Creating a license signature faileE:
===...could not load SSF library E:\usr\sap\\D00\exe\sapcrypto.dll .

ERROR 2014-09-19 19:17:53.620
MSC-04120  Creating a license signature faileE: 543 wlikey_sign_for_installer: Couldn't load SAPSECULIB ("E:\usr\sap\\D00\exe\sapcrypto.dll") using function SsfSupInitEx (), rc = 10 (no library).

ERROR 2014-09-19 19:17:53.620
MSC-04120  Creating a license signature faileE: 542 wlikey_sign_for_installer: At least one more attempt to load the SAPSECULIB will follow.

INFO 2014-09-19 19:17:53.932
Switched to user: Domain\h00adm.

INFO 2014-09-19 19:17:54.41
Creating file C:\Program Files\sapinst_instdir\NW740\HDB\COPY\SYSTEM\STD\AS-ABAP\saplikey.log.

INFO 2014-09-19 19:17:54.88
Switched to user: Domain\h00adm.

INFO 2014-09-19 19:17:54.228
Output of E:\usr\sap\H00\SYS\exe\uc\NTAMD64\saplikey pf=\\SAPTEST\sapmnt\H00\SYS\profile\H00_DVEBMGS10_SAPTEST -install_first_temp Q1050047872 XXXXXX is written to the logfile saplikey.log.

WARNING 2014-09-19 19:17:54.774
Execution of the command "E:\usr\sap\H00\SYS\exe\uc\NTAMD64\saplikey pf=\\SAPTEST\sapmnt\H00\SYS\profile\H00_DVEBMGS10_SAPTEST -install_first_temp Q1050047872 XXXXXX" finished with return code 2. Output:
SAP License Key Administration  -  Copyright (C) 2003 - 2012 SAP AG

Could not install temporary license key - error code: 2.
E 96 likey_admin_clt: Couldn't get the list of all records from the
  persistence.

ERROR 2014-09-19 19:17:54.790
CJS-30023  Process call 'E:\usr\sap\H00\SYS\exe\uc\NTAMD64\saplikey pf=\\SAPTEST\sapmnt\H00\SYS\profile\H00_DVEBMGS10_SAPTEST -install_first_temp Q1050047872 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic.

ERROR 2014-09-19 19:17:54.899
FCO-00011  The step createTempLicense with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CI_Instance|ind|ind|ind|ind|ci|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 faileE:
===...could not load SSF library E:\usr\sap\\D00\exe\sapcrypto.dll .).

INFO 2014-09-19 19:17:55.383
Creating file C:\Program Files\sapinst_instdir\NW740\HDB\COPY\SYSTEM\STD\AS-ABAP\__instana_tmp.xml.

INFO 2014-09-19 19:17:57.177
Removed file C:\Program Files\sapinst_instdir\NW740\HDB\COPY\SYSTEM\STD\AS-ABAP\instslana.xml.

INFO 2014-09-19 19:17:57.177
Creating file C:\Program Files\sapinst_instdir\NW740\HDB\COPY\SYSTEM\STD\AS-ABAP\instslana.xml.

[Sriram2009]

Hi Ruben

Thanks for your info

I thing you have to raise the support ticket to SAP.

Regards

Sriram

[Former Member]

MSC-04120  Creating a license signature failed:

===...could not load SSF library D:\usr\sap\\D00\exe\sapcrypto.dll

Does this library exist at this path. Please check. If it exists , application is not able to load it. Download the correct version as per you kernel patch level and operating system.

Thanks

Amit

[Former Member]

Hello Amit,

This path doesn't exist (D:\usr\sap\\D00\exe\sapcrypto.dll)

I'll revise the kernel but I think that is the correct.

[Former Member]

You don't need to revise the whole kernel, Just download this library for your operating system ( I guess is windows) from marketplace and place it in you kernel.

You can also copy this file manually to your local kernel (D:\usr\sap\\D00\exe\)) if its available at the central kernel location.

Thanks

Amit

[Former Member]

The sapcrypto.dll library exists under kernel directory, but this path doesn't exist.

In dev_w0 log appear

C  *** ERROR => PREPARE C_0001 on connection 0, rc=259

[dbslsdb.cpp  9146]

C  SQLCODE    : 259

C  SQLERRTEXT : invalid table name:  Could not find table/view DDNTT in schema

Output of R3trans.exe -d

E:\usr\sap\H00\SYS\exe\uc\NTAMD64>R3trans.exe -d

This is R3trans.exe version 6.24 (release 741 - 10.06.14 - 20:14:07).

unicode enabled version

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

R3trans.exe finished (0012).

[Reagan]

I suggest you to use the latest kernel as there were similar issues like these and were resolved by updating the kernel set.

[Former Member]

Hi Ruben,

Can you check the values of these profile parameters in your system and provide them.

sec/libsapsecu

snc/gssapi_lib

ssl/ssl_lib

ssf/ssfapi_lib

Thanks

Amit

[Former Member]

Hello Amit,

I don´t have any of this parameters defined on my defautl and instance profile.

[Former Member]

Hi Ruben,

Can you check the default values of these in RZ11.

Also check if  ssl/ssl_lib and snc/gssapi_lib are pointing to the correct path for the dll file.

Also check the default values for following.

sec/libsapsecu

ssf/ssfapi_lib

Thanks

Amit

[Former Member]

Hi Amit,

But I'm making a system copy and I'm installing the target system to hana database with previous version.

I can't access to RZ11 of system, it can't start

[Former Member]

Hmm,

You can try to set these two parameters manually in the instance or default profile and check the results

ssl/ssl_lib

Set the above  to the actual path of the crypto dll.

and the below two as

sec/libsapsecu=$(ssl/ssl_lib)

ssf/ssfapi_lib=$(ssl/ssl_lib)

You can also set all the parameters to the actual path of crypto dll and give it a try.

Thanks

Amit

[Reagan]

Hello Ruben

Check for the parameter ssf/name = SAPSECULIB in the DEFAULT.PFL file. If present disable it and restart the SAP services and then retry on sapinst.

If that doesn't help could you attach the profiles here please ?

Note: This is just a suggestion which I would try.

Regards

RB

[Former Member]

Hello,

I've tried with the parameters and restarting the system& services but I'm getting the same result

During the startup of instance when I stops, the dev_w0 show this error:

X  mm.dump: set maximum dump mem to 96 MB

C  *** ERROR =>   prepare() of C_0001, rc=1, rcSQL=259 [dbsdbsql.cpp 1397]

C  *** ERROR => PREPARE C_0001 on connection 0, rc=259 [dbslsdb.cpp  9146]

C  SQLCODE    : 259

C  SQLERRTEXT : invalid table name:  Could not find table/view DDNTT in schema SAPH00: line 1 col 22 (at pos 21)

[Former Member]

Yes, I´ve tried with the last kernel but I'm getting the same result