<000000>
com.bea.wli.init.WLIDBCreateException: Could not execute (possibly among others) CREATE statement for INDEX IX_WLI_MESSA
GE_BROKER_DYNAMIC: CREATE INDEX IX_WLI_MESSAGE_BROKER_DYNAMIC ON WLI_MESSAGE_BROKER_DYNAMIC( HASH_ID)
at com.bea.wli.init.WLIDBCreate$WLIDataSource.createDBObjects(WLIDBCreate.java:671)
at com.bea.wli.init.WLIDBCreate.init(WLIDBCreate.java:1008)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Truncated. see log file for complete stacktrace

Your boss won't believe you when you say that you didn't change a thing, but shit like this happens.

You try debugging the shit outta this WLIDBCreate.class file (after you spend hours searching where the shitty jar file is in which it is sitting pretty... btw, it is jpd.jar, located in weblogic92/server/lib in your weblogic 9.2 install location).

okay, i get it. i'm getting to the damn resolution.

The thing is, it is the DB that's messed up. How? i have no idea. But it has.

So if you run this sql file that i have compiled, you should be all set and ready to hit the ground running.
Obv. you are running this at your own risk, as defined in my disclaimer section (conveniently worded).
but this shit works.

In case you are wondering how i debugged it, i should say it wasn't all that simple.
but to cut a long story short, when i tried to create a new domain, i used the 'Run Scripts' command located just after the screen where you configure your datasources. I let it use the default pointbase server, then i copied the sql commands it ran, cleaned the shit out from it, tweaked it so that it runs on oracle, and then finally ran it to restore it to its former glory.

So there goes nothing... best of luck!

okay, the shitty wordpress blog didn't let me upload my .sql file, and nor my file without extensions 'for security reasons'. so fuxx it. copy the text below and create a file. feel free to name any obnoxious name you can think of. i won't be offended. i can't possibly be any more offended than i am right now anyways.

-------
DROP TABLE WLI_CALENDAR;

DROP TABLE WLI_CALENDAR_SEQUENCE;

DROP TABLE WLI_WORKLIST_TASK;

DROP TABLE WLI_WORKLIST_STEP_ESTIMATE;

DROP TABLE WLI_WORKLIST_TASK_ASSIGNEE;

DROP TABLE WLI_WORKLIST_TASK_LISTENER;

DROP TABLE WLI_WORKLIST_TASK_PROPERTY;

DROP TABLE WLI_WORKLIST_TASK_SUBSTITUTE;

COMMIT;

DROP TABLE WLI_WORKLIST_RPT_EVENT;

DROP TABLE WLI_WORKLIST_RPT_INFO;

DROP TABLE WLI_WORKLIST_RPT_PROP;

DROP TABLE WLI_WORKLIST_RPT_ACTION;

COMMIT;

CREATE TABLE WLI_CALENDAR
(
ID INTEGER NOT NULL,
NAME VARCHAR(250) NOT NULL,
XML BLOB NOT NULL,
SYS_FLAG VARCHAR(1) NULL,
CONSTRAINT PK_WLI_CALENDAR PRIMARY KEY(ID)
);

COMMIT;

CREATE TABLE WLI_CALENDAR_SEQUENCE ( SEQUENCE INTEGER NOT NULL );

COMMIT;

INSERT INTO WLI_CALENDAR_SEQUENCE(SEQUENCE) values(1);

COMMIT;

CREATE TABLE WLI_WORKLIST_TASK ( TASK_ID VARCHAR(64) NOT NULL, TASK_PLAN_ID VARCHAR(255) NOT NULL, NAME VARCHAR(250) NULL, DESCR VARCHAR(1000) NULL, COMNT VARCHAR(2000) NULL, PRIORITY NUMBER NULL, CREATOR_HANDLE_STR VARCHAR(500) NULL, CREATE_DT NUMBER NULL, CREATOR VARCHAR(125) NULL, TASK_COMPLETE_DUE_DT NUMBER NULL, OWNER VARCHAR(125) NULL, IS_OWNER_GRP SMALLINT NULL, LAST_UPDATE_DT NUMBER NULL, LAST_UPDATE_USER VARCHAR(125) NULL, ADMIN_STATE VARCHAR(10) NOT NULL, ERROR_MSG VARCHAR(2000) NULL, WORKING_STATE VARCHAR(10) NOT NULL, CLAIMANT VARCHAR(125) NULL, CURR_STEP_NAME VARCHAR(100) NULL, CURR_STEP_CLAIM_DUE_DT NUMBER NULL, CURR_STEP_COMPLETE_DUE_DT NUMBER NULL, CONSTRUCTOR_NAME VARCHAR(100) NULL, FINAL_STEP_NAME VARCHAR(100) NULL, FINAL_ACTION_NAME VARCHAR(100) NULL, TASK_TIME_ESTIMATE VARCHAR(80) NULL );

COMMIT;

CREATE UNIQUE INDEX IWKL_TSK_TASK_ID ON WLI_WORKLIST_TASK (TASK_ID);

CREATE INDEX IWKL_TSK_PLNID_TID ON WLI_WORKLIST_TASK(TASK_PLAN_ID, TASK_ID);

CREATE INDEX IWKL_TSK_PI_WS_TI ON WLI_WORKLIST_TASK(TASK_PLAN_ID, WORKING_STATE, TASK_ID);

CREATE INDEX IWKL_TSK_CLAIMANT ON WLI_WORKLIST_TASK(CLAIMANT);

CREATE INDEX IWKL_TSK_CURRSTEP ON WLI_WORKLIST_TASK(TASK_PLAN_ID, CURR_STEP_NAME);

CREATE INDEX IWKL_TSK_STATE ON WLI_WORKLIST_TASK(ADMIN_STATE, WORKING_STATE);

COMMIT;

