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.