https://connect.hyland.com/t5/nuxeo-forum/batchupdateexception-while-creating-a-document/m-p/320681#M7682 <P>You're trying to create several documents in the same folder with the same name (<CODE>AADHAAR_CARD</CODE>). The Nuxeo code attempts to detect pre-existing documents with the same name and provide a new one (<CODE>AADHAAR_CARD.1593524158152</CODE>) but this is not perfect, as it will fail if done with high concurrency. You should do your creations with different names for different documents in the same folder.</P> Sat, 04 Jul 2020 13:57:48 GMT Florent_Guillau 2020-07-04T13:57:48Z https://connect.hyland.com/t5/nuxeo-forum/batchupdateexception-while-creating-a-document/m-p/320680#M7681 <P>I doing performance testing of Nuxeo instance but I am sometime getting BatchUpdateException. I am uploading same file repeatedly with different metadata. I am using Postgres as backend DB.</P> <PRE><CODE>Failed to save session, java.sql.BatchUpdateException: Batch entry 0 INSERT INTO \"hierarchy\" (\"id\", \"parentid\", \"pos\", \"name\", \"isproperty\", \"primarytype\", \"mixintypes\", \"ischeckedin\", \"baseversionid\", \"majorversion\", \"minorversion\", \"isversion\", \"isretentionactive\", \"istrashed\", \"systemchangetoken\", \"changetoken\") VALUES (75680, 909, NULL, 'AADHAAR_CARD.1593524158152', 'FALSE', 'Picture', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, 0) was aborted: ERROR: duplicate key value violates unique constraint \"hierarchy_unique_child\"\n Detail: Key (parentid, name)=(909, AADHAAR_CARD.1593524158152) already exists. Call getNextException to see other errors in the batch. </CODE></PRE> Thu, 02 Jul 2020 14:22:21 GMT https://connect.hyland.com/t5/nuxeo-forum/batchupdateexception-while-creating-a-document/m-p/320680#M7681 Ankush_Bandil 2020-07-02T14:22:21Z https://connect.hyland.com/t5/nuxeo-forum/batchupdateexception-while-creating-a-document/m-p/320681#M7682 <P>You're trying to create several documents in the same folder with the same name (<CODE>AADHAAR_CARD</CODE>). The Nuxeo code attempts to detect pre-existing documents with the same name and provide a new one (<CODE>AADHAAR_CARD.1593524158152</CODE>) but this is not perfect, as it will fail if done with high concurrency. You should do your creations with different names for different documents in the same folder.</P> Sat, 04 Jul 2020 13:57:48 GMT https://connect.hyland.com/t5/nuxeo-forum/batchupdateexception-while-creating-a-document/m-p/320681#M7682 Florent_Guillau 2020-07-04T13:57:48Z