CREATE TABLE WLI_WORKLIST_STEP_ESTIMATE ( ESTIMATE_ID VARCHAR(64) NULL, TASK_ID VARCHAR(64) NULL, STEP_NAME VARCHAR(100) NOT NULL, TIME_ESTIMATE VARCHAR(80) NOT NULL );

COMMIT;

CREATE INDEX IWKL_STE_TSKSTEPID ON WLI_WORKLIST_STEP_ESTIMATE(TASK_ID, STEP_NAME);

COMMIT;

CREATE TABLE WLI_WORKLIST_TASK_ASSIGNEE ( ASSIGNEE_ID VARCHAR(64) NULL, TASK_ID VARCHAR(64) NULL, TYPE VARCHAR(5) NULL, NAME VARCHAR(125) NULL );

COMMIT;

CREATE UNIQUE INDEX IWKL_ASN_ASNID ON WLI_WORKLIST_TASK_ASSIGNEE (ASSIGNEE_ID);

CREATE INDEX IWKL_ASN_TYP_TID ON WLI_WORKLIST_TASK_ASSIGNEE(TYPE, TASK_ID);

CREATE INDEX IWKL_ASN_ID_TP_NM ON WLI_WORKLIST_TASK_ASSIGNEE(NAME, TYPE);

CREATE INDEX IWKL_ASN_TID ON WLI_WORKLIST_TASK_ASSIGNEE(TASK_ID);

CREATE TABLE WLI_WORKLIST_TASK_LISTENER
(
LISTENER_ID VARCHAR2(64) NULL,
TASK_ID VARCHAR2(64) NULL,
TYPE VARCHAR2(11) NULL,
LISTENER_HANDLE_VALUE VARCHAR2(2000) NULL,
LISTENER_HANDLE BLOB NULL,
ACTION_VALUE INTEGER NULL,
METHOD_NAME VARCHAR2(1000) NULL
);

COMMIT;

CREATE UNIQUE INDEX IWKL_LSTN_LSTNID ON WLI_WORKLIST_TASK_LISTENER(LISTENER_ID);

CREATE INDEX IWKL_LSTN_TASKLSTN ON WLI_WORKLIST_TASK_LISTENER(TASK_ID);

COMMIT;

CREATE TABLE WLI_WORKLIST_TASK_PROPERTY
(
PROPERTY_ID VARCHAR2(64) NULL,
TASK_ID VARCHAR2(64) NULL,
NAME VARCHAR2(100) NOT NULL,
STORAGE_FORMAT VARCHAR2(255) NULL,
IS_LARGE SMALLINT NOT NULL,
RAW_SMALL_VALUE VARCHAR2(4000) NULL,
RAW_LARGE_VALUE BLOB NULL
);

COMMIT;

CREATE UNIQUE INDEX IWKL_PROP_PROPID ON WLI_WORKLIST_TASK_PROPERTY(PROPERTY_ID);

CREATE INDEX IWKL_PROP_TASKID ON WLI_WORKLIST_TASK_PROPERTY(TASK_ID);

CREATE INDEX IWKL_PROP_TSKNM ON WLI_WORKLIST_TASK_PROPERTY(NAME);

COMMIT;
CREATE TABLE WLI_WORKLIST_TASK_SUBSTITUTE ( SUBST_ID VARCHAR(64) NOT NULL, EFFECTIVE_DT NUMBER NULL, EXPIRY_DT NUMBER NULL, SOURCE VARCHAR(250) NULL, TARGET VARCHAR(250) NULL );

COMMIT;

CREATE UNIQUE INDEX IWKL_SUBS_SUBSID ON WLI_WORKLIST_TASK_SUBSTITUTE(SUBST_ID);

CREATE INDEX IWKL_SUBS_SOURCE ON WLI_WORKLIST_TASK_SUBSTITUTE(SOURCE);

COMMIT;

CREATE TABLE WLI_WORKLIST_RPT_EVENT ( TASK_EVENT_ID CHAR(64) NOT NULL, TASK_ID CHAR(64) NOT NULL, TASK_PLAN_ID VARCHAR(255) NOT NULL, EVENT_TYPE VARCHAR(32) NOT NULL, CALLER VARCHAR(125) NOT NULL, TIMESTAMP NUMBER NOT NULL, SERVER_NAME VARCHAR(32) NOT NULL, SUMMARY VARCHAR(200) NOT NULL );

COMMIT;

CREATE INDEX IWKLR_EVENT_TSKID ON WLI_WORKLIST_RPT_EVENT(TASK_ID);

CREATE INDEX IWKLR_EVENT_TPIDET ON WLI_WORKLIST_RPT_EVENT(TASK_PLAN_ID, EVENT_TYPE);

CREATE INDEX IWKLR_EVENT_EVT ON WLI_WORKLIST_RPT_EVENT(EVENT_TYPE);

COMMIT;

CREATE TABLE WLI_WORKLIST_RPT_INFO ( TASK_ID CHAR(64) NOT NULL, TASK_EVENT_ID CHAR(64) NOT NULL, TASK_PLAN_ID VARCHAR(255) NOT NULL, NAME VARCHAR(250) NOT NULL, DESCR VARCHAR(1000) NULL, COMNT VARCHAR(2000) NULL, PRIORITY NUMBER NULL, CREATOR_HANDLE_STR VARCHAR(500) NULL, CREATE_DT NUMBER NOT NULL, CREATOR VARCHAR(125) NOT NULL, OWNER VARCHAR(125) NULL, IS_OWNER_GRP SMALLINT NULL, LAST_UPDATE_DT NUMBER NULL, LAST_UPDATE_USER VARCHAR(250) NULL, ADMIN_STATE VARCHAR(10) NOT NULL, ERROR_MSG VARCHAR(2000) NULL, WORKING_STATE VARCHAR(10) NOT NULL, CLAIMANT VARCHAR(125) NULL, CURR_STEP_NAME VARCHAR(100) NULL, TASK_COMPLETE_DUE_DT NUMBER NULL, CURR_STEP_CLAIM_DUE_DT NUMBER NULL, CURR_STEP_COMPLETE_DUE_DT NUMBER NULL, CONSTRUCTOR_NAME VARCHAR(100) NOT NULL, FINAL_STEP_NAME VARCHAR(100) NULL, FINAL_ACTION_NAME VARCHAR(100) NULL, TASK_TIME_ESTIMATE VARCHAR(80) NULL );

