PPM patch install fails with error: ORA-32794: cannot drop a system-generated sequence (Oracle)

book

Article ID: 107736

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

When installing a patch on PPM it fails with error such as below (could be on a different update statement):
 
BEGIN
      update CMN_OPTION_VALUES
      set VALUE = REPLACE(VALUE, '*=(.*?)', '*(=|(=))(.*?)')
      where OPTION_ID = (select ID from CMN_OPTIONS where OPTION_CODE = 'CMN.XSS.PATTERNS')
      and VALUE like '%*=(.*?)';
    END;
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-32794: cannot drop a system-generated sequence
ORA-06512: at line 54
 

Cause

The issue is usually caused by a database customization - identity columns on Oracle database.
 

Environment

Release: MSPPPM99000-15.5-PPM-Core License-MSP
Component:

Resolution

To resolve the issue, work closely with your DBA.

1. Make sure the affected table does not have any custom triggers. If yes, drop them.

2. Find out whether identity columns are enabled
 
select *
from all_tab_columns
where identity_column ='YES'
 
Then see with the DBA which tables and columns they're associated with and find what other code is manipulating them. (It would probably be some DBA auditing tool or replication tool).
Then see how to disable it based on that.
 
The customizations, identity columns, and database replication tools are unsupported.