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) violatedData: 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) violatedData: 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
DO you have a sequence defined in your PK? If not, Oracle won't be able to insert the data because of that...
Your first and last field are null... I guess the first is the PK, and must contain a value, or the value has to be generated by a sequence in DDBB