COMMIT;

CREATE UNIQUE INDEX IWKLR_INFO_TSKID ON WLI_WORKLIST_RPT_INFO (TASK_ID);

COMMIT;

CREATE TABLE WLI_WORKLIST_RPT_PROP
(
TASK_EVENT_ID CHAR(64) NOT NULL,
TASK_ID CHAR(64) NOT NULL,
TASK_PLAN_ID VARCHAR2(255) NOT NULL,
NAME VARCHAR2(100) NOT NULL,
IS_NEW SMALLINT NOT NULL,
STORAGE_FORMAT VARCHAR2(255) NULL,
IS_LARGE SMALLINT NOT NULL,
VALUE VARCHAR2(4000) NULL,
LARGE_VALUE BLOB NULL
);

COMMIT;

CREATE TABLE WLI_WORKLIST_RPT_ACTION ( TASK_EVENT_ID CHAR(64) NOT NULL, TASK_ID CHAR(64) NOT NULL, TASK_PLAN_ID VARCHAR(255) NOT NULL, OLD_STEP_NAME VARCHAR(100) NOT NULL, NEW_STEP_NAME VARCHAR(100) NOT NULL, ACTION_NAME VARCHAR(100) NOT NULL );

COMMIT;

CREATE INDEX IWKLR_ACT_TSKID ON WLI_WORKLIST_RPT_ACTION(TASK_ID);

COMMIT;

drop TABLE WLI_MESSAGE_BROKER_DYNAMIC;

drop TABLE WLI_PROCESS_DOCUMENT;

drop TABLE WLI_PROCESS_DOC_REFERENCE;

drop TABLE WLI_PROCESS_EVENT;

drop TABLE WLI_PROCESS_DEF;

drop TABLE WLI_PROCESS_INSTANCE_INFO;

drop TABLE WLI_PROCESS_TRACKING;

drop TABLE WLI_MT_CONTENT;

drop TABLE WLI_MT_B2B_CONVERSATION;

drop TABLE WLI_MT_B2B_ATTRIBUTE;

drop TABLE WLI_MT_ATTRIBUTE;

drop TABLE WLI_MT_ARCHIVED;

drop TABLE WLI_B2B_ACTIVERUNTIME;

drop table WLI_B2B_MESSAGE_HISTORY;

drop table WLI_B2B_UNIQUE_KEY;

drop table WLI_B2B_ENCODER;

drop table WLI_B2B_DECODER;

drop table WLI_B2B_BUSINESS_PROTOCOL_DEFN;

drop table WLI_B2B_LOGIC_PLUGIN;

drop table WLI_B2B_CONFIGURATION;

drop table WLI_B2B_JAVA_CLASS;

drop table WLI_B2B_PARAMETER;

drop table WLI_TPM_EXTENDED_PROPERTY_SET;

drop table WLI_TPM_XML_ATTRIBUTE;

drop table WLI_TPM_XML_ELEMENT;

drop table WLI_TPM_XPATH;

drop table WLI_TPM_SIGNATURE_TRANSFORMS;

drop table WLI_TPM_EBXML_BINDING;

drop table WLI_TPM_FAILURE_REPORT_ADMIN;

drop table WLI_TPM_FAILURE_NOTIFIER;

drop table WLI_TPM_ROSETTANET_BINDING;

drop table WLI_TPM_ENCRYPTION_CERTIFICATE;

drop table WLI_TPM_SIGNATURE_CERTIFICATE;

drop table WLI_TPM_WEB_SERVICE_BINDING;

drop table WLI_TPM_AUTHENTICATION;

drop table WLI_TPM_TRANSPORT;

drop table WLI_TPM_SERVER_CERTIFICATE;

drop table WLI_TPM_CLIENT_CERTIFICATE;

drop table WLI_TPM_RN_SERVICE_DEFAULTS;

drop table WLI_TPM_SERVICE_PROFILE;

drop table WLI_TPM_SERVICE;

drop table WLI_TPM_TRADING_PARTNER;

drop table WLI_TPM_TRADING_PARTNER_MGMT;

drop TABLE WLI_CACHE_INFO;

drop TABLE WLI_EVENTGEN_STATE;

COMMIT;

drop TABLE WLI_PROCESS_EVENT_ARCH;

drop TABLE WLI_PROCESS_DEF_ARCH;

drop TABLE WLI_DOCUMENT_DATA;

drop TABLE WLI_AR_MT_CONTENT;

drop TABLE WLI_AR_MT_B2B_CONVERSATION;

drop TABLE WLI_AR_MT_B2B_ATTRIBUTE;

drop TABLE WLI_AR_MT_ATTRIBUTE;

COMMIT;

COMMIT;

CREATE TABLE WLI_MESSAGE_BROKER_DYNAMIC(
rule_name VARCHAR(1000) NOT NULL,
subscriber_instance VARCHAR(566) NOT NULL,
filter_value VARCHAR(2000) NULL,
filter_value_null SMALLINT NOT NULL,
hash_id INTEGER NOT NULL,
CONSTRAINT PK_WLI_MESSAGE_BROKER_DYNAMIC PRIMARY KEY(
rule_name, subscriber_instance));

COMMIT;

