Red Hat Bugzilla – Bug 779206
Exception when creating jBPM database
Last modified: 2011-07-19 09:21:30 EDT
Date of First Response: 2009-11-16 04:33:49
When starting ER3 configured for PostgreSQL then an exception is thrown
2009-11-16 08:44:54,879 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb:service=JBPMDatabaseInitializer state=Create mode=Manual requiredState=Installed
org.postgresql.util.PSQLException: ERROR: relation "hibernate_sequence" already exists
The reason is the jUDDI now uses Hibernate for persistence too and during jUDDI db setup the sequence in question is created. Then jBPM SQL scripts tries to create sequence too and fails.
The juddi issue is already under investigation.
Example server log
Attachment: Added: server.log.startup
This was fixed with the import of ESB 4.7 GA.
Link: Added: This issue related SOA-1695
Verified in ER5
Link: Added: This issue Cloned to SOA-3187