createTempLicense was executed with status ERROR (Last error reported by the step:

[sivareddy436]

I m installing solution manager 7.2 with db2 on AIX server. I am facing issue after completing 80% installation.

Could please anyone help me to come out.

sapinst log:

WARNING 2018-04-24 13:14:04.599 (root/sapinst) id=appmod.likeySignError
Creating a license signature failed. DETAILS:
===...could not load SSF library /usr/sap//D00/exe/libsapcrypto.so .

WARNING 2018-04-24 13:14:04.600 (root/sapinst) id=appmod.likeySignError
Creating a license signature failed. DETAILS: 543 wlikey_sign_for_installer: Couldn't load SAPSECULIB ("/usr/sap//D00/exe/libsapcrypto.so") using function SsfSupInitEx
(), rc = 10 (no library).

WARNING 2018-04-24 13:14:04.600 (root/sapinst) id=appmod.likeySignError
Creating a license signature failed. DETAILS: 542 wlikey_sign_for_installer: At least one more attempt to load the SAPSECULIB will follow.

WARNING 2018-04-24 13:14:04.601 (root/sapinst) id=appmod.likeySignError
Creating a license signature failed. DETAILS:
===...could not load SSF library .//libsapcrypto.so .

WARNING 2018-04-24 13:14:04.601 (root/sapinst) id=appmod.likeySignError
Creating a license signature failed. DETAILS: 543 wlikey_sign_for_installer: Couldn't load SAPSECULIB (".//libsapcrypto.so") using function SsfSupInitEx (), rc = 10 (no
library).

WARNING 2018-04-24 13:14:04.601 (root/sapinst) id=appmod.likeySignError
Creating a license signature failed. DETAILS: 542 wlikey_sign_for_installer: At least one more attempt to load the SAPSECULIB will follow.

INFO 2018-04-24 13:14:05.937 (root/sapinst)
Output of /usr/sap/SMD/SYS/exe/uc/rs6000_64/saplikey pf=/usr/sap/SMD/SYS/profile/SMD_DVEBMGS10_ssseccqas -install_first_temp B1537576821 XXXXXX is written to the logfil
e saplikey.log.

WARNING 2018-04-24 13:14:07.375 (root/sapinst) id=modlib.jslib.childAppReturn
Execution of the command "/usr/sap/SMD/SYS/exe/uc/rs6000_64/saplikey pf=/usr/sap/SMD/SYS/profile/SMD_DVEBMGS10_ssseccqas -install_first_temp B1537576821 XXXXXX" finishe
d with return code 2. Output:
SAP License Key Administration - Copyright (C) 2003 - 2012 SAP AG

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

ERROR 2018-04-24 13:14:07.378 (root/sapinst) id=nw.processError errno=CJS-30023
Process call '/usr/sap/SMD/SYS/exe/uc/rs6000_64/saplikey pf=/usr/sap/SMD/SYS/profile/SMD_DVEBMGS10_ssseccqas -install_first_temp B1537576821 XXXXXX' exits with error co
de 2. For details see log file(s) saplikey.log, dev_slic.

ERROR 2018-04-24 13:14:08.556 (root/sapinst) id=controller.stepExecuted errno=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_Li
cense_ABAP|ind|ind|ind|ind|lic|0|createTempLicense was executed with status ERROR (Last error reported by the step: Process call '/usr/sap/SMD/SYS/exe/uc/rs6000_64/sapl
ikey pf=/usr/sap/SMD/SYS/profile/SMD_DVEBMGS10_ssseccqas -install_first_temp B1537576821 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic).

it doesn't create dev_slic and saplikely.log shows it doesn't create temporary license.

Regards,

Siva.

[maria_shen]

Hello Siva,

The error seems not to be Db2 specific.

As you can see, it returned error code 2 when installing temporary SAP license key.

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

Could you please check whether any detailed error listed in file dev_likey?
If it is Db2 related, please detail it here.
If not, I suggest to post the question to software logistic community. You will be able to get continuous help there.