CREATE INDEX IX_WLI_MESSAGE_BROKER_DYNAMIC ON WLI_MESSAGE_BROKER_DYNAMIC( HASH_ID);

COMMIT;

CREATE INDEX IX_WLI_MB_DYNAMIC_INSTANCE ON WLI_MESSAGE_BROKER_DYNAMIC( SUBSCRIBER_INSTANCE);

COMMIT;

CREATE TABLE WLI_PROCESS_DOCUMENT(
DOCUMENT_ID VARCHAR(64) NOT NULL,
DOCUMENT BLOB NOT NULL,
CONSTRAINT PK_WLI_PROCESS_DOCUMENT PRIMARY KEY(DOCUMENT_ID)) INITRANS 6;

CREATE TABLE WLI_PROCESS_DOC_REFERENCE(
DOCUMENT_ID VARCHAR(64) NOT NULL,
PROCESS_TYPE VARCHAR(200) NOT NULL,
PROCESS_INSTANCE VARCHAR(768) NOT NULL,
REFERENCER_TYPE VARCHAR(16) NOT NULL,
REFERENCER_INSTANCE VARCHAR(64) NOT NULL,
REFERENCE_TIME DATE DEFAULT SYSDATE NOT NULL,
IS_DEAD SMALLINT DEFAULT 0 NOT NULL,
CONSTRAINT PK_WLI_PROCESS_DOC_REFERENCE PRIMARY KEY(
DOCUMENT_ID, PROCESS_TYPE, PROCESS_INSTANCE, REFERENCER_TYPE, REFERENCER_INSTANCE)) INITRANS 6;

COMMIT;

CREATE INDEX IX_WLI_PROCESS_DOC_REFERENCE ON WLI_PROCESS_DOC_REFERENCE( PROCESS_TYPE, PROCESS_INSTANCE, REFERENCER_TYPE, REFERENCER_INSTANCE);

COMMIT;

CREATE TABLE WLI_PROCESS_DEF( PROCESS_TYPE VARCHAR(200) NOT NULL, ACTIVITY_ID SMALLINT NOT NULL, DEPLOYMENT_ID INTEGER NOT NULL, ACTIVITY_TYPE SMALLINT NOT NULL, USER_NODE_NAME VARCHAR(100) NULL, PARENT_ACTIVITY_ID SMALLINT NULL, FLOW_TAG_NAME VARCHAR(60) NULL, CONSTRAINT PK_WLI_PROCESS_DEF PRIMARY KEY( PROCESS_TYPE, ACTIVITY_ID, DEPLOYMENT_ID) );

COMMIT;

ALTER TABLE WLI_PROCESS_DEF ADD CONSTRAINT FK_WLI_PROCESS_DEF FOREIGN KEY( PROCESS_TYPE, PARENT_ACTIVITY_ID, DEPLOYMENT_ID) REFERENCES WLI_PROCESS_DEF( PROCESS_TYPE, ACTIVITY_ID, DEPLOYMENT_ID) ON DELETE CASCADE;

COMMIT;

CREATE TABLE WLI_PROCESS_EVENT(
PROCESS_TYPE VARCHAR(200) NOT NULL,
PROCESS_EVENT_ID VARCHAR(60) NOT NULL,
PROCESS_INSTANCE VARCHAR(768) NOT NULL,
DEPLOYMENT_ID INTEGER NOT NULL,
EVENT_TIME INTEGER NOT NULL,
ACTIVITY_ID SMALLINT NOT NULL,
EVENT_TYPE SMALLINT NOT NULL,
EVENT_DATA BLOB NULL,
PROCESS_LABEL VARCHAR(1000) NULL,
IS_ROLLED_BACK SMALLINT NOT NULL,
EVENT_ELAPSED_TIME NUMBER NULL,
START_EVENT_ID VARCHAR(60) NULL,
EVENT_COUNT INT NULL,
CONSTRAINT PK_WLI_PROCESS_EVENT PRIMARY KEY(
PROCESS_INSTANCE, PROCESS_EVENT_ID)
) INITRANS 6;

COMMIT;

CREATE TABLE WLI_PROCESS_INSTANCE_INFO(
PROCESS_INSTANCE VARCHAR(768) NOT NULL,
PROCESS_TYPE VARCHAR(200) NOT NULL,
PROCESS_LABEL VARCHAR(1000) NULL,
PROCESS_STATUS SMALLINT NOT NULL,
PROCESS_START_TIME NUMBER NOT NULL,
PROCESS_END_TIME NUMBER NULL,
SLA_EXCEED_TIME NUMBER NULL,
SEQUENCE_ID INTEGER NOT NULL,
CONSTRAINT PK_WLI_PROCESS_INSTANCE_INFO PRIMARY KEY(PROCESS_INSTANCE)
) INITRANS 6;

COMMIT;

CREATE INDEX IX_WLI_PROC_INSTANCE_INFO_TS ON WLI_PROCESS_INSTANCE_INFO(PROCESS_TYPE, PROCESS_STATUS);

COMMIT;

CREATE INDEX IX_WLI_PROC_INSTANCE_INFO_ST ON WLI_PROCESS_INSTANCE_INFO(PROCESS_STATUS,PROCESS_END_TIME,PROCESS_INSTANCE);

COMMIT;
CREATE TABLE WLI_PROCESS_TRACKING(
PROCESS_TYPE VARCHAR(200) NULL,
SERIAL_VERSION_UID NUMBER NOT NULL,
DEPLOYMENT_ID INTEGER NOT NULL,
FLOW_LENGTH INTEGER NOT NULL,
FLOW CLOB NOT NULL,
SLA NUMBER NULL,
SLA_WARN_THRESHOLD NUMBER NULL,
CONSTRAINT PK_WLI_PROCESS_TRACKING PRIMARY KEY(PROCESS_TYPE)
) INITRANS 6;

COMMIT;

