Digital WorkPlace : Error Under Catalog Sections In Admin Console Post Upgrade to DWP 1805

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Digital Workplace Basic


    COMPONENT:

    BMC Digital Workplace Basic


    APPLIES TO:

    DWP 1805



    PROBLEM:

    Post Upgrade to Digital WorkPlace 1805 and going to Admin console >> Catalog Sections  Error "Server Encountered an Error" "Further Stable work is not guaranteed" shows
    User-added image


    CAUSE:

    Missing Tables and Columns in DWP Business Schema


    SOLUTION:

    For Database Type Oracle: Tables and Queries To Be Used:
    1. Check if column IMMERSIVE_DISPLAY_TYPE exists or missing in UNIFIED_CATALOG_SECTION table if missing then execute below query to add the same

    ALTER TABLE UNIFIED_CATALOG_SECTION ADD IMMERSIVE_DISPLAY_TYPE VARCHAR2(20) DEFAULT 'REGULAR' NOT NULL;

    2. Check if USER_CONTACT table exists or not, if missing then execute below query to add the table and use alter query below to add records into the same.

    Create Table Query:
    CREATE TABLE USER_CONTACT (PK NUMBER(10) NOT NULL, TENANT_ID VARCHAR2(31) NULL, CREATE_DATE TIMESTAMP NULL, ID VARCHAR2(60) NOT NULL, MODIFIED_DATE TIMESTAMP NULL, CONTACT_SUBTYPE VARCHAR2(50) NOT NULL, CONTACT_TYPE VARCHAR2(50) NOT NULL, VALUE VARCHAR2(2000) NOT NULL, USER_PK NUMBER(10) NOT NULL, PRIMARY KEY (PK)); ALTER TABLE USER_CONTACT ADD CONSTRAINT FK_USER_CONTACT_USER_PK FOREIGN KEY (USER_PK) REFERENCES USER_DETAILS (PK); CREATE SEQUENCE user_contact_pk_gen INCREMENT BY 500 START WITH 1499;

    Adding Record Into the User_Contact Table using Alter command:
    ALTER TABLE USER_CONTACT ADD CONSTRAINT FK_USER_CONTACT_USER_PK FOREIGN KEY (USER_PK) REFERENCES USER_DETAILS (PK); CREATE SEQUENCE user_contact_pk_gen INCREMENT BY 500 START WITH 1499; ALTER TABLE UNIFIED_CATALOG_SECTION ADD IMMERSIVE_DISPLAY_TYPE VARCHAR2(20) DEFAULT 'REGULAR' NOT NULL;

    3. Check if SERVICE_STATUS_HISTORY table exists or not, if missing then execute below query to add the table and use alter query below to add records into the same

    Create Table Query:
    CREATE TABLE SERVICE_STATUS_HISTORY (PK NUMBER(10) NOT NULL, TENANT_ID VARCHAR2(31) NULL, ANNOTATION VARCHAR2(255) NULL, CREATE_DATE TIMESTAMP NULL, ID VARCHAR2(60) NOT NULL, MESSAGE_KEY VARCHAR2(255) NOT NULL, MODIFIED_DATE TIMESTAMP NULL, NEW_STATUS VARCHAR2(30) NOT NULL, OLD_STATUS VARCHAR2(30) NOT NULL, SERVICE_NAME VARCHAR2(255) NULL, SERVICE_PK NUMBER(10) NOT NULL, PRIMARY KEY (PK));

    Adding Record Into the Service_Status_History Table using Alter command:
    ALTER TABLE SERVICE_STATUS_HISTORY ADD CONSTRAINT SERVICE_HIST_ID_TENANT_UQ UNIQUE (ID, TENANT_ID);

    ALTER TABLE SERVICE_STATUS_HISTORY ADD CONSTRAINT SERVICESTATUSHISTORYSERVICE_PK FOREIGN KEY (SERVICE_PK) REFERENCES SERVICE_AVAILABILITY (PK); CREATE SEQUENCE service_status_history_pk_gen START WITH 1000;

    Once queries are executed the error under catalog sections in admin console should be no longer observed
    *****************************************************************************************************************************************************
    For Database Type MS SQL :Tables and Queries To Be Used:
    1. Check if column IMMERSIVE_DISPLAY_TYPE exists or not, if missing in UNIFIED_CATALOG_SECTION table then execute below query to add the same

    ALTER TABLE UNIFIED_CATALOG_SECTION ADD IMMERSIVE_DISPLAY_TYPE NVARCHAR(20) DEFAULT 'REGULAR' NOT NULL;

    2. Check if USER_CONTACT table exists or not if missing then execute below query to add the table and use alter query below to add records into the same.

    Create Table Query:
    CREATE TABLE USER_CONTACT (PK INTEGER IDENTITY NOT NULL, TENANT_ID NVARCHAR(31) NULL, CREATE_DATE DATETIME NULL, ID NVARCHAR(60) NOT NULL, MODIFIED_DATE DATETIME NULL, CONTACT_SUBTYPE NVARCHAR(50) NOT NULL, CONTACT_TYPE NVARCHAR(50) NOT NULL, VALUE NVARCHAR(2000) NOT NULL, USER_PK INTEGER NOT NULL, PRIMARY KEY (PK));

    Adding Record Into the User_Contact Table using Alter command:
    ALTER TABLE USER_CONTACT ADD CONSTRAINT USER_CONTACT_USER_PK FOREIGN KEY (USER_PK) REFERENCES USER_DETAILS (PK);

    3. Check if SERVICE_STATUS_HISTORY table exists or not if missing then execute below query to add the table and use alter query below to add records into the same

    Create Table Query:
    CREATE TABLE SERVICE_STATUS_HISTORY (PK INTEGER IDENTITY NOT NULL, TENANT_ID NVARCHAR(31) NULL, ANNOTATION NVARCHAR(255) NULL, CREATE_DATE DATETIME NULL, ID NVARCHAR(60) NOT NULL, MESSAGE_KEY NVARCHAR(255) NOT NULL, MODIFIED_DATE DATETIME NULL, NEW_STATUS NVARCHAR(30) NOT NULL, OLD_STATUS NVARCHAR(30) NOT NULL, SERVICE_NAME NVARCHAR(255) NULL, SERVICE_PK INTEGER NOT NULL, PRIMARY KEY (PK));

    Adding Record Into the Service_Status_History Table using Alter command:
    ALTER TABLE SERVICE_STATUS_HISTORY ADD CONSTRAINT SERVICE_HIST_ID_TENAN UNIQUE (ID, TENANT_ID);

    ALTER TABLE SERVICE_STATUS_HISTORY ADD CONSTRAINT SRVCSTTUSHISTORYSRVCPK FOREIGN KEY (SERVICE_PK) REFERENCES SERVICE_AVAILABILITY (PK);


     NOTE: If any further errors observed then please check dwp log in DEBUG mode.


    Article Number:

    000370792


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles