ORA-02354/ORA-01466/ORA-31693 errors exporting schema

Products

• Clarity PPM On Premise

Issue/Introduction

After upgrading to 15.9.0+, this error is displayed when trying to export the Clarity schema:

"xxx"."TEMP_NBI_GET_RATES_AND_COSTS" failed to lo ad/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed
ORA-31693: Table data object "xxx"."TEMP_TS_REQUEST_STATUS" failed to load/unload error

Environment

Any On Premise Clarity 15.9.0 (or newer) using Oracle.

Cause

A new feature introduced in Clarity 15.9.0 is using these TEMP_xxx tables to display additional information related to Time Slicing -->  New Administration Portlets

Time Slicing normally runs very often and these could interfere with the expdp command.

Resolution

Option 1:

If you are not using this functionality and you do not want to stop Time Slicing or Clarity services when doing exports, this new functionality can be disabled.

To disable:

BEGIN
CMN_FEATURE_TOGGLE_SP('TSV_LOGGING', '0');
END;

COMMIT

To re-enable:

BEGIN
CMN_FEATURE_TOGGLE_SP('TSV_LOGGING', '1');
END;

COMMIT

 

Option 2:

Pause/disable Time Slicing job during the schema export.

 

Option 3:

Stop Clarity services during the schema export (RECOMMENDED)

Additional Information

• Note that as per Support recommendations, only cold backups are supported. If a cold backup is used this issue will be avoided altogether
• Cold backups are taken with Clarity app services down
• For more information check Hot/cold backups for Clarity on a lower environment