CREATE TABLE WLI_MT_ATTRIBUTE ( MT_EVENT_ID VARCHAR(64) NOT NULL, PROCESS_TYPE VARCHAR(200) NOT NULL, PROCESS_INSTANCE VARCHAR(768) NOT NULL, EVENT_SOURCE SMALLINT NOT NULL, EVENT_TIME NUMERIC(14) NOT NULL, MSG_SIZE INTEGER NULL, MSG_DIRECTION SMALLINT NULL, MSG_STATUS SMALLINT NOT NULL, MSG_STATUS_DESCRIPTION VARCHAR(4000) NULL, IS_CONTENT_AVAILABLE SMALLINT NOT NULL, CONSTRAINT PK_WLI_MT_ATTRIBUTE PRIMARY KEY(MT_EVENT_ID) );

COMMIT;

CREATE INDEX IX_WLI_MT_ATTRIBUTE ON WLI_MT_ATTRIBUTE(EVENT_TIME);

COMMIT;

CREATE INDEX IX_WLI_MT_ATTRIBUTE_PI ON WLI_MT_ATTRIBUTE(PROCESS_INSTANCE);

COMMIT;

CREATE TABLE WLI_MT_CONTENT (
MT_EVENT_ID VARCHAR(64) NOT NULL,
MSG_PART_ID SMALLINT NOT NULL,
MSG_PART_TYPE SMALLINT NOT NULL,
MSG_PART_HEADER VARCHAR(2000),
MSG_PART_DATA_SIZE INTEGER NULL,
MSG_PART_DATA BLOB NOT NULL,
CONSTRAINT FK_WLI_MT_CONTENT FOREIGN KEY(MT_EVENT_ID)
REFERENCES WLI_MT_ATTRIBUTE(MT_EVENT_ID) ON DELETE CASCADE
);

COMMIT;

CREATE UNIQUE INDEX IX_WLI_MT_CONTENT ON WLI_MT_CONTENT(MT_EVENT_ID, MSG_PART_ID);

COMMIT;

CREATE TABLE WLI_MT_B2B_CONVERSATION ( CONVERSATION_ID VARCHAR(256) NOT NULL, ACTION VARCHAR(128) NULL, TPM_SERVICE VARCHAR(256) NULL, BUSINESS_PROTOCOL VARCHAR(32) NULL, TRANSPORT_PROTOCOL VARCHAR(32) NULL, CONSTRAINT PK_WLI_MT_B2B_CONVERSATION PRIMARY KEY(CONVERSATION_ID) );

COMMIT;

CREATE TABLE WLI_MT_B2B_ATTRIBUTE ( MT_EVENT_ID VARCHAR(64) NOT NULL, MSG_ID VARCHAR(256) NULL, CONVERSATION_ID VARCHAR(256) NULL, FROM_TP_NAME VARCHAR(64) NULL, FROM_ID VARCHAR(64) NULL, TO_TP_NAME VARCHAR(64) NULL, TO_ID VARCHAR(64) NULL, DESTINATION_URI VARCHAR(256) NOT NULL, IS_SIGNED SMALLINT NULL, IS_ENCRYPTED SMALLINT NULL, MSG_HEADER VARCHAR(2000) NULL, REMAINING_RETRIES SMALLINT NULL, REF_MSG_ID VARCHAR(256) NULL, CONSTRAINT PK_WLI_MT_B2B_ATTRIBUTE PRIMARY KEY(MT_EVENT_ID), CONSTRAINT FK_WLI_MT_B2B_ATTRIBUTE FOREIGN KEY(MT_EVENT_ID) REFERENCES WLI_MT_ATTRIBUTE(MT_EVENT_ID) ON DELETE CASCADE );

COMMIT;

CREATE INDEX IX_WLI_MT_B2B_ATTRBUTE_C_ID ON WLI_MT_B2B_ATTRIBUTE(CONVERSATION_ID);

COMMIT;

CREATE TABLE WLI_MT_ARCHIVED ( MT_EVENT_ID VARCHAR(64) NOT NULL, EVENT_TIME NUMERIC(14) NOT NULL, CONSTRAINT PK_WLI_MT_ARCHIVED PRIMARY KEY(MT_EVENT_ID) );

COMMIT;

create table WLI_B2B_ACTIVERUNTIME ( CONVERSATION_ID VARCHAR2(256) NOT NULL, TP_ID VARCHAR2(256) NOT NULL, PROCESS_INSTANCE_ID VARCHAR2(256) NOT NULL, CONTROL_ID VARCHAR2(256) NULL, PROCESS_URI VARCHAR2(256) NULL, CONTROL_TYPE VARCHAR2(256) NULL, UNIQUE (CONVERSATION_ID, TP_ID), UNIQUE (PROCESS_INSTANCE_ID, CONTROL_ID) );

COMMIT;

create table WLI_B2B_MESSAGE_HISTORY ( MESSAGE_ID varchar(254) not null, FROM_ID varchar(254) not null, TO_ID varchar(254) not null, STATUS varchar(32) not null, TIME_TO_LIVE numeric NULL, CONVERSATION_ID varchar(254) not null, TIMESTMP numeric NULL, ACK_TIMESTMP numeric NULL, DIRECTION integer not null, REMAINING_RETRIES integer NULL, UNIQUE (MESSAGE_ID, DIRECTION) );

COMMIT;

create table WLI_B2B_UNIQUE_KEY (VALUE integer not null);

COMMIT;

create table WLI_B2B_CONFIGURATION (ID integer not null primary key, UPDATE_COUNT integer not null, CERTIFICATE_VERIFICATION_CLASS varchar(254) null, AUDIT_LOG_CLASS varchar(254) null, SECURE_TIMESTAMP_CLASS varchar(254) null, PROXY_HOST varchar(80) null, PROXY_PORT varchar(10) null);

