Upgrade fails with ORA-02002: error while writing to audit trail

book

Article ID: 198497

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

8/11/20 8:31 PM (ExecTask) Loading registered objects for data warehouse attributes bootstrap...

8/11/20 8:31 PM (ExecTask) Total bootstrap time: 0H:1M:29.929S

8/11/20 8:31 PM (ExecTask) Bootstrap time breakdown:

8/11/20 8:31 PM (ExecTask) Exception in thread "main" com.niku.union.persistence.PersistenceException:

8/11/20 8:31 PM (ExecTask) SQL error code: 2002

8/11/20 8:31 PM (ExecTask) Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-02002: error while writing to audit trail

8/11/20 8:31 PM (ExecTask) ORA-00942: table or view does not exist

8/11/20 8:31 PM (ExecTask) ORA-06512: at "CLRTY.CMN_GET_SEQUENCE_FCT", line 6

8/11/20 8:31 PM (ExecTask) ORA-06512: at "CLRTY.CMN_ID_SP", line 26

8/11/20 8:31 PM (ExecTask) ORA-06512: at line 1

 

Environment

Release : Upgrading from earlier release than 15.4

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

Have you created a DWH database and added to the properties and System settings in Clarity?

 

If not, please do the following:

  1. Rollback both Clarity files and the database to previous version. Also ask the DBA to restore a blank DWH backup from Clarity files /database/backups.
  2. Bring it up, ensure it works
  3. Connect to CSA, enter connection details to the Data Warehouse
  4. Enter DB LINK name, click Save twice
  5. Connect to Clarity, go to Administration - System Settings, enter entity, language English for Data Warehouse Settings, Save
  6. Now run the Load Data Warehouse job - Full until completion

Once done, go with our previously established steps:

  1. Remove all services
  2. Ensure nothing is accessing the Clarity folder (close all windows possible and all CMD)
  3. Stop the antivirus and granting folder level access to the drive where Clarity is