Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 979528

Summary: EnterpriseDB (PostgresPlus) 9.2: DBInitializerException: Could not create the DB schema of the workspace 'system'.
Product: [JBoss] JBoss Enterprise Portal Platform 6 Reporter: Tomas Kyjovsky <tkyjovsk>
Component: PortalAssignee: Nobody <nobody>
Status: CLOSED UPSTREAM QA Contact:
Severity: medium Docs Contact:
Priority: urgent    
Version: 6.1.0CC: epp-bugs, jpallich, theute, vramik
Target Milestone: DR01   
Target Release: 6.1.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
A bug in the JCR prevented the portal starting when an EnterpriseDB (PostgresPlus) 9.2 database was used. The error "DBInitializerException: Could not create the DB schema of the workspace 'system'" was thrown with a reason of "ERROR: syntax error at or near "generated"" as a result of the bug. The fix implements improvements to the JRC code which better handle the database, and corrects the originally reported issue.
 Story Points: ---
Clone Of: Environment:
PostgresPlus 9.2 (EnterpriseDB)
Last Closed: 2025-02-10 03:28:02 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
DBInitializerException none

Description Tomas Kyjovsky 2013-06-28 18:05:38 UTC 
Created attachment 766688 [details]
DBInitializerException

Description of problem:

SQL problem when initializing JCR tables.

org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create the DB schema of the workspace 'system'. Reason: ERROR: syntax error at or near "generated"


Steps to Reproduce:
1. configure JPP-6.1 ER01 with PostgresPlus 9.2 (including manually setting of hibernate.dialect for IDM and JCR datasources)
2. start portal
Comment 1 Tomas Kyjovsky 2013-06-28 18:09:12 UTC 
Related Jenkins build: https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.1/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_postgresplus92/22/
Comment 3 Tomas Kyjovsky 2013-07-02 11:52:47 UTC 
The same problem occurs with PostgreSQL driver: postgresql-9.2-1002.jdbc4.jar.
Comment 4 Tomas Kyjovsky 2013-07-02 13:10:10 UTC 
CORRECTION: I forgot to change jdbc URLs of datasources from jdbc:edb:// to jdbc:postgresql:// along with the driver jar. JPP+EDB is now working OK when PostgreSQL-9.2 driver is used (with jdbc:postgresql:// URL prefix).
Comment 5 Thomas Heute 2013-11-06 16:50:03 UTC 
Is it actually still a bug ? Or wrong config ?
Comment 6 Dominik Pospisil 2013-11-13 14:21:11 UTC 
Verified (GA + 0day patch)
Comment 10 Red Hat Bugzilla 2025-02-10 03:28:02 UTC 
This product has been discontinued or is no longer tracked in Red Hat Bugzilla.