Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 848131 Details for
Bug 1051464
A lot of "ORA-02275: such a referential constraint already exists in the table" when installing DB schema into Oracle DB
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
Schema tool log (manual use)
schema-tool.log (text/x-log), 48.58 KB, created by
Pavel Macik
on 2014-01-10 10:48:25 UTC
(
hide
)
Description:
Schema tool log (manual use)
Filename:
MIME Type:
Creator:
Pavel Macik
Created:
2014-01-10 10:48:25 UTC
Size:
48.58 KB
patch
obsolete
>Buildfile: /opt/pmacik/600Latest/soa-p/sql/build.xml > >procedures.check: > >procedures: > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/procedures/safe-guard-procedures.Oracle10gDialect.sql > [sql] 2 of 2 SQL statements executed successfully > >common.check: > >common: > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/common/hibernate_sequence.Oracle10gDialect.sql > [sql] 0 of 0 SQL statements executed successfully > >dtgov.check: > >dtgov: > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/dtgov/dtgov-war.org.overlord.dtgov.jbpm.Oracle10gDialect.sql > [sql] 101 of 101 SQL statements executed successfully > >riftsaw-ode.check: > >riftsaw-ode: > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/riftsaw-ode/riftsaw-dao-jpa-hibernate.ode-unit-test-embedded.Oracle10gDialect.sql > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/riftsaw-ode/riftsaw-dao-jpa.ode-bpel.Oracle10gDialect.sql > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_ACTIVITY_RECOVERY add constraint FK_5iwucbr1yngxjs16sxeej3xpp foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORRELATION_SET add constraint FK_j1vdkxghmf62wsykum7ut0mjp foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORRELATOR add constraint FK_6sqr3hmuqssl6v7en9extt6nb foreign key (PROC_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORSET_PROP add constraint FK_6vmj2n3pf8el6xupevpjpw0q5 foreign key (CORRSET_ID) references BPEL_CORRELATION_SET'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_on6qt1pmhmhq302bvn0afqrib foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_3i4chalwvtcsxnb3kitlk008i foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE add constraint FK_t7okesqhwuldkv1hh6gbqf2ou foreign key (MESSAGE_EXCHANGE_ID) references BPEL_MESSAGE_EXCHANGE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_h7khyrytsirwd8wab4u46m2n8 foreign key (CORR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_uonx6oawfknxho8jrf3rfk5c foreign key (PARTNER_LINK_ID) references BPEL_PARTNER_LINK'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_gb2u3yldxdoo1cwm0r4ueumks foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_c7spgx5vfvekg032033rpqdbk foreign key (CORR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_fxmbqc9xnjklj0k4bn1e2l34x foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MEX_PROP add constraint FK_4hprt848lqhnc8pjdxhslqy53 foreign key (MEX_ID) references BPEL_MESSAGE_EXCHANGE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PARTNER_LINK add constraint FK_n42xwpib34r1o4j3gum2o7teo foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_cbaftcdg3olwu6c1hb9uiysh8 foreign key (INSTANTIATING_CORRELATOR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_s6umxoyr597vbkk95ff9uwx8 foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_SCOPE add constraint FK_nuormejxj2iyfxm4yny8g2msh foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_XML_DATA add constraint FK_g0pgad8e5x63j502w4ps9ysnh foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_XML_DATA_PROP add constraint FK_5pv5xml1vgquncql9irej95k7 foreign key (XML_DATA_ID) references BPEL_XML_DATA'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROCESS add constraint FK_c8haf42aukvqr2udrtpyi3kdb foreign key (DU) references STORE_DU'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint UK_ld9y5wtckspqw9us9gfeokf6a unique (STORE_PROPERTY_ID)'); end; > [sql] java.sql.SQLSyntaxErrorException: ORA-02261: such unique or primary key already exists in the table > [sql] ORA-06512: at "SOAESB1.EXECUTE_IF_EXISTS", line 1 > [sql] ORA-06512: at line 1 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_ld9y5wtckspqw9us9gfeokf6a foreign key (STORE_PROPERTY_ID) references STORE_PROCESS_PROP'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_t19b3gjvbvqke3hh5mcdr2dwl foreign key (STORE_PROCESS_PID) references STORE_PROCESS'); 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 > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/riftsaw-ode/riftsaw-dao-jpa.ode-scheduler.Oracle10gDialect.sql > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_ACTIVITY_RECOVERY add constraint FK_5iwucbr1yngxjs16sxeej3xpp foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORRELATION_SET add constraint FK_j1vdkxghmf62wsykum7ut0mjp foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORRELATOR add constraint FK_6sqr3hmuqssl6v7en9extt6nb foreign key (PROC_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORSET_PROP add constraint FK_6vmj2n3pf8el6xupevpjpw0q5 foreign key (CORRSET_ID) references BPEL_CORRELATION_SET'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_on6qt1pmhmhq302bvn0afqrib foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_3i4chalwvtcsxnb3kitlk008i foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE add constraint FK_t7okesqhwuldkv1hh6gbqf2ou foreign key (MESSAGE_EXCHANGE_ID) references BPEL_MESSAGE_EXCHANGE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_h7khyrytsirwd8wab4u46m2n8 foreign key (CORR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_uonx6oawfknxho8jrf3rfk5c foreign key (PARTNER_LINK_ID) references BPEL_PARTNER_LINK'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_gb2u3yldxdoo1cwm0r4ueumks foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_c7spgx5vfvekg032033rpqdbk foreign key (CORR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_fxmbqc9xnjklj0k4bn1e2l34x foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MEX_PROP add constraint FK_4hprt848lqhnc8pjdxhslqy53 foreign key (MEX_ID) references BPEL_MESSAGE_EXCHANGE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PARTNER_LINK add constraint FK_n42xwpib34r1o4j3gum2o7teo foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_cbaftcdg3olwu6c1hb9uiysh8 foreign key (INSTANTIATING_CORRELATOR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_s6umxoyr597vbkk95ff9uwx8 foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_SCOPE add constraint FK_nuormejxj2iyfxm4yny8g2msh foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_XML_DATA add constraint FK_g0pgad8e5x63j502w4ps9ysnh foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_XML_DATA_PROP add constraint FK_5pv5xml1vgquncql9irej95k7 foreign key (XML_DATA_ID) references BPEL_XML_DATA'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROCESS add constraint FK_c8haf42aukvqr2udrtpyi3kdb foreign key (DU) references STORE_DU'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint UK_ld9y5wtckspqw9us9gfeokf6a unique (STORE_PROPERTY_ID)'); end; > [sql] java.sql.SQLSyntaxErrorException: ORA-02261: such unique or primary key already exists in the table > [sql] ORA-06512: at "SOAESB1.EXECUTE_IF_EXISTS", line 1 > [sql] ORA-06512: at line 1 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_ld9y5wtckspqw9us9gfeokf6a foreign key (STORE_PROPERTY_ID) references STORE_PROCESS_PROP'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_t19b3gjvbvqke3hh5mcdr2dwl foreign key (STORE_PROCESS_PID) references STORE_PROCESS'); 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 > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/riftsaw-ode/riftsaw-dao-jpa.ode-store.Oracle10gDialect.sql > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_ACTIVITY_RECOVERY add constraint FK_5iwucbr1yngxjs16sxeej3xpp foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORRELATION_SET add constraint FK_j1vdkxghmf62wsykum7ut0mjp foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORRELATOR add constraint FK_6sqr3hmuqssl6v7en9extt6nb foreign key (PROC_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_CORSET_PROP add constraint FK_6vmj2n3pf8el6xupevpjpw0q5 foreign key (CORRSET_ID) references BPEL_CORRELATION_SET'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_on6qt1pmhmhq302bvn0afqrib foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_3i4chalwvtcsxnb3kitlk008i foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE add constraint FK_t7okesqhwuldkv1hh6gbqf2ou foreign key (MESSAGE_EXCHANGE_ID) references BPEL_MESSAGE_EXCHANGE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_h7khyrytsirwd8wab4u46m2n8 foreign key (CORR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_uonx6oawfknxho8jrf3rfk5c foreign key (PARTNER_LINK_ID) references BPEL_PARTNER_LINK'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_gb2u3yldxdoo1cwm0r4ueumks foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_c7spgx5vfvekg032033rpqdbk foreign key (CORR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_fxmbqc9xnjklj0k4bn1e2l34x foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_MEX_PROP add constraint FK_4hprt848lqhnc8pjdxhslqy53 foreign key (MEX_ID) references BPEL_MESSAGE_EXCHANGE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PARTNER_LINK add constraint FK_n42xwpib34r1o4j3gum2o7teo foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_cbaftcdg3olwu6c1hb9uiysh8 foreign key (INSTANTIATING_CORRELATOR_ID) references BPEL_CORRELATOR'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_s6umxoyr597vbkk95ff9uwx8 foreign key (PROCESS_ID) references BPEL_PROCESS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_SCOPE add constraint FK_nuormejxj2iyfxm4yny8g2msh foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_XML_DATA add constraint FK_g0pgad8e5x63j502w4ps9ysnh foreign key (SCOPE_ID) references BPEL_SCOPE'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table BPEL_XML_DATA_PROP add constraint FK_5pv5xml1vgquncql9irej95k7 foreign key (XML_DATA_ID) references BPEL_XML_DATA'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROCESS add constraint FK_c8haf42aukvqr2udrtpyi3kdb foreign key (DU) references STORE_DU'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint UK_ld9y5wtckspqw9us9gfeokf6a unique (STORE_PROPERTY_ID)'); end; > [sql] java.sql.SQLSyntaxErrorException: ORA-02261: such unique or primary key already exists in the table > [sql] ORA-06512: at "SOAESB1.EXECUTE_IF_EXISTS", line 1 > [sql] ORA-06512: at line 1 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_ld9y5wtckspqw9us9gfeokf6a foreign key (STORE_PROPERTY_ID) references STORE_PROCESS_PROP'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_t19b3gjvbvqke3hh5mcdr2dwl foreign key (STORE_PROCESS_PID) references STORE_PROCESS'); 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 > [sql] 118 of 187 SQL statements executed successfully > >jbpm.check: > >jbpm: > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/jbpm/jbpm-test.org.jbpm.persistence.jpa.Oracle10gDialect.sql > [sql] Failed to execute: begin execute_if_exists('alter table Attachment add constraint FK_9jaco4irrkskr5phh97x2fe9h foreign key (attachedby_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Attachment add constraint FK_hqupx569krp0f0sgu9kh87513 foreign key (TaskData_Attachments_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 > [sql] Failed to execute: begin execute_if_exists('alter table BooleanExpression add constraint FK_394nf2qoc0k9ok6omgd6jtpso foreign key (Escalation_Constraints_Id) references Escalation'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table CorrelationPropertyInfo add constraint FK_1mgvtkn3h0bxu2fd657apkvxs foreign key (correlationkey_keyId) references CorrelationKeyInfo'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Deadline add constraint FK_68w742sge00vco2cq3jhbvmgx foreign key (Deadlines_StartDeadLine_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 > [sql] Failed to execute: begin execute_if_exists('alter table Deadline add constraint FK_euoohoelbqvv94d8a8rcg8s5n foreign key (Deadlines_EndDeadLine_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 > [sql] Failed to execute: begin execute_if_exists('alter table Delegation_delegates add constraint FK_gn7ula51sk55wj1o1m57guqxb foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Delegation_delegates add constraint FK_fajq6kossbsqwr3opkrctxei3 foreign key (task_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 > [sql] Failed to execute: begin execute_if_exists('alter table Escalation add constraint FK_ay2gd4fvl9yaapviyxudwuvfg foreign key (Deadline_Escalation_Id) references Deadline'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table EventTypes add constraint FK_nrecj4617iwxlc65ij6m7lsl1 foreign key (InstanceId) references ProcessInstanceInfo'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_k16jpgrh67ti9uedf6konsu1p foreign key (Task_Subjects_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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_fd9uk6hemv2dx1ojovo7ms3vp foreign key (Task_Names_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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_4eyfp69ucrron2hr7qx4np2fp foreign key (Task_Descriptions_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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_pqarjvvnwfjpeyb87yd7m0bfi foreign key (Reassignment_Documentation_Id) references Reassignment'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_o84rkh69r47ti8uv4eyj7bmo2 foreign key (Notification_Subjects_Id) references Notification'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_g1trxri8w64enudw2t1qahhk5 foreign key (Notification_Names_Id) references Notification'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_qoce92c70adem3ccb3i7lec8x foreign key (Notification_Documentation_Id) references Notification'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_bw8vmpekejxt1ei2ge26gdsry foreign key (Notification_Descriptions_Id) references Notification'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table I18NText add constraint FK_21qvifarxsvuxeaw5sxwh473w foreign key (Deadline_Documentation_Id) references Deadline'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Notification add constraint FK_bdbeml3768go5im41cgfpyso9 foreign key (Escalation_Notifications_Id) references Escalation'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Notification_BAs add constraint FK_mfbsnbrhth4rjhqc2ud338s4i foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Notification_BAs add constraint FK_fc0uuy76t2bvxaxqysoo8xts7 foreign key (task_id) references Notification'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Notification_Recipients add constraint FK_blf9jsrumtrthdaqnpwxt25eu foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Notification_Recipients add constraint FK_3l244pj8sh78vtn9imaymrg47 foreign key (task_id) references Notification'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Notification_email_header add constraint UK_25vn3oqfsiwwda26w9uiprrwe unique (emailheaders_id)'); end; > [sql] java.sql.SQLSyntaxErrorException: ORA-02261: such unique or primary key already exists in the table > [sql] ORA-06512: at "SOAESB1.EXECUTE_IF_EXISTS", line 1 > [sql] ORA-06512: at line 1 > [sql] Failed to execute: begin execute_if_exists('alter table Notification_email_header add constraint FK_25vn3oqfsiwwda26w9uiprrwe foreign key (emailheaders_id) references email_header'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Notification_email_header add constraint FK_eth4nvxn21fk1vnju85vkjrai foreign key (Notification_id) references Notification'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_BAs add constraint FK_t38xbkrq6cppifnxequhvjsl2 foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_BAs add constraint FK_omjg5qh7uv8e9bolbaq7hv6oh foreign key (task_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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_ExclOwners add constraint FK_pth28a73rj6bxtlfc69kmqo0a foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_ExclOwners add constraint FK_b8owuxfrdng050ugpk0pdowa7 foreign key (task_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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_PotOwners add constraint FK_tee3ftir7xs6eo3fdvi3xw026 foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_PotOwners add constraint FK_4dv2oji7pr35ru0w45trix02x foreign key (task_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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_Recipients add constraint FK_4g7y3wx6gnokf6vycgpxs83d6 foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_Recipients add constraint FK_enhk831fghf6akjilfn58okl4 foreign key (task_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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_Stakeholders add constraint FK_met63inaep6cq4ofb3nnxi4tm foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table PeopleAssignments_Stakeholders add constraint FK_4bh3ay74x6ql9usunubttfdf1 foreign key (task_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 > [sql] Failed to execute: begin execute_if_exists('alter table Reassignment add constraint FK_pnpeue9hs6kx2ep0sp16b6kfd foreign key (Escalation_Reassignments_Id) references Escalation'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Reassignment_potentialOwners add constraint FK_8frl6la7tgparlnukhp8xmody foreign key (entity_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Reassignment_potentialOwners add constraint FK_qbega5ncu6b9yigwlw55aeijn foreign key (task_id) references Reassignment'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Task add constraint FK_7hos7h1ft5wygyru9vm2mtp6b foreign key (peopl_assign_taskinitiator_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Task add constraint FK_iu0slqdkjbb9mvikrns8mvqcg foreign key (taskdata_actualowner_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table Task add constraint FK_tek6betmy2fl0bnwrsx9a4fi9 foreign key (taskdata_createdby_id) references OrganizationalEntity'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table task_comment add constraint FK_fencp0rt8gae730n7621vqjre foreign key (addedby_id) references OrganizationalEntity'); 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 > [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 > [sql] 56 of 101 SQL statements executed successfully > >rtgov.check: > >rtgov: > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/rtgov/gadget-web.gadget-core.Oracle10gDialect.sql > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/rtgov/overlord-rtgov-epn.overlord-rtgov-epn.Oracle10gDialect.sql > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/rtgov/overlord-rtgov.overlord-rtgov-activity.Oracle10gDialect.sql > [sql] Failed to execute: begin execute_if_exists('alter table RTGOV_ACTIVITIES add constraint FK_qkn2182qh2hf52txyugoloqaq foreign key (unitId) references RTGOV_ACTIVITY_UNITS'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table RTGOV_ACTIVITY_CONTEXT add constraint FK_taqus05muupkc8xuuyig97lx7 foreign key (unitId, unitIndex) references RTGOV_ACTIVITIES'); 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 > [sql] Failed to execute: begin execute_if_exists('alter table RTGOV_ACTIVITY_PROPERTIES add constraint FK_c5src0indd1kbiljcs7ruf2rc foreign key (unitId, unitIndex) references RTGOV_ACTIVITIES'); 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 > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/data/rtgov/import_rtgov.Oracle10gDialect.sql > [sql] 39 of 42 SQL statements executed successfully > >indexes.check: > >indexes: > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/indexes/dtgov.Oracle10gDialect.sql > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/indexes/jbpm.Oracle10gDialect.sql > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/indexes/riftsaw.Oracle10gDialect.sql > [sql] Executing resource: /opt/pmacik/600Latest/soa-p/sql/indexes/rtgov.Oracle10gDialect.sql > [sql] 120 of 120 SQL statements executed successfully > >all: > >BUILD SUCCESSFUL >Total time: 7 seconds
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 1051464
: 848131 |
848203