search cancel

ORA-31693: Table data object failed to load/unload in Import Logs

book

Article ID: 202078

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We're seeing the below errors in the import logs after importing / restoring our Clarity PPM Database:

ORA-31693: Table data object "PPM"."ODF_CA_COP_PRJ_STATUSRPT" failed to load/unload and is being skipped due to error:
ORA-31644: unable to position to block number 652079 in dump file "/.../backup_06.dmp"

Cause

This can be due to an issue in the uncompressing step

Environment

Release : All

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

  1. Uncompress the file that has the error again (In the above example, file: backup_06.dmp)
  2. Check to validate that the uncompressed file size is now at the expected size.
  3. One that is validated, reimport file.

Additional Information

Searching for known Clarity Issues using Self Service