Symptom
AES_DECRYPT function fails with Decryption error after the database did migrate to the different release version.
Query
select AES_DECRYPT ( col1, 'enkey', VARCHAR(60) ) FROM tableA
Error message
Decryption error: Incorrect CAST type varchar(60) for decrypt data of type numeric(60,0).
-- (hos_encrypt.cxx 1015)
SQLCODE=-1001064, ODBC 3 Status = "HY000"
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
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.