E1: KER: LIB0000670 - Requested Site Key Not Found Error (Doc ID 2262459.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

After regenerating the site keys and restarting all servers customer sees the following errors in workflow kernels and security kernel jde logs.

May 4 12:18:03.099343 dbsql_s.c1984 - SELECT * FROM TESTDTA.F7308T WHERE ( PEVDBKY = '01' )
May 4 12:18:03.106944 dbfetch.c107 - ORACLE DBFetch conn=098eeb88 requ=09e0f3a0 maxrows=15
May 4 12:18:03.106983 dbfetch.c198 - ORACLE DBFetch conn=098eeb88 requ=09e0f3a0 fetched=1
May 4 12:18:03.107029 jdb_exef.c5741 - Fetched the record (hRequest 0987f2e8)
May 4 12:18:03.107050 jdb_utl1.c11140 - Entering JDB_ValidateHUser (User 09668300)
May 4 12:18:03.107054 jdb_utl1.c11166 - Exiting JDB_ValidateHUser with Success (User 09668300)
May 4 12:18:03.107944 sktools.h3396 - Site key request send to 10.64.19.22_anykrnl_m16 (c0s65123)
May 4 12:18:03.109158 sktools.h3478 - Site key request recv 10.64.19.22_26640_m16
May 4 12:18:03.109171 sktools.h3782 - LIB0000670 - Requested site key not found
May 4 12:18:03.109216 jdetools.c6474 - LIB0000647 - Specific site key for decryption was not found
May 4 12:18:03.109240 jdetools.c5951 - LIB0000628 - Error decrypting the encrypted text string

 

May 4 12:18:01.915480 dbresrq.c123 - ORACLE DBRsetReq conn=09203740 requ=094e3f88 dbc0s648 (PROD)
May 4 12:18:01.915506 dbsql_i.c175 - INSERT INTO SY920.F9312 (SHUSER, SHEVTYP, SHEVSTAT, SHMKEY, SHUSR0, SHPID, SHJOBN, SHUPMJ, SHUPMT, SHDTOFF, SHTMOFF, SHCHGF, SHSECF1, SHSECF2, SHSECV3, SHSECV4) VALUES ('JDE','01','01','C0S65123','JDE','C0S65123','C0S65123',117124,121801.000000,0,0.000000,'0','jdenet_k',' ','26640l','915412.0')
May 4 12:18:01.917683 jdb_exet.c6601 - Exiting JDB_InsertTable with Success (Table F9312)
May 4 12:18:01.917710 jdeksec.c4178 - Added user [JDE], clientIP [10.64.19.22], remotePid [26641] to the logon user list
May 4 12:18:03.108062 netflow.c1751 - About to call dispatch function, flags=0x2, Type=585
May 4 12:18:03.108107 sktools.h2959 - LIB0000603 - The requested site key was not found, so cannot decrypt the encrypted data item



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms