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