Foxhound 5.0 FAQ
search engine by freefind advanced
Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Message: Decryption error: Missing encryption key
Message: LOAD TABLE error: The data to load is not encrypted
Message: Missing encryption key
Message: SQLCODE = -1188, SQLSTATE = WL013, ERRORMSG() = LOAD TABLE error: The data to load is not encrypted
Message: SQLCODE = -851, SQLSTATE = 08W63, ERRORMSG() = Decryption error: Missing encryption key
Message: The data to load is not encrypted

Explanation: The encryption key that was specified before the CALL "{OWNER}".start_OFSS_monitor() on the OFSS subject database must also be specified for the CALL load_OFSS_samples() on Foxhound.

Here's an example of the error:

-- On subject database 1:

PARAMETERS OWNER;
UPDATE "{OWNER}".OFSS_settings SET unload_path = 'C:\\DATA\\OFSSddd12\\';               -- folder 1
UPDATE "{OWNER}".OFSS_settings SET max_batch_duration = '2m';                           -- 2 minutes between batches
UPDATE "{OWNER}".OFSS_settings SET encryption_key = 'KeHX8?k1Rqz/5FvOu{nhx1#mQxy0@95e'; -- encryption key 1
CALL "{OWNER}".start_OFSS_monitor();

-- On Foxhound Adhoc Query connection 1: 

CALL load_OFSS_samples ( @load_path = 'C:\\DATA\\OFSSddd12\\' );  

Could not execute statement.
Decryption error: Missing encryption key
SQLCODE=-851, ODBC 3 State="08001"
Line 1, column 1
CALL load_OFSS_samples ( @load_path = 'C:\\DATA\\OFSSddd12\\' )

Here's the corrected code:

-- On subject database 1:

PARAMETERS OWNER;
UPDATE "{OWNER}".OFSS_settings SET unload_path = 'C:\\DATA\\OFSSddd12\\';               -- folder 1
UPDATE "{OWNER}".OFSS_settings SET max_batch_duration = '2m';                           -- 2 minutes between batches
UPDATE "{OWNER}".OFSS_settings SET encryption_key = 'KeHX8?k1Rqz/5FvOu{nhx1#mQxy0@95e'; -- encryption key 1
CALL "{OWNER}".start_OFSS_monitor();


-- On Foxhound Adhoc Query connection 1: 

CALL load_OFSS_samples ( 
   @load_path = 'C:\\DATA\\OFSSddd12\\',                   -- folder 1 
   @encryption_key = 'KeHX8?k1Rqz/5FvOu{nhx1#mQxy0@95e' ); -- encryption key 1

This page was last updated on June 15 2019.      Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com