Attachment 848131 Details for Bug 1051464 – Schema tool log (manual use)

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:

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

Actions: View

Attachments on bug 1051464: 848131 | 848203