COMMIT;

create table WLI_B2B_LOGIC_PLUGIN
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_B2B_CONFIGURATION(ID),
NAME varchar2(254) not null,
DESCRIPTION varchar2(254) null,
NOTES long null,
TYPE number not null,
UNIQUE(NAME, PARENT_ID));

create table WLI_B2B_BUSINESS_PROTOCOL_DEFN
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_B2B_CONFIGURATION(ID),
NAME varchar2(254) not null,
VERSION varchar2(254) not null,
DESCRIPTION varchar2(254) null,
NOTES long null,
UNIQUE(NAME, VERSION, PARENT_ID));

-- WLI_B2B_ENCODER
create table WLI_B2B_ENCODER
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_B2B_BUSINESS_PROTOCOL_DEFN(ID),
LOGIC_PLUGIN_ID number null references WLI_B2B_LOGIC_PLUGIN(ID),
UNIQUE(LOGIC_PLUGIN_ID, PARENT_ID));

-- WLI_B2B_DECODER
create table WLI_B2B_DECODER
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_B2B_BUSINESS_PROTOCOL_DEFN(ID),
LOGIC_PLUGIN_ID number null references WLI_B2B_LOGIC_PLUGIN(ID),
UNIQUE(LOGIC_PLUGIN_ID, PARENT_ID));

COMMIT;

create table WLI_B2B_JAVA_CLASS (ID integer not null primary key, UPDATE_COUNT integer not null, PARENT_ID integer not null, CLASS varchar(254) not null, UNIQUE(CLASS, PARENT_ID));

COMMIT;

create table WLI_B2B_PARAMETER (ID integer not null primary key, UPDATE_COUNT integer not null, PARENT_ID integer not null, NAME varchar(254) not null, VALUE varchar(254) not null, UNIQUE(NAME, PARENT_ID));

COMMIT;

create table WLI_TPM_TRADING_PARTNER_MGMT (ID integer not null primary key, UPDATE_COUNT integer not null, MSG_TRACKING_DEFAULT integer not null, MSG_TRACE integer not null, MSG_TRACE_DIRECTORY varchar(254) null, SECURE_AUDIT_LOGGING integer not null, TEST_MODE integer not null);

COMMIT;

create table WLI_TPM_TRADING_PARTNER
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER_MGMT(ID),
NAME varchar2(254) not null,
DESCRIPTION varchar2(254) null,
NOTES long null,
STATUS number not null,
IS_DEFAULT number not null,
TYPE number not null,
BUSINESS_ID_TYPE varchar2(254) null,
BUSINESS_ID varchar2(254) null,
ADDRESS varchar2(254) null,
EMAIL varchar2(254) null,
PHONE varchar2(254) null,
FAX varchar2(254) null,
USERNAME varchar2(254) null,
UNIQUE(NAME, PARENT_ID));

-- WLI_TPM_EXTENDED_PROPERTY_SET
create table WLI_TPM_EXTENDED_PROPERTY_SET
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
NAME varchar2(254) not null,
DESCRIPTION varchar2(254) null,
NOTES long null,
UNIQUE(NAME, PARENT_ID));

COMMIT;

create table WLI_TPM_XML_ELEMENT (ID integer not null primary key, UPDATE_COUNT integer not null, PARENT_ID integer not null, NAME varchar(254) not null, TEXT varchar(1024) null);

COMMIT;

create table WLI_TPM_XML_ATTRIBUTE
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_XML_ELEMENT(ID),
NAME varchar2(254) not null,
VALUE varchar2(254) not null,
UNIQUE(NAME, PARENT_ID));

COMMIT;

create table WLI_TPM_SERVER_CERTIFICATE
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
NAME varchar2(254) not null,
PASSWORD_ALIAS varchar2(254) null,
UNIQUE(PARENT_ID));

-- WLI_TPM_CLIENT_CERTIFICATE
create table WLI_TPM_CLIENT_CERTIFICATE
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
NAME varchar2(254) not null,
PASSWORD_ALIAS varchar2(254) null,
UNIQUE(NAME, PARENT_ID));

-- WLI_TPM_ENCRYPTION_CERTIFICATE
create table WLI_TPM_ENCRYPTION_CERTIFICATE
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
NAME varchar2(254) not null,
PASSWORD_ALIAS varchar2(254) null,
UNIQUE(NAME, PARENT_ID));

-- WLI_TPM_SIGNATURE_CERTIFICATE
create table WLI_TPM_SIGNATURE_CERTIFICATE
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
NAME varchar2(254) not null,
PASSWORD_ALIAS varchar2(254) null,
UNIQUE(NAME, PARENT_ID));

-- WLI_TPM_EBXML_BINDING
create table WLI_TPM_EBXML_BINDING
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
SIGNATURE_CERT_ID number null references WLI_TPM_SIGNATURE_CERTIFICATE(ID),
NAME varchar2(254) not null,
PROTOCOL_NAME varchar2(254) not null,
PROTOCOL_VERSION varchar2(254) null,
IS_DEFAULT number not null,
IS_SIGNATURE_REQ number not null,
IS_RECEIPT_SIG_REQ number not null,
DELIVERY_SEMANTICS number not null,
RETRIES number null,
RETRY_INTERVAL varchar2(254) null,
PERSIST_DURATION varchar2(254) null,
UNIQUE(NAME, PARENT_ID));

-- WLI_TPM_SIGNATURE_TRANSFORMS
create table WLI_TPM_SIGNATURE_TRANSFORMS
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_EBXML_BINDING(ID),
UNIQUE(PARENT_ID));

-- WLI_TPM_XPATH
create table WLI_TPM_XPATH
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_SIGNATURE_TRANSFORMS(ID),
EXPRESSION varchar2(254) not null);

