Clarity PPM failure with ORA-32794
search cancel

Clarity PPM failure with ORA-32794


Article ID: 107736


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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


Release: Any


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


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.