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

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"

Environment

Release : All

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Cause

This can be due to an issue in the uncompressing step

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