Tablespace error ORA-00959: tablespace 'XXXXXXXX' does not exist

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Clarity Upgrade fails with error:

2/23/22 5:02  (ExecTask)  New Index (create):  DWH_FIN_TRANSACTION_U3 ( CLARITY_TRANSACTION_KEY )
2/23/22 5:02  (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00959: tablespace 'XXXXXXXXX' does not exist
2/23/22 5:02  (ExecTask)
2/23/22 5:02  (ExecTask)     at com.ca.clarity.jdbc.oraclebase.dde3.l(Unknown Source)
2/23/22 5:02  (ExecTask)     at com.ca.clarity.jdbc.oraclebase.dde3.a(Unknown Source)
2/23/22 5:02  (ExecTask)     at com.ca.clarity.jdbc.oraclebase.dde3.executeBatch(Unknown Source)
2/23/22 5:02  (ExecTask)     at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:2746)
2/23/22 5:02  (ExecTask)     at com.niku.dbtools.DriverApp.apply(DriverApp.java:1478)
2/23/22 5:02  (ExecTask)     at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:705)
2/23/22 5:02  (ExecTask)     at com.niku.dbtools.Utilities.run(Utilities.java:1865)
2/23/22 5:02  (ExecTask)     at com.niku.dbtools.Utilities.main(Utilities.java:979)

This may happen on different tables

Environment

Release : Any

Resolution

1. Rollback Clarity and the database

2. Make sure all the tablespaces in CSA / properties.xml are correct and existing in the database

3. Restart the upgrade again.

Additional Information

If the issue happens during a non upgrade activity, such as running a job:

1. Run the following query to find out the tablespaces associated with the Clarity or Clarity DWH database
   select distinct owner, tablespace_name
   from all_tables 
   where owner like '%EXAMPLE%' 
2. With DBA, ensure the tablespaces are created correctly
3. Ensure the tablespaces are entered correctly in properties.xml