Error occurred while writing the data to datastore - Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint

Certified Senior Developer

Hi All,

We are using "write to data store entity" smart service for storing the data into the database and getting the below error and there are no unique constraints declared in the XSD and Table.

Below are the two requests which occurred while executing the smart service

Error 1:

An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=VT_TASK_MASTER (id=3112)] (data store: VT Tables). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIANBUSINESS_PROD.SYS_C0059560507) violated
Data: TypedValue[it=3113,v={{<null>,43,Initiation,initiation,1,Employee,User(s),7,1,ltideploymentAccount,2024-08-05 14:47:12.64,,<null>,1,[Group:1261],0}}]

Error 2:

An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=VT_TASK_MASTER (id=3112)] (data store: VT Tables). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIANBUSINESS_PROD.SYS_C0059560507) violated
Data: TypedValue[it=3113,v={{<null>,61,Initiation,Initation,1,Employee,User(s),10,1,ltideploymentAccount,2024-08-05 15:27:37.16,,<null>,1,,0}}]

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data