Thank you.

Kind regards
Maria

[sivareddy436]

Hi Maria,

As per requested, please find the below

dev_likey log.

ssseccqas:qasadm 18> tail -100 dev_likey
MtxInit: 0 0 0
DFPAL: Use statically linked version of DFPAL
DFPAL: Execute DFP Instructions in hardware
Loading DB library '/usr/sap/SMD/SYS/exe/run/dbdb6slib.so' ...
Library '/usr/sap/SMD/SYS/exe/run/dbdb6slib.so' loaded
Version of '/usr/sap/SMD/SYS/exe/run/dbdb6slib.so' is "745.04", patchlevel (0.10 0)

DB6 (DB2 UDB) UNICODE database interface 745.04 [opt]

DB6 shared library (dbdb6slib) patchlevels
(0.1) SAP kernel corrections prior to delivery (note 1226290)
(0.3) DB6: performance of ABAP MODIFY ... FROM TABLE ... (note 2178105)
(0.5) SAP kernel corrections prior to delivery (note 1226290)
(0.6) DB6: increase maximum number of external connections to 16 (note 2185047 )
(0.8) DB6: Explain does not find matching optimizer profile (note 2191320)
(0.8) DB6: ignore warings during array MODIFY (note 2195601)
(0.13) DB6: Set CURRENT REFRESH AGE = 0 at connect time (note 2207807)
(0.18) DB6: early close INSERT statement on duprec (note 2221224)
(0.24) DB6: CLI overflow in DMO migration phase (note 2230417)
(0.26) DB6: No short dump when ADBC program binds too many parame (note 224369 5)
(0.27) DB6: dynamically enable/disable netstatis collection (note 1625157)
(0.31) DB6: cast to SSTRING (note 2261398)
(0.34) DB6: network statistics data shows time_period=0 (note 2265329)
(0.36) DB6: Unexpected VBKEY value found in VBHDR (note 2274012)
(0.100) SAP Support Package Stack Kernel 7.45 Patch Level 100 (note 2276394)

Supported features:

..retrieving configuration parameters
..done
DB2 library has been loaded.
Info: successfully loaded DB2 library '/usr/sap/SMD/SYS/global/db6/AIX_64/db6_cl idriver/lib/libdb2.a(shr_64.o)'
Running with UTF-8 Unicode
DB2 client driver version '10.05.0007'
Running with CLI driver.
CLI cfg for con_hdl=0:
DSN="SMD";UID="sapsmd";DATABASE=SMD;PROTOCOL=TCPIP;HOSTNAME=ssseccqas;SERVICENAM E=5922;
Connected to DB server type 'DB2/AIX64'
Connected to DB server version '10.05.0007'
Connected to 'SMD' as 'SAPSMD' schema 'SAPSMD' o.k.
Connected: con_hdl=0 ; appl_hdl=1679; appl_id="10.101.4.22.34263.180424074406"
Current member="10.101.4.22:5922"
Database code page is ok.
Database collating sequence is ok.

Tue Apr 24 13:14:06 2018
DB2_WORKLOAD=SAP is set in DB2 registry as required.
CLI Insert Buffering is disabled on single partition databases.
INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
Connection 0 opened (DBSL handle 0)
INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
NTAB: Structure of NTAB on DB is VERS_B, unicodelg of executable is 2, unicodelg of SVERS in nametab is 2
Sqlcode -150 was returned on SQL statement:
INSERT INTO "SAPLIKEY" VALUES( ?, ? ) -- OPTLEVEL( 5 ) -- QUERY_DEGREE( 1 ) -- SYSTEM( SMD , SAPSMD )
DB message text:
[IBM][CLI Driver][DB2/AIX64] SQL0150N The target fullselect, view, typed table, materialized query table, ran
ge-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TR UNCATE statement is a target f
or which the requested operation is not permitted. SQLSTATE=42807
This sqlcode does not neccessarily indicate a problem if the affected table is a virtual table.
Table SAPLIKEY is a virtual table for deferred table creation.
Virtual table SAPLIKEY needs to be converted to a table.
Opening temporary connection for deferred table creation of table SAPLIKEY
CLI cfg for con_hdl=17:
DSN="SMD";UID="sapsmd";DATABASE=SMD;PROTOCOL=TCPIP;HOSTNAME=ssseccqas;SERVICENAM E=5922;
Connected to DB server type 'DB2/AIX64'
Connected to DB server version '10.05.0007'