-- WLI_TPM_ROSETTANET_BINDING
create table WLI_TPM_ROSETTANET_BINDING
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
ENCRYPTION_CERT_ID number null references WLI_TPM_ENCRYPTION_CERTIFICATE(ID),
SIGNATURE_CERT_ID number null references WLI_TPM_SIGNATURE_CERTIFICATE(ID),
NAME varchar2(254) not null,
PROTOCOL_NAME varchar2(254) not null,
PROTOCOL_VERSION varchar2(254) null,
IS_DEFAULT number not null,
IS_SIGNATURE_REQ number not null,
IS_RECEIPT_SIG_REQ number not null,
SIGNATURE_DIGEST_ALGORITHM varchar2(32) not null,
CIPHER_ALGORITHM number not null,
ENCRYPTION_LEVEL number not null,
RETRIES number null,
RETRY_INTERVAL varchar2(254) null,
PROCESS_TIMEOUT varchar2(254) null,
UNIQUE(NAME, PARENT_ID));

-- WLI_TPM_FAILURE_REPORT_ADMIN
create table WLI_TPM_FAILURE_REPORT_ADMIN
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_ROSETTANET_BINDING(ID),
TRADING_PARTNER_ID number null references WLI_TPM_TRADING_PARTNER(ID),
RN_BINDING_ID number null references WLI_TPM_ROSETTANET_BINDING(ID),
UNIQUE(PARENT_ID));

-- WLI_TPM_FAILURE_NOTIFIER
create table WLI_TPM_FAILURE_NOTIFIER
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_ROSETTANET_BINDING(ID),
TRADING_PARTNER_ID number null references WLI_TPM_TRADING_PARTNER(ID),
RN_BINDING_ID number null references WLI_TPM_ROSETTANET_BINDING(ID),
UNIQUE(PARENT_ID));

-- WLI_TPM_WEB_SERVICE_BINDING
create table WLI_TPM_WEB_SERVICE_BINDING
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER(ID),
NAME varchar2(254) not null,
UNIQUE(NAME, PARENT_ID));

COMMIT;

create table WLI_TPM_TRANSPORT (ID integer not null primary key, UPDATE_COUNT integer not null, PARENT_ID integer not null, PROTOCOL integer not null, PROTOCOL_VERSION varchar(254) null, ENDPOINT varchar(254) null, TIMEOUT varchar(254) null, UNIQUE(PARENT_ID));

COMMIT;

create table WLI_TPM_AUTHENTICATION
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRANSPORT(ID),
CLIENT_PARTNER_ID number null references WLI_TPM_TRADING_PARTNER(ID),
CLIENT_CERT_ID number null references WLI_TPM_CLIENT_CERTIFICATE(ID),
SERVER_CERT_ID number null references WLI_TPM_SERVER_CERTIFICATE(ID),
CLIENT_AUTH number not null,
SERVER_AUTH number not null,
USER_NAME varchar2(254) null,
PASSWORD_ALIAS varchar2(254) null,
UNIQUE(CLIENT_PARTNER_ID, PARENT_ID));

COMMIT;

create table WLI_TPM_SERVICE
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_TRADING_PARTNER_MGMT(ID),
NAME varchar2(254) not null,
DESCRIPTION varchar2(254) null,
NOTES long null,
SERVICE_TYPE number not null,
BUSINESS_PROTOCOL number not null,
UNIQUE(NAME, PARENT_ID));

-- WLI_TPM_RN_SERVICE_DEFAULTS
create table WLI_TPM_RN_SERVICE_DEFAULTS
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_SERVICE(ID),
CONTENT_SCHEMA varchar2(254) null,
USE_DTD_VALIDATION number not null,
VALIDATE_CONTENT number not null,
VALIDATE_HEADER number not null,
UNIQUE(PARENT_ID));

-- WLI_TPM_SERVICE_PROFILE
create table WLI_TPM_SERVICE_PROFILE
(ID number not null primary key,
UPDATE_COUNT number not null,
PARENT_ID number not null references WLI_TPM_SERVICE(ID),
LOCAL_PARTNER_ID number null references WLI_TPM_TRADING_PARTNER(ID),
LOCAL_BINDING_ID number null,
EXTERNAL_PARTNER_ID number null references WLI_TPM_TRADING_PARTNER(ID),
EXTERNAL_BINDING_ID number null,
STATUS number not null,
MSG_TRACKING number not null,
SERVICE_PROFILE_ID varchar2(254) null);

-- WLI_CACHE_INFO
CREATE TABLE WLI_CACHE_INFO (
CACHE_NAME VARCHAR(100) NOT NULL,
KEY_ID VARCHAR(800) NOT NULL,
VALUE VARCHAR(4000) NOT NULL,
EXPIRY_TIME NUMBER NOT NULL,
CONSTRAINT PK_WLI_CACHE_INFO PRIMARY KEY(CACHE_NAME,KEY_ID)
);

COMMIT;

CREATE TABLE WLI_EVENTGEN_STATE( EG_NAME VARCHAR(128) NOT NULL, EG_TYPE INTEGER NOT NULL, CHANNEL_ID VARCHAR(64) NOT NULL, LAST_UPDATE_PROCESSED NUMBER NOT NULL, CONSTRAINT PK_WLI_EG_STATE PRIMARY KEY(EG_NAME,EG_TYPE,CHANNEL_ID));

COMMIT;

CREATE TABLE WLI_PROCESS_DEF_ARCH( PROCESS_TYPE VARCHAR(200) NOT NULL, ACTIVITY_ID SMALLINT NOT NULL, DEPLOYMENT_ID INTEGER NOT NULL, ACTIVITY_TYPE SMALLINT NOT NULL, USER_NODE_NAME VARCHAR(100) NULL, PARENT_ACTIVITY_ID SMALLINT NULL, FLOW_TAG_NAME VARCHAR(60) NULL, CONSTRAINT PK_WLI_PROCESS_DEF_ARCH PRIMARY KEY( PROCESS_TYPE, ACTIVITY_ID, DEPLOYMENT_ID) );

