User configuration issue in dataflow pipeline

Question

{"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'sink1': java.sql.BatchUpdateException: Cannot insert explicit value for identity column in table 'Car' when IDENTITY_INSERT is set to OFF.","Details":"java.sql.BatchUpdateException: Cannot insert explicit value for identity column in table 'Car' when IDENTITY_INSERT is set to OFF

pipeline id is 174c9472-f815-479c-9b70-e2178e28d55a

Answer 1

Hi @Srinidhi Adiga ,

Thank you for posting query in Microsoft Q&A Platform.

As per my understanding you are getting error "Cannot insert explicit value for identity column in table 'Car' when IDENTITY_INSERT is set to OFF." while running your data flow. Kindly correct me if my understanding is wrong.

Above error will come when you try to insert values explicitly to in to identity column.

You consider below options to over come this issue.

• Remove identity on column or SET IDENTITY_INSERT ON on column. Click here to know about how to set IDENTITY_INSERT ON.
  OR
• Make sure to not supply values for your identify column from data flow.

Hope this will help. Please let us know if any further queries.

-------------

Please consider hitting Accept Answer. Accepted answers helps community as well.