SAP Knowledge Base Article - Preview

1957044 - Data extraction facility cannot be converted the decrypted numeric type - SAP IQ


  • IQ can be stored in the column of encrypted data.
  • Encryption and decryption of data uses AES_ENCRYPT functions and AES_DECRYPT function.
  • However, data extraction facility of IQ cannot be converted numeric types of AES_DECRYPT:

Data exception - data type conversion is not possible.
  -- (dfo_Root.cxx 2192)
SQLCODE=-1001006, ODBC 3 State="HY000"



  • SAP IQ 15.x
  • SAP IQ 16.0


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


TEMP_EXTRACT_NAME1, aes_encrypt, aes_decrypt, int, CR753327, 753327 , 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.