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 848203 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.
SQL log generated by FSW installer
sqlresults.log (text/x-log), 200.97 KB, created by
Pavel Macik
on 2014-01-10 13:36:25 UTC
(
hide
)
Description:
SQL log generated by FSW installer
Filename:
MIME Type:
Creator:
Pavel Macik
Created:
2014-01-10 13:36:25 UTC
Size:
200.97 KB
patch
obsolete
>Detected Java version: 1.7 in: /mnt/jqa/sw/jdk/sun/jdk1.7.0_25-x86_64/jre >Detected OS: Linux >parsing buildfile /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/build.xml with URI = file:/opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/build.xml >Project base dir set to: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql >parsing buildfile jar:file:/opt/pmacik/600ER8/jboss-fsw-installer-6.0.0.ER8-redhat-1.jar!/org/apache/tools/ant/antlib.xml with URI = jar:file:/opt/pmacik/600ER8/jboss-fsw-installer-6.0.0.ER8-redhat-1.jar!/org/apache/tools/ant/antlib.xml from a zip file >Property "db.driver" has not been set >Override ignored for property "driver" >Property "db.url" has not been set >Override ignored for property "url" >Property "db.user" has not been set >Override ignored for property "username" >Property "db.password" has not been set >Override ignored for property "password" >Override ignored for property "dialect" >Override ignored for property "driverjarloc" >Build sequence for target(s) `all' is [procedures.check, procedures, common.check, common, dtgov.check, dtgov, riftsaw-ode.check, riftsaw-ode, jbpm.check, jbpm, rtgov.check, rtgov, indexes.check, indexes, all] >Complete build sequence is [procedures.check, procedures, common.check, common, dtgov.check, dtgov, riftsaw-ode.check, riftsaw-ode, jbpm.check, jbpm, rtgov.check, rtgov, indexes.check, indexes, all, ] > >procedures.check: >[available] Found directory: procedures > >procedures: > [sql] connecting to jdbc:oracle:thin:@jawa06.mw.lab.eng.brq.redhat.com:1521:soaesb1 > [sql] Loading oracle.jdbc.OracleDriver using AntClassLoader with classpath /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/modules/oracle/jdbc/main/ojdbc6.jar > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/procedures/safe-guard-procedures.Oracle10gDialect.sql > [sql] SQL: CREATE OR REPLACE PROCEDURE execute_if_exists(statement VARCHAR) AUTHID CURRENT_USER AS table_does_not_exist exception; PRAGMA EXCEPTION_INIT(table_does_not_exist, -00942); sequence_does_not_exist exception; PRAGMA EXCEPTION_INIT(sequence_does_not_exist, -02289); name_already_in_use exception; PRAGMA EXCEPTION_INIT(name_already_in_use, -00955); BEGIN EXECUTE IMMEDIATE statement; EXCEPTION WHEN table_does_not_exist THEN NULL; WHEN sequence_does_not_exist THEN NULL; WHEN name_already_in_use THEN NULL; END; > [sql] 0 rows affected > [sql] SQL: CREATE OR REPLACE PROCEDURE execute_if_not_exists(statement VARCHAR) AUTHID CURRENT_USER AS name_already_in_use exception; PRAGMA EXCEPTION_INIT(name_already_in_use, -00955); BEGIN EXECUTE IMMEDIATE statement; EXCEPTION WHEN name_already_in_use THEN NULL; END; > [sql] 0 rows affected > [sql] 2 of 2 SQL statements executed successfully > >common.check: >[available] Found directory: common > >common: > [sql] connecting to jdbc:oracle:thin:@jawa06.mw.lab.eng.brq.redhat.com:1521:soaesb1 > [sql] Loading oracle.jdbc.OracleDriver using a cached AntClassLoader. > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/common/hibernate_sequence.Oracle10gDialect.sql > [sql] 0 of 0 SQL statements executed successfully > >dtgov.check: >[available] Found directory: dtgov > >dtgov: > [sql] connecting to jdbc:oracle:thin:@jawa06.mw.lab.eng.brq.redhat.com:1521:soaesb1 > [sql] Loading oracle.jdbc.OracleDriver using a cached AntClassLoader. > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/dtgov/dtgov-war.org.overlord.dtgov.jbpm.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table Attachment ( id number(19,0) not null, accesstype number(10,0), attachedat timestamp, attachmentcontentid number(19,0) not null, contenttype varchar2(255 char), name varchar2(255 char), attachment_size number(10,0), attachedby_id varchar2(255 char), TaskData_Attachments_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BAMTaskSummary ( pk number(19,0) not null, createddate timestamp, duration number(19,0), enddate timestamp, processinstanceid number(19,0) not null, startdate timestamp, status varchar2(255 char), taskid number(19,0) not null, taskname varchar2(255 char), userid varchar2(255 char), primary key (pk) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BooleanExpression ( id number(19,0) not null, expression clob, type varchar2(255 char), Escalation_Constraints_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Content ( id number(19,0) not null, content blob, primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ContextMappingInfo ( mappingid number(19,0) not null, CONTEXT_ID varchar2(255 char) not null, KSESSION_ID number(10,0) not null, OPTLOCK number(10,0), primary key (mappingid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table CorrelationKeyInfo ( keyId number(19,0) not null, name varchar2(255 char), processinstanceid number(19,0) not null, OPTLOCK number(10,0), primary key (keyId) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table CorrelationPropertyInfo ( propertyId number(19,0) not null, name varchar2(255 char), value varchar2(255 char), OPTLOCK number(10,0), correlationkey_keyId number(19,0), primary key (propertyId) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Deadline ( id number(19,0) not null, deadline_date timestamp, escalated number(5,0), Deadlines_StartDeadLine_Id number(19,0), Deadlines_EndDeadLine_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Delegation_delegates ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Escalation ( id number(19,0) not null, name varchar2(255 char), Deadline_Escalation_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table EventTypes ( InstanceId number(19,0) not null, element varchar2(255 char) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table I18NText ( id number(19,0) not null, language varchar2(255 char), shorttext varchar2(255 char), text clob, Task_Subjects_Id number(19,0), Task_Names_Id number(19,0), Task_Descriptions_Id number(19,0), Reassignment_Documentation_Id number(19,0), Notification_Subjects_Id number(19,0), Notification_Names_Id number(19,0), Notification_Documentation_Id number(19,0), Notification_Descriptions_Id number(19,0), Deadline_Documentation_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table NodeInstanceLog ( id number(19,0) not null, connection varchar2(255 char), log_date timestamp, externalid varchar2(255 char), nodeid varchar2(255 char), nodeinstanceid varchar2(255 char), nodename varchar2(255 char), nodetype varchar2(255 char), processid varchar2(255 char), processinstanceid number(19,0) not null, type number(10,0) not null, workitemid number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification ( DTYPE varchar2(31 char) not null, id number(19,0) not null, priority number(10,0) not null, Escalation_Notifications_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification_BAs ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification_Recipients ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification_email_header ( Notification_id number(19,0) not null, emailheaders_id number(19,0) not null, emailheaders_mapkey_key_mapkey varchar2(255 char) not null, primary key (Notification_id, emailheaders_mapkey_key_mapkey) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table OrganizationalEntity ( DTYPE varchar2(31 char) not null, id varchar2(255 char) not null, primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_BAs ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_ExclOwners ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_PotOwners ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_Recipients ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_Stakeholders ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ProcessInstanceInfo ( InstanceId number(19,0) not null, lastmodificationdate timestamp, lastreaddate timestamp, processid varchar2(255 char), processinstancebytearray blob, startdate timestamp, state number(10,0) not null, OPTLOCK number(10,0), primary key (InstanceId) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ProcessInstanceLog ( id number(19,0) not null, duration number(19,0), end_date timestamp, externalid varchar2(255 char), user_identity varchar2(255 char), outcome varchar2(255 char), parentprocessinstanceid number(19,0), processid varchar2(255 char), processinstanceid number(19,0) not null, processname varchar2(255 char), processversion varchar2(255 char), start_date timestamp, status number(10,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Reassignment ( id number(19,0) not null, Escalation_Reassignments_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Reassignment_potentialOwners ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table SessionInfo ( id number(10,0) not null, lastmodificationdate timestamp, rulesbytearray blob, startdate timestamp, OPTLOCK number(10,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Task ( id number(19,0) not null, archived number(5,0), delegation_allowedtodelegate varchar2(255 char), formname varchar2(255 char), priority number(10,0) not null, subtaskstrategy varchar2(255 char), taskdata_activationtime timestamp, taskdata_createdon timestamp, taskdata_deploymentid varchar2(255 char), taskdata_documentaccesstype number(10,0), taskdata_documentcontentid number(19,0) not null, taskdata_documenttype varchar2(255 char), taskdata_expirationtime timestamp, taskdata_faultaccesstype number(10,0), taskdata_faultcontentid number(19,0) not null, taskdata_faultname varchar2(255 char), taskdata_faulttype varchar2(255 char), taskdata_outputaccesstype number(10,0), taskdata_outputcontentid number(19,0) not null, taskdata_outputtype varchar2(255 char), taskdata_parentid number(19,0) not null, taskdata_previousstatus number(10,0), taskdata_processid varchar2(255 char), taskdata_processinstanceid number(19,0) not null, taskdata_processsessionid number(10,0) not null, taskdata_skipable number(1,0) not null, taskdata_status varchar2(255 char), taskdata_workitemid number(19,0) not null, tasktype varchar2(255 char), OPTLOCK number(10,0), peopl_assign_taskinitiator_id varchar2(255 char), taskdata_actualowner_id varchar2(255 char), taskdata_createdby_id varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table TaskEvent ( id number(19,0) not null, logtime timestamp, taskid number(19,0), type varchar2(255 char), userid varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table VariableInstanceLog ( id number(19,0) not null, log_date timestamp, externalid varchar2(255 char), oldvalue varchar2(255 char), processid varchar2(255 char), processinstanceid number(19,0) not null, value varchar2(255 char), variableid varchar2(255 char), variableinstanceid varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table WorkItemInfo ( workitemid number(19,0) not null, creationdate timestamp, name varchar2(255 char), processinstanceid number(19,0) not null, state number(19,0) not null, OPTLOCK number(10,0), workitembytearray blob, primary key (workitemid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table email_header ( id number(19,0) not null, body clob, fromAddress varchar2(255 char), language varchar2(255 char), replyToAddress varchar2(255 char), subject varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table task_comment ( id number(19,0) not null, addedat timestamp, text clob, addedby_id varchar2(255 char), TaskData_Comments_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table Attachment add constraint FK_9jaco4irrkskr5phh97x2fe9h foreign key (attachedby_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Attachment add constraint FK_hqupx569krp0f0sgu9kh87513 foreign key (TaskData_Attachments_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table BooleanExpression add constraint FK_394nf2qoc0k9ok6omgd6jtpso foreign key (Escalation_Constraints_Id) references Escalation'); end; > [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] SQL: begin execute_if_exists('alter table CorrelationPropertyInfo add constraint FK_1mgvtkn3h0bxu2fd657apkvxs foreign key (correlationkey_keyId) references CorrelationKeyInfo'); end; > [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] SQL: begin execute_if_exists('alter table Deadline add constraint FK_68w742sge00vco2cq3jhbvmgx foreign key (Deadlines_StartDeadLine_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Deadline add constraint FK_euoohoelbqvv94d8a8rcg8s5n foreign key (Deadlines_EndDeadLine_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Delegation_delegates add constraint FK_gn7ula51sk55wj1o1m57guqxb foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Delegation_delegates add constraint FK_fajq6kossbsqwr3opkrctxei3 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Escalation add constraint FK_ay2gd4fvl9yaapviyxudwuvfg foreign key (Deadline_Escalation_Id) references Deadline'); end; > [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] SQL: begin execute_if_exists('alter table EventTypes add constraint FK_nrecj4617iwxlc65ij6m7lsl1 foreign key (InstanceId) references ProcessInstanceInfo'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_k16jpgrh67ti9uedf6konsu1p foreign key (Task_Subjects_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_fd9uk6hemv2dx1ojovo7ms3vp foreign key (Task_Names_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_4eyfp69ucrron2hr7qx4np2fp foreign key (Task_Descriptions_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_pqarjvvnwfjpeyb87yd7m0bfi foreign key (Reassignment_Documentation_Id) references Reassignment'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_o84rkh69r47ti8uv4eyj7bmo2 foreign key (Notification_Subjects_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_g1trxri8w64enudw2t1qahhk5 foreign key (Notification_Names_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_qoce92c70adem3ccb3i7lec8x foreign key (Notification_Documentation_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_bw8vmpekejxt1ei2ge26gdsry foreign key (Notification_Descriptions_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_21qvifarxsvuxeaw5sxwh473w foreign key (Deadline_Documentation_Id) references Deadline'); end; > [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] SQL: begin execute_if_exists('alter table Notification add constraint FK_bdbeml3768go5im41cgfpyso9 foreign key (Escalation_Notifications_Id) references Escalation'); end; > [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] SQL: begin execute_if_exists('alter table Notification_BAs add constraint FK_mfbsnbrhth4rjhqc2ud338s4i foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Notification_BAs add constraint FK_fc0uuy76t2bvxaxqysoo8xts7 foreign key (task_id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table Notification_Recipients add constraint FK_blf9jsrumtrthdaqnpwxt25eu foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Notification_Recipients add constraint FK_3l244pj8sh78vtn9imaymrg47 foreign key (task_id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table Notification_email_header add constraint UK_25vn3oqfsiwwda26w9uiprrwe unique (emailheaders_id)'); end; > [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] SQL: begin execute_if_exists('alter table Notification_email_header add constraint FK_25vn3oqfsiwwda26w9uiprrwe foreign key (emailheaders_id) references email_header'); end; > [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] SQL: begin execute_if_exists('alter table Notification_email_header add constraint FK_eth4nvxn21fk1vnju85vkjrai foreign key (Notification_id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_BAs add constraint FK_t38xbkrq6cppifnxequhvjsl2 foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_BAs add constraint FK_omjg5qh7uv8e9bolbaq7hv6oh foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_ExclOwners add constraint FK_pth28a73rj6bxtlfc69kmqo0a foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_ExclOwners add constraint FK_b8owuxfrdng050ugpk0pdowa7 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_PotOwners add constraint FK_tee3ftir7xs6eo3fdvi3xw026 foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_PotOwners add constraint FK_4dv2oji7pr35ru0w45trix02x foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Recipients add constraint FK_4g7y3wx6gnokf6vycgpxs83d6 foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Recipients add constraint FK_enhk831fghf6akjilfn58okl4 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Stakeholders add constraint FK_met63inaep6cq4ofb3nnxi4tm foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Stakeholders add constraint FK_4bh3ay74x6ql9usunubttfdf1 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Reassignment add constraint FK_pnpeue9hs6kx2ep0sp16b6kfd foreign key (Escalation_Reassignments_Id) references Escalation'); end; > [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] SQL: begin execute_if_exists('alter table Reassignment_potentialOwners add constraint FK_8frl6la7tgparlnukhp8xmody foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Reassignment_potentialOwners add constraint FK_qbega5ncu6b9yigwlw55aeijn foreign key (task_id) references Reassignment'); end; > [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] SQL: begin execute_if_exists('alter table Task add constraint FK_7hos7h1ft5wygyru9vm2mtp6b foreign key (peopl_assign_taskinitiator_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Task add constraint FK_iu0slqdkjbb9mvikrns8mvqcg foreign key (taskdata_actualowner_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Task add constraint FK_tek6betmy2fl0bnwrsx9a4fi9 foreign key (taskdata_createdby_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table task_comment add constraint FK_fencp0rt8gae730n7621vqjre foreign key (addedby_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table task_comment add constraint FK_1ws9jdmhtey6mxu7jb0r0ufvs foreign key (TaskData_Comments_Id) references Task'); end; > [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] SQL: begin execute_if_not_exists('create sequence ATTACHMENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence BAM_TASK_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence BOOLEANEXPR_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence COMMENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CONTENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CONTEXT_MAPPING_INFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CORRELATION_KEY_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CORRELATION_PROP_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence DEADLINE_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence EMAILNOTIFHEAD_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence ESCALATION_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence I18NTEXT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence NODE_INST_LOG_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence NOTIFICATION_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence PROCESS_INSTANCE_INFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence PROC_INST_LOG_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence REASSIGNMENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence SESSIONINFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence TASK_EVENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence TASK_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence VAR_INST_LOG_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence WORKITEMINFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] 56 of 101 SQL statements executed successfully > >riftsaw-ode.check: >[available] Found directory: riftsaw-ode > >riftsaw-ode: > [sql] connecting to jdbc:oracle:thin:@jawa06.mw.lab.eng.brq.redhat.com:1521:soaesb1 > [sql] Loading oracle.jdbc.OracleDriver using a cached AntClassLoader. > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/riftsaw-ode/riftsaw-dao-jpa-hibernate.ode-unit-test-embedded.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table BPEL_ACTIVITY_RECOVERY ( ID number(19,0) not null, ACTIONS varchar2(255 char), ACTIVITY_ID number(19,0), CHANNEL varchar2(255 char), DATE_TIME timestamp, DETAILS clob, INSTANCE_ID number(19,0), REASON varchar2(255 char), RETRIES number(10,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATION_SET ( CORRELATION_SET_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (CORRELATION_SET_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATOR ( CORRELATOR_ID number(19,0) not null, CORRELATOR_KEY varchar2(255 char), PROC_ID number(19,0), primary key (CORRELATOR_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORSET_PROP ( ID number(19,0) not null, CORRSET_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_EVENT ( EVENT_ID number(19,0) not null, DETAIL varchar2(255 char), DATA blob, SCOPE_ID number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), INSTANCE_ID number(19,0), PROCESS_ID number(19,0), primary key (EVENT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_FAULT ( FAULT_ID number(19,0) not null, ACTIVITY_ID number(10,0), DATA clob, MESSAGE clob, LINE_NUMBER number(10,0), NAME varchar2(255 char), primary key (FAULT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE ( MESSAGE_ID number(19,0) not null, DATA clob, HEADER clob, TYPE varchar2(255 char), MESSAGE_EXCHANGE_ID varchar2(255 char), primary key (MESSAGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_EXCHANGE ( MESSAGE_EXCHANGE_ID varchar2(255 char) not null, CALLEE varchar2(255 char), CHANNEL varchar2(255 char), CORRELATION_ID varchar2(255 char), CORRELATION_KEYS varchar2(255 char), CORRELATION_STATUS varchar2(255 char), CREATE_TIME timestamp, DIRECTION char(1 char), EPR clob, FAULT varchar2(255 char), FAULT_EXPLANATION varchar2(255 char), OPERATION varchar2(255 char), PARTNER_LINK_MODEL_ID number(10,0), PATTERN varchar2(255 char), PIPED_ID varchar2(255 char), PORT_TYPE varchar2(255 char), PROPAGATE_TRANS number(1,0), STATUS varchar2(255 char), SUBSCRIBER_COUNT number(10,0), CORR_ID number(19,0), PARTNER_LINK_ID number(19,0), PROCESS_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), REQUEST_MESSAGE_ID number(19,0), RESPONSE_MESSAGE_ID number(19,0), primary key (MESSAGE_EXCHANGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_ROUTE ( MESSAGE_ROUTE_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), GROUP_ID varchar2(255 char), ROUTE_INDEX number(10,0), PROCESS_INSTANCE_ID number(19,0), ROUTE_POLICY varchar2(16 char), CORR_ID number(19,0), primary key (MESSAGE_ROUTE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MEX_PROP ( ID number(19,0) not null, MEX_ID varchar2(255 char), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(2000 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PARTNER_LINK ( PARTNER_LINK_ID number(19,0) not null, MY_EPR clob, MY_ROLE_NAME varchar2(255 char), MY_ROLE_SERVICE_NAME varchar2(255 char), MY_SESSION_ID varchar2(255 char), PARTNER_EPR clob, PARTNER_LINK_MODEL_ID number(10,0), PARTNER_LINK_NAME varchar2(255 char), PARTNER_ROLE_NAME varchar2(255 char), PARTNER_SESSION_ID varchar2(255 char), SCOPE_ID number(19,0), primary key (PARTNER_LINK_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS ( ID number(19,0) not null, GUID varchar2(255 char), PROCESS_ID varchar2(255 char), PROCESS_TYPE varchar2(255 char), VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS_INSTANCE ( ID number(19,0) not null, DATE_CREATED timestamp, EXECUTION_STATE blob, FAULT_ID number(19,0), LAST_ACTIVE_TIME timestamp, LAST_RECOVERY_DATE timestamp, PREVIOUS_STATE number(5,0), SEQUENCE number(19,0), INSTANCE_STATE number(5,0), INSTANTIATING_CORRELATOR_ID number(19,0), PROCESS_ID number(19,0), ROOT_SCOPE_ID number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_SCOPE ( SCOPE_ID number(19,0) not null, MODEL_ID number(10,0), SCOPE_NAME varchar2(255 char), SCOPE_STATE varchar2(255 char), PARENT_SCOPE_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), primary key (SCOPE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA ( XML_DATA_ID number(19,0) not null, DATA clob, IS_SIMPLE_TYPE number(1,0), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (XML_DATA_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA_PROP ( ID number(19,0) not null, XML_DATA_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ODE_JOB ( jobid varchar2(64 char) not null, channel varchar2(255 char), correlationKeySet varchar2(255 char), correlatorId varchar2(255 char), detailsExt blob, inMem number(1,0), instanceId number(19,0), mexId varchar2(255 char), nodeid varchar2(64 char), processId varchar2(255 char), retryCount number(10,0), scheduled number(1,0) not null, ts number(19,0) not null, transacted number(1,0) not null, type varchar2(255 char), primary key (jobid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_DU ( NAME varchar2(255 char) not null, DEPLOYDT timestamp, DEPLOYER varchar2(255 char), DIR varchar2(255 char), primary key (NAME) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS ( PID varchar2(255 char) not null, STATE varchar2(255 char), TYPE varchar2(255 char), VERSION number(19,0), DU varchar2(255 char), primary key (PID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS_PROP ( ID number(19,0) not null, PROP_KEY varchar2(255 char), PROP_VAL varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROC_TO_PROP ( STORE_PROCESS_PID varchar2(255 char) not null, STORE_PROPERTY_ID number(19,0) not null, primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_VERSIONS ( ID number(19,0) not null, VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table BPEL_ACTIVITY_RECOVERY add constraint FK_5iwucbr1yngxjs16sxeej3xpp foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATION_SET add constraint FK_j1vdkxghmf62wsykum7ut0mjp foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATOR add constraint FK_6sqr3hmuqssl6v7en9extt6nb foreign key (PROC_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORSET_PROP add constraint FK_6vmj2n3pf8el6xupevpjpw0q5 foreign key (CORRSET_ID) references BPEL_CORRELATION_SET'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_on6qt1pmhmhq302bvn0afqrib foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_3i4chalwvtcsxnb3kitlk008i foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE add constraint FK_t7okesqhwuldkv1hh6gbqf2ou foreign key (MESSAGE_EXCHANGE_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_h7khyrytsirwd8wab4u46m2n8 foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_uonx6oawfknxho8jrf3rfk5c foreign key (PARTNER_LINK_ID) references BPEL_PARTNER_LINK'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_gb2u3yldxdoo1cwm0r4ueumks foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_c7spgx5vfvekg032033rpqdbk foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_fxmbqc9xnjklj0k4bn1e2l34x foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MEX_PROP add constraint FK_4hprt848lqhnc8pjdxhslqy53 foreign key (MEX_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PARTNER_LINK add constraint FK_n42xwpib34r1o4j3gum2o7teo foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_cbaftcdg3olwu6c1hb9uiysh8 foreign key (INSTANTIATING_CORRELATOR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_s6umxoyr597vbkk95ff9uwx8 foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_SCOPE add constraint FK_nuormejxj2iyfxm4yny8g2msh foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_XML_DATA add constraint FK_g0pgad8e5x63j502w4ps9ysnh foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROCESS add constraint FK_c8haf42aukvqr2udrtpyi3kdb foreign key (DU) references STORE_DU'); end; > [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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint UK_ld9y5wtckspqw9us9gfeokf6a unique (STORE_PROPERTY_ID)'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_t19b3gjvbvqke3hh5mcdr2dwl foreign key (STORE_PROCESS_PID) references STORE_PROCESS'); end; > [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] SQL: begin execute_if_not_exists('create sequence bpel_sequence'); end; > [sql] 0 rows affected > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/riftsaw-ode/riftsaw-dao-jpa.ode-bpel.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table BPAF_EVENT ( EID number(19,0) not null, ACTIVITY_DEFINITION_ID varchar2(255 char), ACTIVITY_INSTANCE_ID varchar2(255 char), ACTIVITY_NAME varchar2(255 char), CURRENT_STATE varchar2(255 char), PREVIOUS_STATE varchar2(255 char), PROCESS_DEFINITION_ID varchar2(255 char), PROCESS_INSTANCE_ID varchar2(255 char), PROCESS_NAME varchar2(255 char), SERVER_ID varchar2(255 char), TIMESTAMP number(19,0), primary key (EID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPAF_EVENT_DATA ( TID number(19,0) not null, NAME varchar2(255 char), VALUE clob, EVENT_ID number(19,0), primary key (TID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_ACTIVITY_RECOVERY ( ID number(19,0) not null, ACTIONS varchar2(255 char), ACTIVITY_ID number(19,0), CHANNEL varchar2(255 char), DATE_TIME timestamp, DETAILS clob, INSTANCE_ID number(19,0), REASON varchar2(255 char), RETRIES number(10,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATION_SET ( CORRELATION_SET_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (CORRELATION_SET_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATOR ( CORRELATOR_ID number(19,0) not null, CORRELATOR_KEY varchar2(255 char), PROC_ID number(19,0), primary key (CORRELATOR_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORSET_PROP ( ID number(19,0) not null, CORRSET_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_EVENT ( EVENT_ID number(19,0) not null, DETAIL varchar2(255 char), DATA blob, SCOPE_ID number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), INSTANCE_ID number(19,0), PROCESS_ID number(19,0), primary key (EVENT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_FAULT ( FAULT_ID number(19,0) not null, ACTIVITY_ID number(10,0), DATA clob, MESSAGE clob, LINE_NUMBER number(10,0), NAME varchar2(255 char), primary key (FAULT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE ( MESSAGE_ID number(19,0) not null, DATA clob, HEADER clob, TYPE varchar2(255 char), MESSAGE_EXCHANGE_ID varchar2(255 char), primary key (MESSAGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_EXCHANGE ( MESSAGE_EXCHANGE_ID varchar2(255 char) not null, CALLEE varchar2(255 char), CHANNEL varchar2(255 char), CORRELATION_ID varchar2(255 char), CORRELATION_KEYS varchar2(255 char), CORRELATION_STATUS varchar2(255 char), CREATE_TIME timestamp, DIRECTION char(1 char), EPR clob, FAULT varchar2(255 char), FAULT_EXPLANATION varchar2(255 char), OPERATION varchar2(255 char), PARTNER_LINK_MODEL_ID number(10,0), PATTERN varchar2(255 char), PIPED_ID varchar2(255 char), PORT_TYPE varchar2(255 char), PROPAGATE_TRANS number(1,0), STATUS varchar2(255 char), SUBSCRIBER_COUNT number(10,0), CORR_ID number(19,0), PARTNER_LINK_ID number(19,0), PROCESS_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), REQUEST_MESSAGE_ID number(19,0), RESPONSE_MESSAGE_ID number(19,0), primary key (MESSAGE_EXCHANGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_ROUTE ( MESSAGE_ROUTE_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), GROUP_ID varchar2(255 char), ROUTE_INDEX number(10,0), PROCESS_INSTANCE_ID number(19,0), ROUTE_POLICY varchar2(16 char), CORR_ID number(19,0), primary key (MESSAGE_ROUTE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MEX_PROP ( ID number(19,0) not null, MEX_ID varchar2(255 char), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(2000 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PARTNER_LINK ( PARTNER_LINK_ID number(19,0) not null, MY_EPR clob, MY_ROLE_NAME varchar2(255 char), MY_ROLE_SERVICE_NAME varchar2(255 char), MY_SESSION_ID varchar2(255 char), PARTNER_EPR clob, PARTNER_LINK_MODEL_ID number(10,0), PARTNER_LINK_NAME varchar2(255 char), PARTNER_ROLE_NAME varchar2(255 char), PARTNER_SESSION_ID varchar2(255 char), SCOPE_ID number(19,0), primary key (PARTNER_LINK_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS ( ID number(19,0) not null, GUID varchar2(255 char), PROCESS_ID varchar2(255 char), PROCESS_TYPE varchar2(255 char), VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS_INSTANCE ( ID number(19,0) not null, DATE_CREATED timestamp, EXECUTION_STATE blob, FAULT_ID number(19,0), LAST_ACTIVE_TIME timestamp, LAST_RECOVERY_DATE timestamp, PREVIOUS_STATE number(5,0), SEQUENCE number(19,0), INSTANCE_STATE number(5,0), INSTANTIATING_CORRELATOR_ID number(19,0), PROCESS_ID number(19,0), ROOT_SCOPE_ID number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_SCOPE ( SCOPE_ID number(19,0) not null, MODEL_ID number(10,0), SCOPE_NAME varchar2(255 char), SCOPE_STATE varchar2(255 char), PARENT_SCOPE_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), primary key (SCOPE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA ( XML_DATA_ID number(19,0) not null, DATA clob, IS_SIMPLE_TYPE number(1,0), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (XML_DATA_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA_PROP ( ID number(19,0) not null, XML_DATA_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ODE_JOB ( jobid varchar2(64 char) not null, channel varchar2(255 char), correlationKeySet varchar2(255 char), correlatorId varchar2(255 char), detailsExt blob, inMem number(1,0), instanceId number(19,0), mexId varchar2(255 char), nodeid varchar2(64 char), processId varchar2(255 char), retryCount number(10,0), scheduled number(1,0) not null, ts number(19,0) not null, transacted number(1,0) not null, type varchar2(255 char), primary key (jobid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_DU ( NAME varchar2(255 char) not null, DEPLOYDT timestamp, DEPLOYER varchar2(255 char), DIR varchar2(255 char), primary key (NAME) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS ( PID varchar2(255 char) not null, STATE varchar2(255 char), TYPE varchar2(255 char), VERSION number(19,0), DU varchar2(255 char), primary key (PID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS_PROP ( ID number(19,0) not null, PROP_KEY varchar2(255 char), PROP_VAL varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROC_TO_PROP ( STORE_PROCESS_PID varchar2(255 char) not null, STORE_PROPERTY_ID number(19,0) not null, primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_VERSIONS ( ID number(19,0) not null, VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table BPAF_EVENT_DATA add constraint FK_5dx9wlbxkeho97gui4la0vjye foreign key (EVENT_ID) references BPAF_EVENT'); end; > [sql] Failed to execute: begin execute_if_exists('alter table BPAF_EVENT_DATA add constraint FK_5dx9wlbxkeho97gui4la0vjye foreign key (EVENT_ID) references BPAF_EVENT'); 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] SQL: begin execute_if_exists('alter table BPEL_ACTIVITY_RECOVERY add constraint FK_5iwucbr1yngxjs16sxeej3xpp foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATION_SET add constraint FK_j1vdkxghmf62wsykum7ut0mjp foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATOR add constraint FK_6sqr3hmuqssl6v7en9extt6nb foreign key (PROC_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORSET_PROP add constraint FK_6vmj2n3pf8el6xupevpjpw0q5 foreign key (CORRSET_ID) references BPEL_CORRELATION_SET'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_on6qt1pmhmhq302bvn0afqrib foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_3i4chalwvtcsxnb3kitlk008i foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE add constraint FK_t7okesqhwuldkv1hh6gbqf2ou foreign key (MESSAGE_EXCHANGE_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_h7khyrytsirwd8wab4u46m2n8 foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_uonx6oawfknxho8jrf3rfk5c foreign key (PARTNER_LINK_ID) references BPEL_PARTNER_LINK'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_gb2u3yldxdoo1cwm0r4ueumks foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_c7spgx5vfvekg032033rpqdbk foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_fxmbqc9xnjklj0k4bn1e2l34x foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MEX_PROP add constraint FK_4hprt848lqhnc8pjdxhslqy53 foreign key (MEX_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PARTNER_LINK add constraint FK_n42xwpib34r1o4j3gum2o7teo foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_cbaftcdg3olwu6c1hb9uiysh8 foreign key (INSTANTIATING_CORRELATOR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_s6umxoyr597vbkk95ff9uwx8 foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_SCOPE add constraint FK_nuormejxj2iyfxm4yny8g2msh foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_XML_DATA add constraint FK_g0pgad8e5x63j502w4ps9ysnh foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROCESS add constraint FK_c8haf42aukvqr2udrtpyi3kdb foreign key (DU) references STORE_DU'); end; > [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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint UK_ld9y5wtckspqw9us9gfeokf6a unique (STORE_PROPERTY_ID)'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_t19b3gjvbvqke3hh5mcdr2dwl foreign key (STORE_PROCESS_PID) references STORE_PROCESS'); end; > [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] SQL: begin execute_if_not_exists('create sequence hibernate_sequence'); end; > [sql] 0 rows affected > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/riftsaw-ode/riftsaw-dao-jpa.ode-scheduler.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table BPEL_ACTIVITY_RECOVERY ( ID number(19,0) not null, ACTIONS varchar2(255 char), ACTIVITY_ID number(19,0), CHANNEL varchar2(255 char), DATE_TIME timestamp, DETAILS clob, INSTANCE_ID number(19,0), REASON varchar2(255 char), RETRIES number(10,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATION_SET ( CORRELATION_SET_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (CORRELATION_SET_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATOR ( CORRELATOR_ID number(19,0) not null, CORRELATOR_KEY varchar2(255 char), PROC_ID number(19,0), primary key (CORRELATOR_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORSET_PROP ( ID number(19,0) not null, CORRSET_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_EVENT ( EVENT_ID number(19,0) not null, DETAIL varchar2(255 char), DATA blob, SCOPE_ID number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), INSTANCE_ID number(19,0), PROCESS_ID number(19,0), primary key (EVENT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_FAULT ( FAULT_ID number(19,0) not null, ACTIVITY_ID number(10,0), DATA clob, MESSAGE clob, LINE_NUMBER number(10,0), NAME varchar2(255 char), primary key (FAULT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE ( MESSAGE_ID number(19,0) not null, DATA clob, HEADER clob, TYPE varchar2(255 char), MESSAGE_EXCHANGE_ID varchar2(255 char), primary key (MESSAGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_EXCHANGE ( MESSAGE_EXCHANGE_ID varchar2(255 char) not null, CALLEE varchar2(255 char), CHANNEL varchar2(255 char), CORRELATION_ID varchar2(255 char), CORRELATION_KEYS varchar2(255 char), CORRELATION_STATUS varchar2(255 char), CREATE_TIME timestamp, DIRECTION char(1 char), EPR clob, FAULT varchar2(255 char), FAULT_EXPLANATION varchar2(255 char), OPERATION varchar2(255 char), PARTNER_LINK_MODEL_ID number(10,0), PATTERN varchar2(255 char), PIPED_ID varchar2(255 char), PORT_TYPE varchar2(255 char), PROPAGATE_TRANS number(1,0), STATUS varchar2(255 char), SUBSCRIBER_COUNT number(10,0), CORR_ID number(19,0), PARTNER_LINK_ID number(19,0), PROCESS_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), REQUEST_MESSAGE_ID number(19,0), RESPONSE_MESSAGE_ID number(19,0), primary key (MESSAGE_EXCHANGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_ROUTE ( MESSAGE_ROUTE_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), GROUP_ID varchar2(255 char), ROUTE_INDEX number(10,0), PROCESS_INSTANCE_ID number(19,0), ROUTE_POLICY varchar2(16 char), CORR_ID number(19,0), primary key (MESSAGE_ROUTE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MEX_PROP ( ID number(19,0) not null, MEX_ID varchar2(255 char), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(2000 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PARTNER_LINK ( PARTNER_LINK_ID number(19,0) not null, MY_EPR clob, MY_ROLE_NAME varchar2(255 char), MY_ROLE_SERVICE_NAME varchar2(255 char), MY_SESSION_ID varchar2(255 char), PARTNER_EPR clob, PARTNER_LINK_MODEL_ID number(10,0), PARTNER_LINK_NAME varchar2(255 char), PARTNER_ROLE_NAME varchar2(255 char), PARTNER_SESSION_ID varchar2(255 char), SCOPE_ID number(19,0), primary key (PARTNER_LINK_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS ( ID number(19,0) not null, GUID varchar2(255 char), PROCESS_ID varchar2(255 char), PROCESS_TYPE varchar2(255 char), VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS_INSTANCE ( ID number(19,0) not null, DATE_CREATED timestamp, EXECUTION_STATE blob, FAULT_ID number(19,0), LAST_ACTIVE_TIME timestamp, LAST_RECOVERY_DATE timestamp, PREVIOUS_STATE number(5,0), SEQUENCE number(19,0), INSTANCE_STATE number(5,0), INSTANTIATING_CORRELATOR_ID number(19,0), PROCESS_ID number(19,0), ROOT_SCOPE_ID number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_SCOPE ( SCOPE_ID number(19,0) not null, MODEL_ID number(10,0), SCOPE_NAME varchar2(255 char), SCOPE_STATE varchar2(255 char), PARENT_SCOPE_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), primary key (SCOPE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA ( XML_DATA_ID number(19,0) not null, DATA clob, IS_SIMPLE_TYPE number(1,0), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (XML_DATA_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA_PROP ( ID number(19,0) not null, XML_DATA_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ODE_JOB ( jobid varchar2(64 char) not null, channel varchar2(255 char), correlationKeySet varchar2(255 char), correlatorId varchar2(255 char), detailsExt blob, inMem number(1,0), instanceId number(19,0), mexId varchar2(255 char), nodeid varchar2(64 char), processId varchar2(255 char), retryCount number(10,0), scheduled number(1,0) not null, ts number(19,0) not null, transacted number(1,0) not null, type varchar2(255 char), primary key (jobid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_DU ( NAME varchar2(255 char) not null, DEPLOYDT timestamp, DEPLOYER varchar2(255 char), DIR varchar2(255 char), primary key (NAME) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS ( PID varchar2(255 char) not null, STATE varchar2(255 char), TYPE varchar2(255 char), VERSION number(19,0), DU varchar2(255 char), primary key (PID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS_PROP ( ID number(19,0) not null, PROP_KEY varchar2(255 char), PROP_VAL varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROC_TO_PROP ( STORE_PROCESS_PID varchar2(255 char) not null, STORE_PROPERTY_ID number(19,0) not null, primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_VERSIONS ( ID number(19,0) not null, VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table BPEL_ACTIVITY_RECOVERY add constraint FK_5iwucbr1yngxjs16sxeej3xpp foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATION_SET add constraint FK_j1vdkxghmf62wsykum7ut0mjp foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATOR add constraint FK_6sqr3hmuqssl6v7en9extt6nb foreign key (PROC_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORSET_PROP add constraint FK_6vmj2n3pf8el6xupevpjpw0q5 foreign key (CORRSET_ID) references BPEL_CORRELATION_SET'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_on6qt1pmhmhq302bvn0afqrib foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_3i4chalwvtcsxnb3kitlk008i foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE add constraint FK_t7okesqhwuldkv1hh6gbqf2ou foreign key (MESSAGE_EXCHANGE_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_h7khyrytsirwd8wab4u46m2n8 foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_uonx6oawfknxho8jrf3rfk5c foreign key (PARTNER_LINK_ID) references BPEL_PARTNER_LINK'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_gb2u3yldxdoo1cwm0r4ueumks foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_c7spgx5vfvekg032033rpqdbk foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_fxmbqc9xnjklj0k4bn1e2l34x foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MEX_PROP add constraint FK_4hprt848lqhnc8pjdxhslqy53 foreign key (MEX_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PARTNER_LINK add constraint FK_n42xwpib34r1o4j3gum2o7teo foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_cbaftcdg3olwu6c1hb9uiysh8 foreign key (INSTANTIATING_CORRELATOR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_s6umxoyr597vbkk95ff9uwx8 foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_SCOPE add constraint FK_nuormejxj2iyfxm4yny8g2msh foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_XML_DATA add constraint FK_g0pgad8e5x63j502w4ps9ysnh foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROCESS add constraint FK_c8haf42aukvqr2udrtpyi3kdb foreign key (DU) references STORE_DU'); end; > [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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint UK_ld9y5wtckspqw9us9gfeokf6a unique (STORE_PROPERTY_ID)'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_t19b3gjvbvqke3hh5mcdr2dwl foreign key (STORE_PROCESS_PID) references STORE_PROCESS'); end; > [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] SQL: begin execute_if_not_exists('create sequence hibernate_sequence'); end; > [sql] 0 rows affected > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/riftsaw-ode/riftsaw-dao-jpa.ode-store.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table BPEL_ACTIVITY_RECOVERY ( ID number(19,0) not null, ACTIONS varchar2(255 char), ACTIVITY_ID number(19,0), CHANNEL varchar2(255 char), DATE_TIME timestamp, DETAILS clob, INSTANCE_ID number(19,0), REASON varchar2(255 char), RETRIES number(10,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATION_SET ( CORRELATION_SET_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (CORRELATION_SET_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORRELATOR ( CORRELATOR_ID number(19,0) not null, CORRELATOR_KEY varchar2(255 char), PROC_ID number(19,0), primary key (CORRELATOR_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_CORSET_PROP ( ID number(19,0) not null, CORRSET_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_EVENT ( EVENT_ID number(19,0) not null, DETAIL varchar2(255 char), DATA blob, SCOPE_ID number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), INSTANCE_ID number(19,0), PROCESS_ID number(19,0), primary key (EVENT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_FAULT ( FAULT_ID number(19,0) not null, ACTIVITY_ID number(10,0), DATA clob, MESSAGE clob, LINE_NUMBER number(10,0), NAME varchar2(255 char), primary key (FAULT_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE ( MESSAGE_ID number(19,0) not null, DATA clob, HEADER clob, TYPE varchar2(255 char), MESSAGE_EXCHANGE_ID varchar2(255 char), primary key (MESSAGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_EXCHANGE ( MESSAGE_EXCHANGE_ID varchar2(255 char) not null, CALLEE varchar2(255 char), CHANNEL varchar2(255 char), CORRELATION_ID varchar2(255 char), CORRELATION_KEYS varchar2(255 char), CORRELATION_STATUS varchar2(255 char), CREATE_TIME timestamp, DIRECTION char(1 char), EPR clob, FAULT varchar2(255 char), FAULT_EXPLANATION varchar2(255 char), OPERATION varchar2(255 char), PARTNER_LINK_MODEL_ID number(10,0), PATTERN varchar2(255 char), PIPED_ID varchar2(255 char), PORT_TYPE varchar2(255 char), PROPAGATE_TRANS number(1,0), STATUS varchar2(255 char), SUBSCRIBER_COUNT number(10,0), CORR_ID number(19,0), PARTNER_LINK_ID number(19,0), PROCESS_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), REQUEST_MESSAGE_ID number(19,0), RESPONSE_MESSAGE_ID number(19,0), primary key (MESSAGE_EXCHANGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MESSAGE_ROUTE ( MESSAGE_ROUTE_ID number(19,0) not null, CORRELATION_KEY varchar2(255 char), GROUP_ID varchar2(255 char), ROUTE_INDEX number(10,0), PROCESS_INSTANCE_ID number(19,0), ROUTE_POLICY varchar2(16 char), CORR_ID number(19,0), primary key (MESSAGE_ROUTE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_MEX_PROP ( ID number(19,0) not null, MEX_ID varchar2(255 char), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(2000 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PARTNER_LINK ( PARTNER_LINK_ID number(19,0) not null, MY_EPR clob, MY_ROLE_NAME varchar2(255 char), MY_ROLE_SERVICE_NAME varchar2(255 char), MY_SESSION_ID varchar2(255 char), PARTNER_EPR clob, PARTNER_LINK_MODEL_ID number(10,0), PARTNER_LINK_NAME varchar2(255 char), PARTNER_ROLE_NAME varchar2(255 char), PARTNER_SESSION_ID varchar2(255 char), SCOPE_ID number(19,0), primary key (PARTNER_LINK_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS ( ID number(19,0) not null, GUID varchar2(255 char), PROCESS_ID varchar2(255 char), PROCESS_TYPE varchar2(255 char), VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_PROCESS_INSTANCE ( ID number(19,0) not null, DATE_CREATED timestamp, EXECUTION_STATE blob, FAULT_ID number(19,0), LAST_ACTIVE_TIME timestamp, LAST_RECOVERY_DATE timestamp, PREVIOUS_STATE number(5,0), SEQUENCE number(19,0), INSTANCE_STATE number(5,0), INSTANTIATING_CORRELATOR_ID number(19,0), PROCESS_ID number(19,0), ROOT_SCOPE_ID number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_SCOPE ( SCOPE_ID number(19,0) not null, MODEL_ID number(10,0), SCOPE_NAME varchar2(255 char), SCOPE_STATE varchar2(255 char), PARENT_SCOPE_ID number(19,0), PROCESS_INSTANCE_ID number(19,0), primary key (SCOPE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA ( XML_DATA_ID number(19,0) not null, DATA clob, IS_SIMPLE_TYPE number(1,0), NAME varchar2(255 char), SCOPE_ID number(19,0), primary key (XML_DATA_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BPEL_XML_DATA_PROP ( ID number(19,0) not null, XML_DATA_ID number(19,0), PROP_KEY varchar2(255 char), PROP_VALUE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ODE_JOB ( jobid varchar2(64 char) not null, channel varchar2(255 char), correlationKeySet varchar2(255 char), correlatorId varchar2(255 char), detailsExt blob, inMem number(1,0), instanceId number(19,0), mexId varchar2(255 char), nodeid varchar2(64 char), processId varchar2(255 char), retryCount number(10,0), scheduled number(1,0) not null, ts number(19,0) not null, transacted number(1,0) not null, type varchar2(255 char), primary key (jobid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_DU ( NAME varchar2(255 char) not null, DEPLOYDT timestamp, DEPLOYER varchar2(255 char), DIR varchar2(255 char), primary key (NAME) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS ( PID varchar2(255 char) not null, STATE varchar2(255 char), TYPE varchar2(255 char), VERSION number(19,0), DU varchar2(255 char), primary key (PID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROCESS_PROP ( ID number(19,0) not null, PROP_KEY varchar2(255 char), PROP_VAL varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_PROC_TO_PROP ( STORE_PROCESS_PID varchar2(255 char) not null, STORE_PROPERTY_ID number(19,0) not null, primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table STORE_VERSIONS ( ID number(19,0) not null, VERSION number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table BPEL_ACTIVITY_RECOVERY add constraint FK_5iwucbr1yngxjs16sxeej3xpp foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATION_SET add constraint FK_j1vdkxghmf62wsykum7ut0mjp foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORRELATOR add constraint FK_6sqr3hmuqssl6v7en9extt6nb foreign key (PROC_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_CORSET_PROP add constraint FK_6vmj2n3pf8el6xupevpjpw0q5 foreign key (CORRSET_ID) references BPEL_CORRELATION_SET'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_on6qt1pmhmhq302bvn0afqrib foreign key (INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_EVENT add constraint FK_3i4chalwvtcsxnb3kitlk008i foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE add constraint FK_t7okesqhwuldkv1hh6gbqf2ou foreign key (MESSAGE_EXCHANGE_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_h7khyrytsirwd8wab4u46m2n8 foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_uonx6oawfknxho8jrf3rfk5c foreign key (PARTNER_LINK_ID) references BPEL_PARTNER_LINK'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_EXCHANGE add constraint FK_gb2u3yldxdoo1cwm0r4ueumks foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_c7spgx5vfvekg032033rpqdbk foreign key (CORR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MESSAGE_ROUTE add constraint FK_fxmbqc9xnjklj0k4bn1e2l34x foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_MEX_PROP add constraint FK_4hprt848lqhnc8pjdxhslqy53 foreign key (MEX_ID) references BPEL_MESSAGE_EXCHANGE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PARTNER_LINK add constraint FK_n42xwpib34r1o4j3gum2o7teo foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_cbaftcdg3olwu6c1hb9uiysh8 foreign key (INSTANTIATING_CORRELATOR_ID) references BPEL_CORRELATOR'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_PROCESS_INSTANCE add constraint FK_s6umxoyr597vbkk95ff9uwx8 foreign key (PROCESS_ID) references BPEL_PROCESS'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_SCOPE add constraint FK_nuormejxj2iyfxm4yny8g2msh foreign key (PROCESS_INSTANCE_ID) references BPEL_PROCESS_INSTANCE'); end; > [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] SQL: begin execute_if_exists('alter table BPEL_XML_DATA add constraint FK_g0pgad8e5x63j502w4ps9ysnh foreign key (SCOPE_ID) references BPEL_SCOPE'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROCESS add constraint FK_c8haf42aukvqr2udrtpyi3kdb foreign key (DU) references STORE_DU'); end; > [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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint UK_ld9y5wtckspqw9us9gfeokf6a unique (STORE_PROPERTY_ID)'); end; > [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] SQL: 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] 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] SQL: begin execute_if_exists('alter table STORE_PROC_TO_PROP add constraint FK_t19b3gjvbvqke3hh5mcdr2dwl foreign key (STORE_PROCESS_PID) references STORE_PROCESS'); end; > [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] SQL: begin execute_if_not_exists('create sequence hibernate_sequence'); end; > [sql] 0 rows affected > [sql] 94 of 187 SQL statements executed successfully > >jbpm.check: >[available] Found directory: jbpm > >jbpm: > [sql] connecting to jdbc:oracle:thin:@jawa06.mw.lab.eng.brq.redhat.com:1521:soaesb1 > [sql] Loading oracle.jdbc.OracleDriver using a cached AntClassLoader. > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/jbpm/jbpm-test.org.jbpm.persistence.jpa.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table Attachment ( id number(19,0) not null, accesstype number(10,0), attachedat timestamp, attachmentcontentid number(19,0) not null, contenttype varchar2(255 char), name varchar2(255 char), attachment_size number(10,0), attachedby_id varchar2(255 char), TaskData_Attachments_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BAMTaskSummary ( pk number(19,0) not null, createddate timestamp, duration number(19,0), enddate timestamp, processinstanceid number(19,0) not null, startdate timestamp, status varchar2(255 char), taskid number(19,0) not null, taskname varchar2(255 char), userid varchar2(255 char), primary key (pk) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table BooleanExpression ( id number(19,0) not null, expression clob, type varchar2(255 char), Escalation_Constraints_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Content ( id number(19,0) not null, content blob, primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ContextMappingInfo ( mappingid number(19,0) not null, CONTEXT_ID varchar2(255 char) not null, KSESSION_ID number(10,0) not null, OPTLOCK number(10,0), primary key (mappingid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table CorrelationKeyInfo ( keyId number(19,0) not null, name varchar2(255 char), processinstanceid number(19,0) not null, OPTLOCK number(10,0), primary key (keyId) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table CorrelationPropertyInfo ( propertyId number(19,0) not null, name varchar2(255 char), value varchar2(255 char), OPTLOCK number(10,0), correlationkey_keyId number(19,0), primary key (propertyId) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Deadline ( id number(19,0) not null, deadline_date timestamp, escalated number(5,0), Deadlines_StartDeadLine_Id number(19,0), Deadlines_EndDeadLine_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Delegation_delegates ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Escalation ( id number(19,0) not null, name varchar2(255 char), Deadline_Escalation_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table EventTypes ( InstanceId number(19,0) not null, element varchar2(255 char) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table I18NText ( id number(19,0) not null, language varchar2(255 char), shorttext varchar2(255 char), text clob, Task_Subjects_Id number(19,0), Task_Names_Id number(19,0), Task_Descriptions_Id number(19,0), Reassignment_Documentation_Id number(19,0), Notification_Subjects_Id number(19,0), Notification_Names_Id number(19,0), Notification_Documentation_Id number(19,0), Notification_Descriptions_Id number(19,0), Deadline_Documentation_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table NodeInstanceLog ( id number(19,0) not null, connection varchar2(255 char), log_date timestamp, externalid varchar2(255 char), nodeid varchar2(255 char), nodeinstanceid varchar2(255 char), nodename varchar2(255 char), nodetype varchar2(255 char), processid varchar2(255 char), processinstanceid number(19,0) not null, type number(10,0) not null, workitemid number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification ( DTYPE varchar2(31 char) not null, id number(19,0) not null, priority number(10,0) not null, Escalation_Notifications_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification_BAs ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification_Recipients ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Notification_email_header ( Notification_id number(19,0) not null, emailheaders_id number(19,0) not null, emailheaders_mapkey_key_mapkey varchar2(255 char) not null, primary key (Notification_id, emailheaders_mapkey_key_mapkey) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table OrganizationalEntity ( DTYPE varchar2(31 char) not null, id varchar2(255 char) not null, primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_BAs ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_ExclOwners ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_PotOwners ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_Recipients ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table PeopleAssignments_Stakeholders ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ProcessInstanceInfo ( InstanceId number(19,0) not null, lastmodificationdate timestamp, lastreaddate timestamp, processid varchar2(255 char), processinstancebytearray blob, startdate timestamp, state number(10,0) not null, OPTLOCK number(10,0), primary key (InstanceId) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table ProcessInstanceLog ( id number(19,0) not null, duration number(19,0), end_date timestamp, externalid varchar2(255 char), user_identity varchar2(255 char), outcome varchar2(255 char), parentprocessinstanceid number(19,0), processid varchar2(255 char), processinstanceid number(19,0) not null, processname varchar2(255 char), processversion varchar2(255 char), start_date timestamp, status number(10,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Reassignment ( id number(19,0) not null, Escalation_Reassignments_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Reassignment_potentialOwners ( task_id number(19,0) not null, entity_id varchar2(255 char) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table SessionInfo ( id number(10,0) not null, lastmodificationdate timestamp, rulesbytearray blob, startdate timestamp, OPTLOCK number(10,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table Task ( id number(19,0) not null, archived number(5,0), delegation_allowedtodelegate varchar2(255 char), formname varchar2(255 char), priority number(10,0) not null, subtaskstrategy varchar2(255 char), taskdata_activationtime timestamp, taskdata_createdon timestamp, taskdata_deploymentid varchar2(255 char), taskdata_documentaccesstype number(10,0), taskdata_documentcontentid number(19,0) not null, taskdata_documenttype varchar2(255 char), taskdata_expirationtime timestamp, taskdata_faultaccesstype number(10,0), taskdata_faultcontentid number(19,0) not null, taskdata_faultname varchar2(255 char), taskdata_faulttype varchar2(255 char), taskdata_outputaccesstype number(10,0), taskdata_outputcontentid number(19,0) not null, taskdata_outputtype varchar2(255 char), taskdata_parentid number(19,0) not null, taskdata_previousstatus number(10,0), taskdata_processid varchar2(255 char), taskdata_processinstanceid number(19,0) not null, taskdata_processsessionid number(10,0) not null, taskdata_skipable number(1,0) not null, taskdata_status varchar2(255 char), taskdata_workitemid number(19,0) not null, tasktype varchar2(255 char), OPTLOCK number(10,0), peopl_assign_taskinitiator_id varchar2(255 char), taskdata_actualowner_id varchar2(255 char), taskdata_createdby_id varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table TaskEvent ( id number(19,0) not null, logtime timestamp, taskid number(19,0), type varchar2(255 char), userid varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table VariableInstanceLog ( id number(19,0) not null, log_date timestamp, externalid varchar2(255 char), oldvalue varchar2(255 char), processid varchar2(255 char), processinstanceid number(19,0) not null, value varchar2(255 char), variableid varchar2(255 char), variableinstanceid varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table WorkItemInfo ( workitemid number(19,0) not null, creationdate timestamp, name varchar2(255 char), processinstanceid number(19,0) not null, state number(19,0) not null, OPTLOCK number(10,0), workitembytearray blob, primary key (workitemid) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table email_header ( id number(19,0) not null, body clob, fromAddress varchar2(255 char), language varchar2(255 char), replyToAddress varchar2(255 char), subject varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table task_comment ( id number(19,0) not null, addedat timestamp, text clob, addedby_id varchar2(255 char), TaskData_Comments_Id number(19,0), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table Attachment add constraint FK_9jaco4irrkskr5phh97x2fe9h foreign key (attachedby_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Attachment add constraint FK_hqupx569krp0f0sgu9kh87513 foreign key (TaskData_Attachments_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table BooleanExpression add constraint FK_394nf2qoc0k9ok6omgd6jtpso foreign key (Escalation_Constraints_Id) references Escalation'); end; > [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] SQL: begin execute_if_exists('alter table CorrelationPropertyInfo add constraint FK_1mgvtkn3h0bxu2fd657apkvxs foreign key (correlationkey_keyId) references CorrelationKeyInfo'); end; > [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] SQL: begin execute_if_exists('alter table Deadline add constraint FK_68w742sge00vco2cq3jhbvmgx foreign key (Deadlines_StartDeadLine_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Deadline add constraint FK_euoohoelbqvv94d8a8rcg8s5n foreign key (Deadlines_EndDeadLine_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Delegation_delegates add constraint FK_gn7ula51sk55wj1o1m57guqxb foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Delegation_delegates add constraint FK_fajq6kossbsqwr3opkrctxei3 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Escalation add constraint FK_ay2gd4fvl9yaapviyxudwuvfg foreign key (Deadline_Escalation_Id) references Deadline'); end; > [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] SQL: begin execute_if_exists('alter table EventTypes add constraint FK_nrecj4617iwxlc65ij6m7lsl1 foreign key (InstanceId) references ProcessInstanceInfo'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_k16jpgrh67ti9uedf6konsu1p foreign key (Task_Subjects_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_fd9uk6hemv2dx1ojovo7ms3vp foreign key (Task_Names_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_4eyfp69ucrron2hr7qx4np2fp foreign key (Task_Descriptions_Id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_pqarjvvnwfjpeyb87yd7m0bfi foreign key (Reassignment_Documentation_Id) references Reassignment'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_o84rkh69r47ti8uv4eyj7bmo2 foreign key (Notification_Subjects_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_g1trxri8w64enudw2t1qahhk5 foreign key (Notification_Names_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_qoce92c70adem3ccb3i7lec8x foreign key (Notification_Documentation_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_bw8vmpekejxt1ei2ge26gdsry foreign key (Notification_Descriptions_Id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table I18NText add constraint FK_21qvifarxsvuxeaw5sxwh473w foreign key (Deadline_Documentation_Id) references Deadline'); end; > [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] SQL: begin execute_if_exists('alter table Notification add constraint FK_bdbeml3768go5im41cgfpyso9 foreign key (Escalation_Notifications_Id) references Escalation'); end; > [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] SQL: begin execute_if_exists('alter table Notification_BAs add constraint FK_mfbsnbrhth4rjhqc2ud338s4i foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Notification_BAs add constraint FK_fc0uuy76t2bvxaxqysoo8xts7 foreign key (task_id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table Notification_Recipients add constraint FK_blf9jsrumtrthdaqnpwxt25eu foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Notification_Recipients add constraint FK_3l244pj8sh78vtn9imaymrg47 foreign key (task_id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table Notification_email_header add constraint UK_25vn3oqfsiwwda26w9uiprrwe unique (emailheaders_id)'); end; > [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] SQL: begin execute_if_exists('alter table Notification_email_header add constraint FK_25vn3oqfsiwwda26w9uiprrwe foreign key (emailheaders_id) references email_header'); end; > [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] SQL: begin execute_if_exists('alter table Notification_email_header add constraint FK_eth4nvxn21fk1vnju85vkjrai foreign key (Notification_id) references Notification'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_BAs add constraint FK_t38xbkrq6cppifnxequhvjsl2 foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_BAs add constraint FK_omjg5qh7uv8e9bolbaq7hv6oh foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_ExclOwners add constraint FK_pth28a73rj6bxtlfc69kmqo0a foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_ExclOwners add constraint FK_b8owuxfrdng050ugpk0pdowa7 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_PotOwners add constraint FK_tee3ftir7xs6eo3fdvi3xw026 foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_PotOwners add constraint FK_4dv2oji7pr35ru0w45trix02x foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Recipients add constraint FK_4g7y3wx6gnokf6vycgpxs83d6 foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Recipients add constraint FK_enhk831fghf6akjilfn58okl4 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Stakeholders add constraint FK_met63inaep6cq4ofb3nnxi4tm foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table PeopleAssignments_Stakeholders add constraint FK_4bh3ay74x6ql9usunubttfdf1 foreign key (task_id) references Task'); end; > [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] SQL: begin execute_if_exists('alter table Reassignment add constraint FK_pnpeue9hs6kx2ep0sp16b6kfd foreign key (Escalation_Reassignments_Id) references Escalation'); end; > [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] SQL: begin execute_if_exists('alter table Reassignment_potentialOwners add constraint FK_8frl6la7tgparlnukhp8xmody foreign key (entity_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Reassignment_potentialOwners add constraint FK_qbega5ncu6b9yigwlw55aeijn foreign key (task_id) references Reassignment'); end; > [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] SQL: begin execute_if_exists('alter table Task add constraint FK_7hos7h1ft5wygyru9vm2mtp6b foreign key (peopl_assign_taskinitiator_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Task add constraint FK_iu0slqdkjbb9mvikrns8mvqcg foreign key (taskdata_actualowner_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table Task add constraint FK_tek6betmy2fl0bnwrsx9a4fi9 foreign key (taskdata_createdby_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table task_comment add constraint FK_fencp0rt8gae730n7621vqjre foreign key (addedby_id) references OrganizationalEntity'); end; > [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] SQL: begin execute_if_exists('alter table task_comment add constraint FK_1ws9jdmhtey6mxu7jb0r0ufvs foreign key (TaskData_Comments_Id) references Task'); end; > [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] SQL: begin execute_if_not_exists('create sequence ATTACHMENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence BAM_TASK_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence BOOLEANEXPR_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence COMMENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CONTENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CONTEXT_MAPPING_INFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CORRELATION_KEY_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence CORRELATION_PROP_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence DEADLINE_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence EMAILNOTIFHEAD_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence ESCALATION_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence I18NTEXT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence NODE_INST_LOG_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence NOTIFICATION_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence PROCESS_INSTANCE_INFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence PROC_INST_LOG_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence REASSIGNMENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence SESSIONINFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence TASK_EVENT_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence TASK_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence VAR_INST_LOG_ID_SEQ'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create sequence WORKITEMINFO_ID_SEQ'); end; > [sql] 0 rows affected > [sql] 56 of 101 SQL statements executed successfully > >rtgov.check: >[available] Found directory: rtgov > >rtgov: > [sql] connecting to jdbc:oracle:thin:@jawa06.mw.lab.eng.brq.redhat.com:1521:soaesb1 > [sql] Loading oracle.jdbc.OracleDriver using a cached AntClassLoader. > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/rtgov/gadget-web.gadget-core.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table GS_APP_DATA ( ID number(19,0) not null, APP_URL varchar2(255 char), USER_ID number(19,0), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table GS_GADGET ( GAGET_ID number(19,0) not null, GADGET_AUTHOR varchar2(255 char), GADGET_AUTHOR_EMAIL varchar2(255 char), GADGET_DESCRIPTION varchar2(255 char), GADGET_GROUP raw(255), GADGET_SCREENSHOT_URL varchar2(255 char), GADGET_THUMBNAIL_URL varchar2(255 char), GADGET_TITLE varchar2(255 char), GADGET_TITLE_URL varchar2(255 char), GADGET_TYPE varchar2(255 char), GADGET_URL varchar2(255 char), primary key (GAGET_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table GS_GROUP ( GROUP_ID number(19,0) not null, GROUP_DESC varchar2(255 char), GROUP_NAME varchar2(255 char), primary key (GROUP_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table GS_PAGE ( PAGE_ID number(19,0) not null, PAGE_COLUMNS number(19,0), PAGE_NAME varchar2(255 char), PAGE_ORDER number(19,0), PAGE_USER number(19,0), primary key (PAGE_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table GS_USER ( ID number(19,0) not null, CURR_PAGE_ID number(19,0), DISPLAY_NAME varchar2(255 char), EMAIL varchar2(255 char), NAME varchar2(255 char), USER_ROLE varchar2(255 char), primary key (ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table GS_USER_GROUP ( USER_ID number(19,0) not null, GROUP_ID number(19,0) not null )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table GS_WIDGET ( WIDGET_ID number(19,0) not null, WIDGET_URL varchar2(255 char), WIDGET_NAME varchar2(255 char), WIDGET_ORDER number(19,0), page_PAGE_ID number(19,0), primary key (WIDGET_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table GS_WIDGET_PREF ( WIDGET_PREF_ID number(19,0) not null, WIDGET_PREF_NAME varchar2(255 char), WIDGET_PREF_VALUE varchar2(255 char), widget_WIDGET_ID number(19,0), primary key (WIDGET_PREF_ID) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table GS_PAGE add constraint FK_5j5yf04wju6wn9q6j0sli31wq foreign key (PAGE_USER) references GS_USER'); end; > [sql] Failed to execute: begin execute_if_exists('alter table GS_PAGE add constraint FK_5j5yf04wju6wn9q6j0sli31wq foreign key (PAGE_USER) references GS_USER'); 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] SQL: begin execute_if_exists('alter table GS_USER_GROUP add constraint FK_mgiqrspnmywwtgpfuoxvxo1bb foreign key (GROUP_ID) references GS_GROUP'); end; > [sql] Failed to execute: begin execute_if_exists('alter table GS_USER_GROUP add constraint FK_mgiqrspnmywwtgpfuoxvxo1bb foreign key (GROUP_ID) references GS_GROUP'); 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] SQL: begin execute_if_exists('alter table GS_USER_GROUP add constraint FK_c4slaed8sqe7jpu080d9fhslh foreign key (USER_ID) references GS_USER'); end; > [sql] Failed to execute: begin execute_if_exists('alter table GS_USER_GROUP add constraint FK_c4slaed8sqe7jpu080d9fhslh foreign key (USER_ID) references GS_USER'); 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] SQL: begin execute_if_exists('alter table GS_WIDGET add constraint FK_itursfkumpygn547bnx4jp4cl foreign key (page_PAGE_ID) references GS_PAGE'); end; > [sql] Failed to execute: begin execute_if_exists('alter table GS_WIDGET add constraint FK_itursfkumpygn547bnx4jp4cl foreign key (page_PAGE_ID) references GS_PAGE'); 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] SQL: begin execute_if_exists('alter table GS_WIDGET_PREF add constraint FK_152vlr5pyu65tpe6jadivbj4 foreign key (widget_WIDGET_ID) references GS_WIDGET'); end; > [sql] Failed to execute: begin execute_if_exists('alter table GS_WIDGET_PREF add constraint FK_152vlr5pyu65tpe6jadivbj4 foreign key (widget_WIDGET_ID) references GS_WIDGET'); 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] SQL: begin execute_if_not_exists('create sequence hibernate_sequence'); end; > [sql] 0 rows affected > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/rtgov/overlord-rtgov-epn.overlord-rtgov-epn.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITIES ( activityType varchar2(31 char) not null, unitId varchar2(255 char) not null, unitIndex number(10,0) not null, principal varchar2(255 char), tstamp number(19,0), customType varchar2(255 char), logLevel number(10,0), message varchar2(255 char), instanceId varchar2(255 char), processType varchar2(255 char), status number(10,0), version varchar2(255 char), variableName varchar2(255 char), variableType varchar2(255 char), variableValue varchar2(255 char), content clob, messageType varchar2(255 char), destination varchar2(255 char), fault varchar2(255 char), interface varchar2(255 char), operation varchar2(255 char), serviceType varchar2(255 char), replyToId varchar2(255 char), primary key (unitId, unitIndex) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITY_CONTEXT ( unitId varchar2(255 char) not null, unitIndex number(10,0) not null, timeframe number(19,0), contextType varchar2(255 char), value varchar2(255 char) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITY_PROPERTIES ( unitId varchar2(255 char) not null, unitIndex number(10,0) not null, value varchar2(255 char), name varchar2(255 char) not null, primary key (unitId, unitIndex, name) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITY_UNITS ( id varchar2(255 char) not null, host varchar2(255 char), node varchar2(255 char), principal varchar2(255 char), thread varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_SITUATIONS ( id varchar2(255 char) not null, description clob, severity number(10,0), subject varchar2(255 char), tstamp number(19,0), situationType varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_SITUATION_ACTIVITY_TYPES ( Situation_id varchar2(255 char) not null, unitId varchar2(255 char), unitIndex number(10,0) not null, primary key (Situation_id, unitIndex) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_SITUATION_CONTEXT ( Situation_id varchar2(255 char) not null, timeframe number(19,0), contextType varchar2(255 char), value varchar2(255 char) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_SITUATION_PROPERTIES ( id varchar2(255 char) not null, value varchar2(255 char), name varchar2(255 char) not null, primary key (id, name) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table RTGOV_ACTIVITIES add constraint FK_qkn2182qh2hf52txyugoloqaq foreign key (unitId) references RTGOV_ACTIVITY_UNITS'); end; > [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] SQL: begin execute_if_exists('alter table RTGOV_ACTIVITY_CONTEXT add constraint FK_taqus05muupkc8xuuyig97lx7 foreign key (unitId, unitIndex) references RTGOV_ACTIVITIES'); end; > [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] SQL: begin execute_if_exists('alter table RTGOV_ACTIVITY_PROPERTIES add constraint FK_c5src0indd1kbiljcs7ruf2rc foreign key (unitId, unitIndex) references RTGOV_ACTIVITIES'); end; > [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] SQL: begin execute_if_exists('alter table RTGOV_SITUATION_ACTIVITY_TYPES add constraint FK_l3yoqst9iu0euiw0vo2b5t5yu foreign key (Situation_id) references RTGOV_SITUATIONS'); end; > [sql] Failed to execute: begin execute_if_exists('alter table RTGOV_SITUATION_ACTIVITY_TYPES add constraint FK_l3yoqst9iu0euiw0vo2b5t5yu foreign key (Situation_id) references RTGOV_SITUATIONS'); 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] SQL: begin execute_if_exists('alter table RTGOV_SITUATION_CONTEXT add constraint FK_b08bon7ya4r67qlm24alhqdpg foreign key (Situation_id) references RTGOV_SITUATIONS'); end; > [sql] Failed to execute: begin execute_if_exists('alter table RTGOV_SITUATION_CONTEXT add constraint FK_b08bon7ya4r67qlm24alhqdpg foreign key (Situation_id) references RTGOV_SITUATIONS'); 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] SQL: begin execute_if_exists('alter table RTGOV_SITUATION_PROPERTIES add constraint FK_js9tml3lmnlrl38etv7mouwox foreign key (id) references RTGOV_SITUATIONS'); end; > [sql] Failed to execute: begin execute_if_exists('alter table RTGOV_SITUATION_PROPERTIES add constraint FK_js9tml3lmnlrl38etv7mouwox foreign key (id) references RTGOV_SITUATIONS'); 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/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/rtgov/overlord-rtgov.overlord-rtgov-activity.Oracle10gDialect.sql > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITIES ( activityType varchar2(31 char) not null, unitId varchar2(255 char) not null, unitIndex number(10,0) not null, principal varchar2(255 char), tstamp number(19,0), customType varchar2(255 char), logLevel number(10,0), message varchar2(255 char), instanceId varchar2(255 char), processType varchar2(255 char), status number(10,0), version varchar2(255 char), variableName varchar2(255 char), variableType varchar2(255 char), variableValue varchar2(255 char), content clob, messageType varchar2(255 char), destination varchar2(255 char), fault varchar2(255 char), interface varchar2(255 char), operation varchar2(255 char), serviceType varchar2(255 char), replyToId varchar2(255 char), primary key (unitId, unitIndex) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITY_CONTEXT ( unitId varchar2(255 char) not null, unitIndex number(10,0) not null, timeframe number(19,0), contextType varchar2(255 char), value varchar2(255 char) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITY_PROPERTIES ( unitId varchar2(255 char) not null, unitIndex number(10,0) not null, value varchar2(255 char), name varchar2(255 char) not null, primary key (unitId, unitIndex, name) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_not_exists('create table RTGOV_ACTIVITY_UNITS ( id varchar2(255 char) not null, host varchar2(255 char), node varchar2(255 char), principal varchar2(255 char), thread varchar2(255 char), primary key (id) )'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('alter table RTGOV_ACTIVITIES add constraint FK_qkn2182qh2hf52txyugoloqaq foreign key (unitId) references RTGOV_ACTIVITY_UNITS'); end; > [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] SQL: begin execute_if_exists('alter table RTGOV_ACTIVITY_CONTEXT add constraint FK_taqus05muupkc8xuuyig97lx7 foreign key (unitId, unitIndex) references RTGOV_ACTIVITIES'); end; > [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] SQL: begin execute_if_exists('alter table RTGOV_ACTIVITY_PROPERTIES add constraint FK_c5src0indd1kbiljcs7ruf2rc foreign key (unitId, unitIndex) references RTGOV_ACTIVITIES'); end; > [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/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/data/rtgov/import_rtgov.Oracle10gDialect.sql > [sql] SQL: INSERT INTO GS_GROUP("GROUP_ID","GROUP_NAME", "GROUP_DESC") VALUES(1, 'system', 'reserved system group') > [sql] Failed to execute: INSERT INTO GS_GROUP("GROUP_ID","GROUP_NAME", "GROUP_DESC") VALUES(1, 'system', 'reserved system group') > [sql] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SOAESB1.SYS_C00506814) violated > [sql] SQL: INSERT INTO GS_USER("ID", "NAME", "DISPLAY_NAME", "USER_ROLE") VALUES(1, 'admin', 'Administrator', 'ADMIN') > [sql] Failed to execute: INSERT INTO GS_USER("ID", "NAME", "DISPLAY_NAME", "USER_ROLE") VALUES(1, 'admin', 'Administrator', 'ADMIN') > [sql] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SOAESB1.SYS_C00506818) violated > [sql] SQL: INSERT INTO GS_USER_GROUP("USER_ID", "GROUP_ID") VALUES(1, 1) > [sql] 1 rows affected >Property "server" has not been set >Property "server" has not been set > [sql] SQL: INSERT INTO GS_GADGET("GAGET_ID","GADGET_TITLE","GADGET_AUTHOR","GADGET_AUTHOR_EMAIL","GADGET_DESCRIPTION","GADGET_THUMBNAIL_URL","GADGET_URL") VALUES(hibernate_sequence.nextval,'Response Time','Red Hat','cyu@redhat.com','Response Time Gadget','${server}/gadgets/rt-gadget/thumbnail.png','${server}/gadgets/rt-gadget/gadget.xml') > [sql] 1 rows affected >Property "server" has not been set >Property "server" has not been set > [sql] SQL: INSERT INTO GS_GADGET("GAGET_ID","GADGET_TITLE","GADGET_AUTHOR","GADGET_AUTHOR_EMAIL","GADGET_DESCRIPTION","GADGET_THUMBNAIL_URL","GADGET_URL") VALUES(hibernate_sequence.nextval,'Situation Gadget','Red Hat','cyu@redhat.com','Situation Gadget','${server}/gadgets/situation-gadget/thumbnail.png','${server}/gadgets/situation-gadget/gadget.xml') > [sql] 1 rows affected >Property "server" has not been set >Property "server" has not been set > [sql] SQL: INSERT INTO GS_GADGET("GAGET_ID","GADGET_TITLE","GADGET_AUTHOR","GADGET_AUTHOR_EMAIL","GADGET_DESCRIPTION","GADGET_THUMBNAIL_URL","GADGET_URL") VALUES(hibernate_sequence.nextval,'Call Trace Gadget','Red Hat','cyu@redhat.com','Call Trace Gadget','${server}/gadgets/calltrace-gadget/thumbnail.png','${server}/gadgets/calltrace-gadget/gadget.xml') > [sql] 1 rows affected >Property "server" has not been set >Property "server" has not been set > [sql] SQL: INSERT INTO GS_GADGET("GAGET_ID","GADGET_TITLE","GADGET_AUTHOR","GADGET_AUTHOR_EMAIL","GADGET_DESCRIPTION","GADGET_THUMBNAIL_URL","GADGET_URL") VALUES(hibernate_sequence.nextval,'Service Overview Gadget','Red Hat','cyu@redhat.com','Service Overview Gadget','${server}/gadgets/so-gadget/thumbnail.png','${server}/gadgets/so-gadget/gadget.xml') > [sql] 1 rows affected > [sql] 26 of 42 SQL statements executed successfully > >indexes.check: >[available] Found directory: indexes > >indexes: > [sql] connecting to jdbc:oracle:thin:@jawa06.mw.lab.eng.brq.redhat.com:1521:soaesb1 > [sql] Loading oracle.jdbc.OracleDriver using a cached AntClassLoader. > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/indexes/dtgov.Oracle10gDialect.sql > [sql] SQL: begin execute_if_exists('create index IDX_ATTACHMENT_01 on Attachment (attachedBy_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_ATTACHMENT_02 on Attachment (TaskData_Attachments_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BOOLEAN_EXPR_01 on BooleanExpression (Escalation_Constraints_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_CORR_PROP_INFO_01 on CorrelationPropertyInfo (correlationKey_keyId)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEADLINE_01 on Deadline (Deadlines_StartDeadLine_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEADLINE_02 on Deadline (Deadlines_EndDeadLine_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEL_DELEGATES_01 on Delegation_delegates (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEL_DELEGATES_02 on Delegation_delegates (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEL_ESCALATION_01 on Escalation (Deadline_Escalation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_EVENT_TYPES_01 on EventTypes (InstanceId)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_01 on I18NText (Task_Subjects_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_02 on I18NText (Task_Names_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_03 on I18NText (Task_Descriptions_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_04 on I18NText (Reassignment_Documentation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_05 on I18NText (Notification_Subjects_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_06 on I18NText (Notification_Names_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_07 on I18NText (Notification_Documentation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_08 on I18NText (Notification_Descriptions_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_09 on I18NText (Deadline_Documentation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_01 on Notification (Escalation_Notifications_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_BAS_01 on Notification_BAs (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_BAS_02 on Notification_BAs (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_RECIPIENTS_01 on Notification_Recipients (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_RECIPIENTS_02 on Notification_Recipients (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_EMAIL_01 on Notification_email_header (Notification_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_BAS_01 on PeopleAssignments_BAs (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_BAS_02 on PeopleAssignments_BAs (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_EXCL_01 on PeopleAssignments_ExclOwners (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_EXCL_02 on PeopleAssignments_ExclOwners (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_POT_01 on PeopleAssignments_PotOwners (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_POT_02 on PeopleAssignments_PotOwners (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_RECIP_01 on PeopleAssignments_Recipients (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_RECIP_02 on PeopleAssignments_Recipients (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_STAKE_01 on PeopleAssignments_Stakeholders (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_STAKE_02 on PeopleAssignments_Stakeholders (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_REASSIGNMENT_01 on Reassignment (Escalation_Reassignments_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_REASSIGNMENT_POT_01 on Reassignment_potentialOwners (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_REASSIGNMENT_POT_02 on Reassignment_potentialOwners (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_01 on Task (peopl_assign_taskinitiator_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_02 on Task (taskdata_actualowner_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_03 on Task (taskdata_createdby_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_COMMENT_01 on task_comment (addedby_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_COMMENT_02 on task_comment (TaskData_Comments_Id)'); end; > [sql] 0 rows affected > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/indexes/jbpm.Oracle10gDialect.sql > [sql] SQL: begin execute_if_exists('create index IDX_ATTACHMENT_01 on Attachment (attachedBy_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_ATTACHMENT_02 on Attachment (TaskData_Attachments_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BOOLEAN_EXPR_01 on BooleanExpression (Escalation_Constraints_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_CORR_PROP_INFO_01 on CorrelationPropertyInfo (correlationKey_keyId)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEADLINE_01 on Deadline (Deadlines_StartDeadLine_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEADLINE_02 on Deadline (Deadlines_EndDeadLine_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEL_DELEGATES_01 on Delegation_delegates (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEL_DELEGATES_02 on Delegation_delegates (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_DEL_ESCALATION_01 on Escalation (Deadline_Escalation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_EVENT_TYPES_01 on EventTypes (InstanceId)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_01 on I18NText (Task_Subjects_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_02 on I18NText (Task_Names_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_03 on I18NText (Task_Descriptions_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_04 on I18NText (Reassignment_Documentation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_05 on I18NText (Notification_Subjects_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_06 on I18NText (Notification_Names_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_07 on I18NText (Notification_Documentation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_08 on I18NText (Notification_Descriptions_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_I18TEXT_09 on I18NText (Deadline_Documentation_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_01 on Notification (Escalation_Notifications_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_BAS_01 on Notification_BAs (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_BAS_02 on Notification_BAs (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_RECIPIENTS_01 on Notification_Recipients (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_RECIPIENTS_02 on Notification_Recipients (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_NOTIFICATION_EMAIL_01 on Notification_email_header (Notification_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_BAS_01 on PeopleAssignments_BAs (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_BAS_02 on PeopleAssignments_BAs (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_EXCL_01 on PeopleAssignments_ExclOwners (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_EXCL_02 on PeopleAssignments_ExclOwners (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_POT_01 on PeopleAssignments_PotOwners (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_POT_02 on PeopleAssignments_PotOwners (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_RECIP_01 on PeopleAssignments_Recipients (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_RECIP_02 on PeopleAssignments_Recipients (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_STAKE_01 on PeopleAssignments_Stakeholders (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_PEOPLE_ASSIGN_STAKE_02 on PeopleAssignments_Stakeholders (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_REASSIGNMENT_01 on Reassignment (Escalation_Reassignments_Id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_REASSIGNMENT_POT_01 on Reassignment_potentialOwners (entity_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_REASSIGNMENT_POT_02 on Reassignment_potentialOwners (task_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_01 on Task (peopl_assign_taskinitiator_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_02 on Task (taskdata_actualowner_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_03 on Task (taskdata_createdby_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_COMMENT_01 on task_comment (addedby_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_TASK_COMMENT_02 on task_comment (TaskData_Comments_Id)'); end; > [sql] 0 rows affected > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/indexes/riftsaw.Oracle10gDialect.sql > [sql] SQL: begin execute_if_exists('create index IDX_BPAF_EVENT_DATA on BPAF_EVENT_DATA (EVENT_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_ACT_REC_01 on BPEL_ACTIVITY_RECOVERY (INSTANCE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_CORR_SET_01 on BPEL_CORRELATION_SET (SCOPE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_CORRELATOR_01 on BPEL_CORRELATOR (PROC_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_CORSET_DROP_01 on BPEL_CORSET_PROP (CORRSET_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_EVENT_01 on BPEL_EVENT (INSTANCE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_EVENT_02 on BPEL_EVENT (PROCESS_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_MESSAGE_01 on BPEL_MESSAGE (MESSAGE_EXCHANGE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_MESSAGE_EX_01 on BPEL_MESSAGE_EXCHANGE (CORR_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_MESSAGE_EX_02 on BPEL_MESSAGE_EXCHANGE (PARTNER_LINK_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_MESSAGE_EX_03 on BPEL_MESSAGE_EXCHANGE (PROCESS_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_MESSAGE_ROU_01 on BPEL_MESSAGE_ROUTE (CORR_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_MESSAGE_ROU_02 on BPEL_MESSAGE_ROUTE (PROCESS_INSTANCE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_MEX_PROP_01 on BPEL_MEX_PROP (MEX_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_PART_LINK_01 on BPEL_PARTNER_LINK (SCOPE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_PROC_INST_01 on BPEL_PROCESS_INSTANCE (INSTANTIATING_CORRELATOR_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_PROC_INST_02 on BPEL_PROCESS_INSTANCE (PROCESS_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_SCOPE_01 on BPEL_SCOPE (PROCESS_INSTANCE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_XML_DATA_01 on BPEL_XML_DATA (SCOPE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_BPEL_XML_DROP_01 on BPEL_XML_DATA_PROP (XML_DATA_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_STORE_PROCESS_01 on STORE_PROCESS (DU)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_STORE_PROC_PROP_01 on STORE_PROC_TO_PROP (STORE_PROCESS_PID)'); end; > [sql] 0 rows affected > [sql] Executing resource: /opt/pmacik/600ER8/soa-p-oracle-2/jboss-eap-6.1/sql/indexes/rtgov.Oracle10gDialect.sql > [sql] SQL: begin execute_if_exists('create index IDX_GS_PAGE_01 on GS_PAGE (PAGE_USER)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_GS_USER_GROUP_01 on GS_USER_GROUP (GROUP_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_GS_USER_GROUP_02 on GS_USER_GROUP (USER_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_GS_WIDGET_01 on GS_WIDGET (page_PAGE_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_GS_WIDGET_PREF_01 on GS_WIDGET_PREF (widget_WIDGET_ID)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_RTGOV_ACTIVITIES_01 on RTGOV_ACTIVITIES (unitId)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_RTGOV_ACT_CON_01 on RTGOV_ACTIVITY_CONTEXT (unitId, unitIndex)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_RTGOV_ACT_CON_02 on RTGOV_ACTIVITY_CONTEXT (value,contextType)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_RTGOV_ACT_PRO_01 on RTGOV_ACTIVITY_PROPERTIES (unitId, unitIndex)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_RTGOV_SIT_ACT_01 on RTGOV_SITUATION_ACTIVITY_TYPES (Situation_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_RTGOV_SIT_CON_01 on RTGOV_SITUATION_CONTEXT (Situation_id)'); end; > [sql] 0 rows affected > [sql] SQL: begin execute_if_exists('create index IDX_RTGOV_SIT_PROP_01 on RTGOV_SITUATION_PROPERTIES (id)'); end; > [sql] 0 rows affected > [sql] 120 of 120 SQL statements executed successfully > >all: > >BUILD SUCCESSFUL >Total time: 4 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