Bug 1051464
| Summary: | A lot of "ORA-02275: such a referential constraint already exists in the table" when installing DB schema into Oracle DB | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Fuse Service Works 6 | Reporter: | Pavel Macik <pmacik> | ||||||
| Component: | Build Process | Assignee: | Julian Coleman <jcoleman> | ||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Pavel Macik <pmacik> | ||||||
| Severity: | urgent | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 6.0.0 GA | CC: | atangrin, dlesage, ldimaggi, ncross, soa-p-jira, vdedik | ||||||
| Target Milestone: | CR1 | Keywords: | Regression | ||||||
| Target Release: | 6.0.0 | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 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: |
|
||||||||
Created attachment 848131 [details]
Schema tool log (manual use)
The JDBC driver is ojdbc6.jar. The issue is introduced in 6.0.0.ER8 build. Regression - not seen in ER7 Created attachment 848203 [details]
SQL log generated by FSW installer
Verified in CR1. |
Steps to reproduce (starting with FSW installer): 1.) install FSW with the options out-of-the-box + install Oracle driver (ojdbc.jar) - $FSW is the directory FSW was installed 2.) starting with empty database execute following command: $ ant -f $FSW/sql/build.xml-Ddriverjarloc=$FSW/modules/oracle/jdbc/main -Ddb.driver=oracle.jdbc.driver.OracleDriver -Ddb.url=jdbc:oracle:thin:@DB_HOST:1521:$DB_NAME -Ddb.user=$DB_USER -Ddb.password=$DB_PASS -Ddb.dialect=Oracle10gDialect A lot of following errors is generated for riftsaw-ode, jbpm and rtgov - for instance: [sql] Failed to execute: begin execute_if_exists('alter table task_comment add constraint FK_1ws9jdmhtey6mxu7jb0r0ufvs foreign key (TaskData_Comments_Id) references Task'); end; [sql] java.sql.SQLSyntaxErrorException: ORA-02275: such a referential constraint already exists in the table [sql] ORA-06512: at "SOAESB1.EXECUTE_IF_EXISTS", line 1 [sql] ORA-06512: at line 1 See attached log.