Bug 779206 (SOA-1599)

Summary: Exception when creating jBPM database
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Jiri Pechanec <jpechane>
Component: JBossESB, JBPM - within SOAAssignee: Julian Coleman <jcoleman>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.0.0 ER3   
Target Milestone: ---   
Target Release: 5.0.0 GA, 5.0.0 ER4   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-1599
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-12-14 05:05:37 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
server.log.startup none

Description Jiri Pechanec 2009-11-16 07:56:40 UTC 
Date of First Response: 2009-11-16 04:33:49
project_key: SOA

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.
Comment 1 Kevin Conner 2009-11-16 09:33:49 UTC 
The juddi issue is already under investigation.
Comment 2 Len DiMaggio 2009-11-17 04:18:41 UTC 
Example server log
Comment 3 Len DiMaggio 2009-11-17 04:18:41 UTC 
Attachment: Added: server.log.startup
Comment 4 Julian Coleman 2009-12-02 15:31:01 UTC 
This was fixed with the import of ESB 4.7 GA.
Comment 5 Julian Coleman 2009-12-10 16:15:15 UTC 
Link: Added: This issue related SOA-1695
Comment 6 Jiri Pechanec 2009-12-14 05:05:37 UTC 
Verified in ER5
Comment 7 Jiri Pechanec 2011-07-19 13:21:30 UTC 
Link: Added: This issue Cloned to SOA-3187