Clarity PPM failure with ORA-32794

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When upgrading Clarity/ installing a Clarity patch/ using Clarity/ we see the error ORA-32794: cannot drop a system-generated sequence

Environment

Release: Any

Cause

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

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'
3. After the tables are dropped the sequences created by these identity columns are still not removed. You can check using the below query.
   
   select object_name from dba_objects where owner='<clarity schema name>' and upper(object_name) like 'ISEQ%';
4. In this case as your DBA to run "purge dba_recyclebin" to and check with the above query. If you have a PDB then run it on the container level and PDB level as well.
5. 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)
6. Disable it based on that.

Note: The customizations, identity columns, and database replication tools are unsupported in Clarity.