I have Created a simple process with multiple lane, when I try to deploy it, I get the following error..

Q&A
1

ERROR: Unique index or primary key violation:, process_id, NAME, TYPE), type, PROCESS_ID, Content, Tenantid, id) values (?, ?, ?) [23505-170]

INFO: THREAD_ID=62 | HOSTNAME=ABCDA | TENANT_ID=1 | The user <walter.bates> has installed process in version <1.0> with id <5244158109208185678>
2016-12-15 18:25:41.868 +0530 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 23505, SQLState: 23505
2016-12-15 18:25:41.868 +0530 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Unique index or primary key violation: “CONSTRAINT_INDEX_29 ON PUBLIC.BAR_RESOURCE(TENANTID, PROCESS_ID, NAME, TYPE)”; SQL statement:
insert into bar_resource (name, type, process_id, content, tenantId, id) values (?, ?, ?, ?, ?, ?) [23505-170]
2016-12-15 18:25:41.869 +0530 org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorNonTrackingImpl org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorNonTrackingImpl$2 mapManagedFlushFailure
ERROR: HHH000346: Error during managed flush [could not execute statement]
2016-12-15 18:25:41.916 +0530 org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl releaseStatements
ERROR: HHH000352: Unable to release batch statement…
2016-12-15 18:25:41.916 +0530 org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl releaseStatements
ERROR: HHH000246: SQLException escaped proxy
org.h2.jdbc.JdbcSQLException: The object is already closed [90007-170]

I am very much new to bonitasoft, so someone please help me out

2

Hi,

That’s interesting, do you want to give us more information about your setup, like OS, bonita version, database, etc… So we can understand the issue better.

Also if you want to share with us the BOS file of your process, maybe someone can take a look.

Cheers

3

Hi,
Thanks for responding. My OS version is windows 7 enterprise version, Bonita version: 7.2.3, Database : H2(embedded). I had changed the default organisation and created mine, when I tried to map the users to new organisation , I got these errors.

4

Do you get the same issue using the original organization?

To simplify the issue resolution, I would suggest validating that the Studio is working fine after a clean install. At least, you’ll know that your environment is stable.