Symptom
A decryption error happened when running a query having an AES_DECRYPT function.
Query :
SELECT C1, AES_DECRYPT(C2,'seCr3t', varchar(4)) AS DECRYPT_C2 FROM ENCRYPT_TEST;
Error :
I. 05/26 03:41:25. 0000003560 Txn 527158 0 527158
I. 05/26 03:41:25. 0000003560 Exception Thrown from dflib/dfe_SystemFunction.cxx:1353, Err# 1074, tid 4 origtid 4
I. 05/26 03:41:25. 0000003560 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1001064, SQLState: 'QFA57', Severity: 14
I. 05/26 03:41:25. 0000003560 [20562]: Decryption error: Input must be a multiple of 16 bytes in length for AES.
-- (dflib/dfe_SystemFunction.cxx 1353)
Read more...
Environment
SAP IQ 15.x
SAP IQ 16.0
Product
Keywords
SAP IQ, IQ, Decryption, Decryption error, AES_DECRYPT, AES_ENCRYPT, dflib/dfe_SystemFunction , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.