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


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


This page was last updated on July 12, 2020.      Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com