After a database refresh, we are not able to see data in the Clarity application. My user has full administration rights
Release : All Supported Clarity releases
Component : CA PPM INTEGRATIONS & INSTALLATIONS
Contact the DBA and ask them to review the import log. Ideally they should be doing after each refresh before providing the environment.
1. During database refresh of Clarity database, an error is thrown in the import log:
ORA-31693: Table data object "NIKU"."PRJ_RESOURCES" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39779: type "NIKU"."NK_CURVE" not found or conversion to latest version is not possible
This is not a Clarity issue, probably an Oracle version mismatch. Check out the below Oracle KB:
See if this helps the DBA identify the issue.
If there is still an issue, please ask them to raise a case with Oracle Support to investigate further.
2. ORA-00942: table or view does not exist when browsing in Clarity on multiple tables after refresh, indicates problems with the refresh.
This is not a Clarity product issue and ideally an Oracle Support case should be raised if the problems persist.