Ideas Marked For Deletion Are Not Being Processed

Products

• Clarity PPM On Premise

Issue/Introduction

The Delete Investments and Time Periods job completes but has Message that fatal error has occurred deleting projects.

The BG log shows:
ERROR 2022-01-19 21:39:26,691 [Dispatch Delete Investments and Time Reporting Periods - Clarity Test 1/19 4:38 PM : bg@clarity-test-cappm-03 (tenant=clarity)] background.DeleteInvestmentService (clarity:admin:session:Delete Investments and Time Reporting Periods - Clarity Test 1/19 4:38 PM)  com.niku.union.persistence.PersistenceException:  SQL error code: 942 Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Executed:

DELETE FROM PRDocument
          WHERE prTableName='PRJ_PROJECTS' AND prRecordID=? 
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="projectPurgePMD.xml" id="projmgr.deleteProjectMSPDocuments" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
  <sql dbVendor="all" tsvTemplateAttrCode="">
    <text>

Cause

The BG log shows that the PRDocument table is missing from the database.

Resolution

Restore the PRDocument table by running the following command on the server:

dbpatch -install -file CLARITY_HOME/database/schema/table/PRDOCUMENT.xml -apply