Clarity PPM - Load Data Warehouse job truncates tables

book

Article ID: 143851

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse job that is provided out of the box, with Clarity PPM, to transform and load data into the DWH, comes with two modes - Full load and incremental load. While running the Full Load of the job, all tables except the following are truncated. The tables truncated will include even custom defined ones.

CMN_DB_HISTORY
DWH_CFG_SETTINGS
DWH_SEC_GROUP_HIER
DWH_SEC_USER_GROUP
DWH_META_COLUMNS
DWH_CMN_ERROR_MSG_HISTORY
CMN_DWH_INSTALL_HISTORY
DWH_SEC_ASSIGN_PERM
DWH_SEC_PERM_ELEMENT
DWH_SEC_RES_INST_SECURITY
DWH_OBJ_TSV_VIEW_MAPPING
DWH_INTERNAL_MD
DWH_SEC_ASSIGN_RIGHT
DWH_SEC_RIGHT
DWH_ODATA_OBJECTS
DWH_CFG_SETTINGS_HISTORY
DWH_CFG_LOG
DWH_SEC_GLOBAL_RIGHT
DWH_SEC_UNIT_BY_MODE
DWH_META_TABLES
DWH_CFG_AUDIT_HISTORY
PRCOUNTER
DWH_SEC_GROUP
DWH_SEC_USER

In addition to the above mentioned tables, those tables that start with DWH_TRD are also excluded from truncation.

Cause

The logic for this functionality is defined in DWH_CFG_PRE_CONFIG_SP.

Environment

Latest Version Tested: 15.7.1

Resolution

Do not place any custom defined tables in the DWH schema.