search cancel

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

book

Article ID: 214885

calendar_today

Updated On:

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

Cause

A new feature introduced in Clarity 15.9.0 is using these TEMP_xxx tables to display additional information related to Time Slicing:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-9-0/release-information/clarity-ppm-release-notes.html > New Administration Portlets

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

Environment

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

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 reenable:

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