SAP Knowledge Base Article - Preview

2077783 - AES_DECRYPT function fails with Decryption error after the database migration

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.