Problem about Business Data Model with PostgreSQL DB
We have a Bonita platform defined with PostgreSQL DB (a main BD and Business Model)..
I've interested in testing the Procurement example, using a BDM. Read data and delete data running success, but when I'll try to insert a new records (new MyObject), appear in the Window Code Inspector the follow error:
exception class org.bonitasoft.engine.exception.BonitaRuntimeException message USERNAMEfirstname.lastname@example.org | org.bonitasoft.engine.persistence.SRetryableException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
So, the new record it's impossible to insert.
Anyone know the solution ? Is it a trouble ? Sorry, we are using the Bonita BPM CE v7.3.2
Any helps we'll be apreciated.
From what you describe, I would say the problem lies with the data you are trying to add.
For example, it could be that you are trying to add some value in one of the fileds of MyObject for which a Unique constraint has been defined, and that such value already exists in your BDM.
In order to be able to identify the actual problem, though, it would help if you could share:
- the whole stack of the error (you can find it in the TOMCAT_HOME/logs/bonita.xxxx-xx-xx.log or JBOSS_HOME/standalone/logs/server.log file)
- the code where you are trying to insert the data
- the context in which you are trying to insert the data (is it an external client? a task in a process?...)