Instructions for clean installation of Unica Platform

About this task

To clean install Unica Platform version 12.1, complete the following steps.

Procedure

  1. Run version 12.1 installer with Manual DB and Manual Configuration option. Ensure that you provide reference to OneDB jar in jdbc classpath while installation. After installation is complete, the file system must get populated.
  2. Run the database scripts on the database created in the previous step in the following sequence.
    • <Platform_home>/db/ManagerSchema_informix.sql
    • <Platform_home>/db/ManagerSchema_informix_CreateFKConstraints.sql
    • <Platform_home>/db/active_portlets.sql
    • <Platform_home>/db/notification_rules.sql
    • <Platform_home>/db/quartz_informix.sql
    • <Platform_home>/db/Corrrection _Script.sql
  3. Execute the following scripts.
    CREATE TABLE USM_COUNT_QUEUE
    (
      ID BIGSERIAL, 
      PRODUCT BIGINT NOT NULL, 
      DATE_ADDED DATETIME YEAR TO FRACTION(3), 
      ADDED_COUNTS BIGINT NOT NULL, 
      PARTITION_NAME LVARCHAR(600),
      FEATURE_NAME NVARCHAR(255), 
      AUDITED INT DEFAULT 0
    ) extent size 32 next size 32 lock mode row;
    
    CREATE INDEX IX_USM_COUNT_QUEUE ON USM_COUNT_QUEUE (ID);
    drop table USM_COUNT_AUDIT;
    CREATE TABLE USM_COUNT_AUDIT
    (
      ID BIGSERIAL, 
      DATE_ADDED DATETIME YEAR TO FRACTION(3), 
      INTERACT BIGINT NOT NULL, 
      MKT_OPR BIGINT NOT NULL, 
      MKT_OPR_ENTR BIGINT NOT NULL, 
      CAMPAIGN BIGINT NOT NULL, 
      CNT_OPT BIGINT NOT NULL, 
      PLATFORM BIGINT NOT NULL,
      DELIVER BIGINT NOT NULL, 
      JOURNEY BIGINT NOT NULL, 
      LINK_CONNECTOR BIGINT NOT NULL, 
      ENT_DETAILS CLOB
    ) extent size 32 next size 32 lock mode row;
    CREATE INDEX IX_USM_COUNT_AUDIT ON USM_COUNT_AUDIT (ID);
    drop table USM_CAMPAIGN_PART_COUNT;
    CREATE TABLE USM_CAMPAIGN_PART_COUNT
    (
      ID BIGINT NOT NULL, 
      PRODUCT BIGINT NOT NULL,
      PARTITION_NAME BIGINT NOT NULL, 
      UPDATED_ON DATETIME YEAR TO FRACTION(3) NOT NULL, 
      LAST_COUNT BIGINT NOT NULL,
      PRIMARY KEY  (ID)
    ) extent size 32 next size 32 lock mode row;
    CREATE SEQUENCE USM_CAMPAIGN_PART_COUNT_SEQ START WITH 1 INCREMENT BY 1;
    DROP TABLE USM_NOTIFICATION_RULE;
    drop TABLE USM_CLIENT_DETAILS;
    CREATE TABLE USM_CLIENT_DETAILS
    (
      APPL_NAME LVARCHAR(256) NOT NULL, 
      CLIENT_ID INT NOT NULL, 
      CLIENT_SECRET LVARCHAR(256) NOT NULL
    ) extent size 32 next size 32 lock mode row;
    
    CREATE UNIQUE INDEX IX_USM_CLIENT_DETAILS_APP ON USM_CLIENT_DETAILS (APPL_NAME asc);
    CREATE TABLE USM_NOTIFICATION_RULE
    (
      ID BIGSERIAL, 
      NAME NVARCHAR(120) NOT NULL, 
      TYPE INT NOT NULL, 
      data LVARCHAR(1035)
    ) extent size 32 next size 32 lock mode row;
    CREATE SEQUENCE USM_NOTIFICATION_RULE_SEQ START WITH 1 INCREMENT BY 1;
    CREATE UNIQUE INDEX IX_USM_NOTIFICATION_RULE ON USM_NOTIFICATION_RULE (NAME asc);
    alter table USM_CAMPAIGN_PART_COUNT modify partition_name LVARCHAR(1024) not null;
    alter table USM_CAMPAIGN_PART_COUNT modify id BIGSERIAL;
  4. Run installer with manual database using automatic configuration option.