Message: Incorrect or missing encryption key ... Exception in load_OFSS_samples
Message: -1188 LOAD TABLE error: The data to load is not encrypted
Message: -840 Incorrect or missing encryption key
Message: -851 Decryption error: Missing encryption key
Message: Decryption error: Missing encryption key SQLCODE -851
Message: LOAD TABLE error: The data to load is not encrypted SQLCODE -1188
Message: Missing encryption key SQLCODE -851
Message: The data to load is not encrypted SQLCODE -1188
Explanation: The OFSS files created by CALL load_OFSS_samples() statement must have the same (or no) encryption keys as the files read by CALL load_OFSS_samples() statement.
If there are any encryption key mismatches, the CALL load_OFSS_samples() statement will fail with an exception and an ISQL error message:
start_OFSS_monitor() load_OFSS_samples() Result
==================== =================== ======
no key no key OK
key matching key OK
no key key SQLCODE -1188 LOAD TABLE error: The data to load is not encrypted
key no key SQLCODE -851 Decryption error: Missing encryption key
key different key SQLCODE -840 Incorrect or missing encryption key
Workaround: Delete the mismatching files from the OFSS data folder,
or move each set of files with matching (or no) encryption keys to a separate folder and use separate CALL load_OFSS_samples() statements.
Here are what the exceptions and error messages look like:
start_OFSS_monitor() load_OFSS_samples() Result
==================== =================== ======
no key key SQLCODE -1188 LOAD TABLE error: The data to load is not encrypted
158 - 2020-07-12 10:23:41.076 Full Build 5484a 37820 1600Bd1(OFSS1600Beh1) Exception in load_OFSS_samples: SQLCODE = -1188, SQLSTATE = WL013,
ERRORMSG() = LOAD TABLE error: The data to load is not encrypted, batch number = 0, subject database [sampling_id is ZERO]
Could not execute statement.
LOAD TABLE error: The data to load is not encrypted
SQLCODE=-1188, ODBC 3 State="HY000"
Line 1, column 1
CALL load_OFSS_samples ( @load_path = 'C:\\DATA\\OFSS\\', @encryption_key = 'KeHX8?k1Rqz/5FvOu{nhx1#mQxy0@95e' )
|
start_OFSS_monitor() load_OFSS_samples() Result
==================== =================== ======
key no key SQLCODE -851 Decryption error: Missing encryption key
159 - 2020-07-12 10:30:06.431 Full Build 5484a 37820 1600Bd1(OFSS1600Beh1) Exception in load_OFSS_samples: SQLCODE = -851, SQLSTATE = 08W63,
ERRORMSG() = Decryption error: Missing encryption key, batch number = 0, subject database [sampling_id is ZERO]
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\\OFSS\\' )
|
start_OFSS_monitor() load_OFSS_samples() Result
==================== =================== ======
key different key SQLCODE -840 Incorrect or missing encryption key
162 - 2020-07-12 10:35:07.591 Full Build 5484a 37820 1600Bd1(OFSS1600Beh1) Exception in load_OFSS_samples: SQLCODE = -840, SQLSTATE = 08W62,
ERRORMSG() = Incorrect or missing encryption key, batch number = 0, subject database [sampling_id is ZERO]
Could not execute statement.
Incorrect or missing encryption key
SQLCODE=-840, ODBC 3 State="08001"
Line 1, column 1
CALL load_OFSS_samples ( @load_path = 'C:\\DATA\\OFSS\\', @encryption_key = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' )
|
|