ALTER TABLE WLI_PROCESS_DEF_ARCH ADD CONSTRAINT FK_WLI_PROCESS_DEF_ARCH FOREIGN KEY( PROCESS_TYPE, PARENT_ACTIVITY_ID, DEPLOYMENT_ID) REFERENCES WLI_PROCESS_DEF_ARCH( PROCESS_TYPE, ACTIVITY_ID, DEPLOYMENT_ID) ON DELETE CASCADE;

CREATE TABLE WLI_DOCUMENT_DATA(
EVENT_DATA_ID VARCHAR(64) NOT NULL,
TYPE SMALLINT NOT NULL,
DATA BLOB NULL,
CONSTRAINT PK_WLI_DOCUMENT_DATA PRIMARY KEY(EVENT_DATA_ID)
)INITRANS 6;

CREATE TABLE WLI_PROCESS_EVENT_ARCH(
PROCESS_TYPE VARCHAR(200) NOT NULL,
PROCESS_EVENT_ID VARCHAR(60) NOT NULL,
PROCESS_INSTANCE VARCHAR(768) NOT NULL,
DEPLOYMENT_ID INTEGER NOT NULL,
EVENT_TIME INTEGER NOT NULL,
ACTIVITY_ID SMALLINT NOT NULL,
EVENT_TYPE SMALLINT NOT NULL,
EVENT_DATA_ID VARCHAR(64) NULL,
PROCESS_LABEL VARCHAR(1000) NULL,
IS_ROLLED_BACK SMALLINT NOT NULL,
EVENT_ELAPSED_TIME NUMBER NULL,
START_EVENT_ID VARCHAR(60) NULL,
CONSTRAINT PK_WLI_PROCESS_EVENT_ARCH PRIMARY KEY(
PROCESS_INSTANCE, PROCESS_EVENT_ID),
CONSTRAINT FK_WLI_PROCESS_EVENT_DATA_ARCH FOREIGN KEY(EVENT_DATA_ID)
REFERENCES WLI_DOCUMENT_DATA(EVENT_DATA_ID)
) INITRANS 6;

COMMIT;

CREATE TABLE WLI_AR_MT_ATTRIBUTE ( MT_EVENT_ID VARCHAR(64) NOT NULL, PROCESS_TYPE VARCHAR(200) NOT NULL, PROCESS_INSTANCE VARCHAR(768) NOT NULL, EVENT_SOURCE SMALLINT NOT NULL, EVENT_TIME NUMERIC(14) NOT NULL, MSG_SIZE INTEGER NULL, MSG_DIRECTION SMALLINT NULL, MSG_STATUS SMALLINT NOT NULL, MSG_STATUS_DESCRIPTION VARCHAR(4000) NULL, CONSTRAINT PK_WLI_AR_MT_ATTRIBUTE PRIMARY KEY(MT_EVENT_ID) );

COMMIT;

CREATE INDEX IX_WLI_AR_MT_ATTRIBUTE ON WLI_AR_MT_ATTRIBUTE(EVENT_TIME);

COMMIT;

CREATE TABLE WLI_AR_MT_CONTENT ( MT_EVENT_ID VARCHAR(64) NOT NULL, MSG_PART_ID SMALLINT NOT NULL, MSG_PART_TYPE SMALLINT NOT NULL, MSG_PART_HEADER VARCHAR(2000) NULL, MSG_PART_DATA_SIZE INTEGER NULL, MSG_PART_DATA_ID VARCHAR(64) NOT NULL, CONSTRAINT FK_WLI_AR_MT_CONTENT FOREIGN KEY(MT_EVENT_ID) REFERENCES WLI_AR_MT_ATTRIBUTE(MT_EVENT_ID) ON DELETE CASCADE );

COMMIT;

CREATE UNIQUE INDEX IX_WLI_AR_MT_CONTENT ON WLI_AR_MT_CONTENT(MT_EVENT_ID, MSG_PART_ID);

COMMIT;

CREATE TABLE WLI_AR_MT_B2B_CONVERSATION ( CONVERSATION_ID VARCHAR(256) NOT NULL, ACTION VARCHAR(128) NULL, TPM_SERVICE VARCHAR(256) NULL, BUSINESS_PROTOCOL VARCHAR(32) NULL, TRANSPORT_PROTOCOL VARCHAR(32) NULL, CONSTRAINT PK_WLI_AR_MT_B2B_CONVERSATION PRIMARY KEY(CONVERSATION_ID) );

COMMIT;

CREATE TABLE WLI_AR_MT_B2B_ATTRIBUTE ( MT_EVENT_ID VARCHAR(64) NOT NULL, MSG_ID VARCHAR(256) NULL, CONVERSATION_ID VARCHAR(256) NULL, FROM_TP_NAME VARCHAR(64) NULL, FROM_ID VARCHAR(64) NULL, TO_TP_NAME VARCHAR(64) NULL, TO_ID VARCHAR(64) NULL, DESTINATION_URI VARCHAR(256) NOT NULL, IS_SIGNED SMALLINT NULL, IS_ENCRYPTED SMALLINT NULL, MSG_HEADER VARCHAR(2000) NULL, REMAINING_RETRIES SMALLINT NULL, REF_MSG_ID VARCHAR(256) NULL, CONSTRAINT PK_WLI_AR_MT_B2B_ATTRIBUTE PRIMARY KEY(MT_EVENT_ID), CONSTRAINT FK_WLI_AR_MT_B2B_ATTRIBUTE FOREIGN KEY(MT_EVENT_ID) REFERENCES WLI_AR_MT_ATTRIBUTE(MT_EVENT_ID) ON DELETE CASCADE );

COMMIT;