ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ORA-32794: cannot drop a system-generated sequence

book

Article ID: 107736

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

Cause

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

Environment

Release: Any

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. 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)
  4. Disable it based on that.

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