SAP Knowledge Base Article - Preview

3070791 - INSERT, UPDATE and UPSERT are disallowed on the generated field

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 Version2.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.