SAP Knowledge Base Article - Preview

3496667 - Common Errors Caused By Limitations of HANA Client-Side Data Encryption

Symptom

Symptom 1

  • When creating a new HANA table with columns encrypted by client-side encryption or enable the same encryption for existing table columns, you get error:
    SAP DBTech JDBC: [7]: feature not supported: No Primary key found in table with encrypted column

Symptom 2

  • When altering table type (row to column, or vice versa), you get error:
    SAP DBTech JDBC: [7]: feature not supported: Cannot change table type for table with encrypted column

Symptom 3

  • When executing SQL with group by clause on encrypted column, you get error:
    SAP DBTech JDBC: [7]: feature not supported: Encrypted column can't be in groupby

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental     


Read more...

Environment

SAP HANA Platform Edition 2.0 SPS03 and above

Product

SAP HANA, platform edition 2.0

Keywords

client-side encryption, client-side data encryption, primary key, change table type , KBA , HAN-DB-SEC , SAP HANA Security & User Management , 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.