SAP Knowledge Base Article - Preview

2055121 - Error 3762 "The decrypt_default for column ... was not found" when dropping a table with an encrypted column - SAP ASE

Symptom

  • ASE configured for use of encrypted columns
  • Encryption key created in user database A
  • Table created in user database B utilizing encryption key from database A
  • Attempt to drop the database B table from master database fails with error 3762:

Msg 3762, Level 18, State 1:
Server 'SYBASE', Line 1:
The decrypt_default for column id 2 was not found in the system catalogs.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.x 
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

Encryption key,column,decrypt , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.