Tue Apr 24 13:14:07 2018
Connected to 'SMD' as 'SAPSMD' schema 'SAPSMD' o.k.
Connected: con_hdl=17 ; appl_hdl=1680; appl_id="10.101.4.22.34264.180424074407"
Current member="10.101.4.22:5922"
Virtual table SAPLIKEY has been dropped.
*** ERROR in ExecuteDirect[/bas/745_REL/src/dbs/db6/dbdb6.c, 6917] CON = 17 (BEG IN)
&+*** DbSlModifyDB6( SQLExecDirect 😞 [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "{20}" was found follow
&+*** ing "OGGED ) IN SMD#DATA". Expected tokens may include: "<space>". SQLSTATE=42601
&+***
&+*** CREATE TABLE "SAPLIKEY" ( "LIKEY" VARCHAR(765) DEFAULT ' ' NOT NU LL , "VALUE" DBCLOB(512M) LOGGED ) IN SMD#
&+*** DATA{20} INDEX IN SMD#DATA{20} LONG IN SMD#DATA{20}
&+***
&+***
*** ERROR in ExecuteDirect[/bas/745_REL/src/dbs/db6/dbdb6.c, 6917] (END)
*** ERROR => Failed to create table SAPLIKEY.
[dbdb6_lazy_t 1008]
Disconnected from 'SMD'
Disconnected: con_hdl=17 ; appl_hdl=1680; appl_id="10.101.4.22.34264.18042407440 7"
***LOG BY4=> sql error -104 performing INS on table SAPLIKEY [dbtran 7806]
***LOG BY0=> SQL0104N An unexpected token "{20}" was found following "OGGED ) IN SMD#DATA". Expected tokens may include: "<space>". SQLSTATE=42601 [dbtran 7806]
dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS'
RSLT: {dbsl=99, tran=1}
FHDR: {tab='SAPLIKEY', fcode=130, mode=1, bpb=0, dbcnt=0, crsr=0,
hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
init:p=(nil), init:#=0, wa:p=fffffffffffc190, wa:#=520}
dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS'
STMT: {stmt:#=0, bndfld:#=0, prop=0, distinct=0,
fld:#=2, alias:p=(nil), fupd:#=0, tab:#=0, where:#=0,
groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0}
CRSR: {tab='', id=0, hold=0, prop=0x10000, max.in@0=0, fae:blk=0,
con:id=0, con:vndr=5, val=2,
key:#=1, xfer=0, xin:#=0, row:#=0, upto=0, wa:p=fffffffffffc190}
*** ERROR => SlicLikeyInsertRecord: RS_INSERT for key failed rc=1/sqlcode=-104 ( SQL0104N An unexpected token "{20}" was found following "OGGED ) IN SMD#DATA". Expected tokens may include: "<space>". SQLSTATE=42601) [sliclikey.c 472]
ssseccqas:qasadm 19>

Regards,

Siva.

[maria_shen]

Hello Siva,

Thank you for your update.

Here is the error:

SQL0104N An unexpected token "{20}" was found following "OGGED ) IN SMD#DATA". Expected tokens may include: "<space>".

Could you please check whether system has met the requirements to use tablespace pool feature, as listed in note##2267446? Especially for the dbsl version part.

2267446 - DB6: Support of tablespace pools

Thank you.

Kind regards
Maria