Bug 779206 (SOA-1599) - Exception when creating jBPM database
Summary: Exception when creating jBPM database
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-1599
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: JBossESB, JBPM - within SOA
Version: 5.0.0 ER3
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 5.0.0 GA,5.0.0 ER4
Assignee: Julian Coleman
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-11-16 07:56 UTC by Jiri Pechanec
Modified: 2011-07-19 13:21 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-12-14 05:05:37 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)
server.log.startup (113.74 KB, application/octet-stream)
2009-11-17 04:18 UTC, Len DiMaggio 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 779307 0 urgent CLOSED jUDDI database initialization fails on Oracle and db2 - not an issue for PostgreSQL 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 780732 0 urgent CLOSED Exception when creating jBPM database 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-1599 0 Critical Closed Exception when creating jBPM database 2013-08-15 12:47:56 UTC

Internal Links: 779307 780732

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
Note You need to log in before you can comment on or make changes to this bug.