SAP Knowledge Base Article - Preview

2480936 - Decryption error "Input passed to decrypt has length ..." - SAP IQ

Symptom

Decryption error happened when trying to decrypt an encrypted data in an SAP IQ.

Query :
SELECT C1, AES_DECRYPT(C2,'seCr3t', varchar(17)) AS DECRYPT_C2 FROM ENCRYPT_TEST;

Error :
I. 05/26 03:14:10. 0000001327 Txn 525265 0 525265
I. 05/26 03:14:10. 0000001327 Exception Thrown from oslib/hos_encrypt.cxx:805, Err# 1074, tid 3 origtid 3
I. 05/26 03:14:10. 0000001327 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1001064, SQLState: 'QFA57', Severity: 14
I. 05/26 03:14:10. 0000001327 [20562]: Decryption error: Input passed to decrypt has length 32, not 48; it could be due to truncation of the cypher-text or an incorrect encryption key.
-- (oslib/hos_encrypt.cxx 805)


Read more...

Environment

SAP IQ 15.x
SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

SAP IQ, IQ, Decryption, Decryption error, AES_DECRYPT, AES_ENCRYPT, oslib/hos_encrypt , 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.