Clarity install.log contains message the following object(s) are invalid, SYS_PLSQL_1345803_89_1, SYS_PLSQL_57128_96_1 and SYS_PLSQL_24528_89_1

book

Article ID: 37710

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

Problem:

Clarity install.log reports few database objects as invalid during Clarity installation:

 

<Please see attached file for image>

77574a.png

 This happens only when CA PPM is running on Oracle and the database schema name is not called niku.

 Steps to Reproduce:

  1. Complete an install to CA PPM 14.2 or upgrade from Clarity 14.1 running on Oracle where the Clarity database schema name is not niku.
  2. Once the upgrade/install completes review the install.log
  3. Optional step run the command "admin db compile"

Expected Result: There will be no objects marked as invalid

Actual Result: Following object(s) are invalid, SYS_PLSQL_1345803_89_1, SYS_PLSQL_57128_96_1 and SYS_PLSQL_24528_89_1

Environment:

Clarity 14.2 with Oracle as the database

Cause:

This issue is caused by CLRT-77574 and is currently in review with our development team

Workaround:

Recreate the objects using the SQL syntax below with the correct schema name, changing from NIKU:

create or replace TYPE "SYS_PLSQL_1345803_89_1" as table of NIKU."SYS_PLSQL_1345803_50_1";

create or replace TYPE "SYS_PLSQL_24528_89_1" as table of NIKU."SYS_PLSQL_24528_50_1";

create or replace TYPE "SYS_PLSQL_57128_96_1" as table of NIKU."SYS_PLSQL_57128_50_1";

 

Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component:

Attachments

1558723738800000037710_sktwi1f5rjvs16wzb.png get_app