Symptom
- The following error is appearing:
SQL Error [406] [HY000]: SAP DBTech JDBC: [406]: INSERT, UPDATE and UPSERT are disallowed on the generated field:
cannot insert into generated identity column field PARTNERENTRYID: line 1 col 53(at pos 52)
- The tables were generated using Java EclipseLink JPA provider package, when attempting to import data, it result in the Identity column error. This worked in HANA 1, but the above error arose in HANA 2 Version: 2.00.054.00.
- The following error may also occur during a client copy
2EETW000 sql error: 406 INSERT, UPDATE and UPSERT are disallowed on the generated field: cannot insert into generated field ERKRS: line 1 col 74 (at pos 73)
2EETW125 SQL error "406" during "" access: "INSERT, UPDATE and UPSERT are disallowed on the generated field: cannot insert into generated field ERKRS: line 1 col 74 (at pos 73)"
4 ETW690 ROLLBACK "56256" "58069544038"
1 ETP154 MAIN IMPORT
1 ETP110 end date and time : "20220421230719"
1 ETP111 exit code: "12"
Read more...
Environment
SAP HANA, Platform Edition 2.0
Product
SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB , SAP HANA Database , 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.