[jboss-user] [JBoss jBPM] - Re: login to jbpm_console failed

[naseem.k]

Hi Guys,

Finally I am able to login to jbpm-console page by adding records in JBPM_ID_MEMBERSHIP table for the new users I created and assigned them to a group by groupid as a foreign key.

Now I am getting exception at the time of process start.

First time when I start a new process, it works fine. There is no exception on the console. Second time when I start the same process version, exception is generated on the console saying...


anonymous wrote : 15:32:26,701 DEBUG [JbpmContext] closing JbpmContext
  | 15:32:26,701 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService at 1fa2b3e
  | 15:32:26,701 DEBUG [DbPersistenceService] committing hibernate transaction
  | 15:32:26,717 WARN  [JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
  | 15:32:26,717 ERROR [JDBCExceptionReporter] ORA-00001: unique constraint (RND.SYS_C0014481) violated
  | 
  | 15:32:26,717 WARN  [JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
  | 15:32:26,717 ERROR [JDBCExceptionReporter] ORA-00001: unique constraint (RND.SYS_C0014481) violated
  | 
  | 15:32:26,732 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
  | org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  |         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
  |         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  |         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
  |         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
  |         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
  |         at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
  |         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2106)
  |         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
  |         at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
  |         at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
  |         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
  |         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
  |         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.ja
  | va:297)

I got this exception only with oracle database. With hypersonic database, there was no exception.

Please help. What could be the cause?

Thanks
Naseem

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047179#4047179

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047179