Re: Can't have same invoiceID for invoices created in different years

2021-02-20 Thread Michael Brohl
Hi Andrei, if you load data through XML files, there is no application logic in play. It's a plain import to the database. So if you load invoices with the same invoice id (which is the primary key for the invoice table), the second dataset will overwrite the first. The mentioned setting

Re: System error, could not commit transaction XAException (null) on resuming transaction

2021-02-20 Thread Michael Brohl
Hi Giulio, are there any other ressources in play except OFBiz and a direct connection to the MariaDB database? Like another database for e.g. audit data or else being part of the XA transaction? It seems that one of the participants of the transaction does not respond during the two phase

Re: System error, could not commit transaction XAException (null) on resuming transaction

2021-02-20 Thread Giulio Speri - MpStyle Srl
Hello Michael, I tried to increase a larger timeout on the parent transaction on the parent transaction, but the result was the same, but I could debug a little bit more the service, and the error is raised in the method commit() of TransactionUtil and searching between all the debug objects I

Can't have same invoiceID for invoices created in different years

2021-02-20 Thread Andrei Stan
Hello everyone, I want to import some of my old invoices into ofbiz, and some of those invoices have the same id, but were created in different time periods, different years. So, for example, i have *EU-1 *created in 2019**and *EU-1 *created in 2020. When importing the xml file with data