Summary
Error
And there is nothing display in the Analysis view page:
Once the user try to create any object, they will get the following error:
If the user check the QC log file, they might find the following error message:
Failed to fetch data from ANALYSIS_ITEM_FOLDERS; [Mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist Failed SQL: /* ~~QC */ SELECT AIF_DESCRIPTION,AIF_ID,AIF_LOGICAL_NAME,AIF_NAME,A
Cause
Mostly the issue happens in the following circumstance:
1. When we copy the huge project from SQL server to Oracle, if during the DB data copy there is any error occur, the copy task will stop. But after we correct the error, ALM provide a feature that we can recover the copy. If we recover the copy, the project will be created as well
2. Incorrect Owner ship of the tables (In case of SQl server)
3. If it is oracle , the user has no enough object permissions.
The root cause for this issue is somehow the following views in DB for analysis view was not copied correctly to the new project DB or they are missing:
VF_ANALYSIS_ITEM_FOLDERS
VF_ANALYSIS_ITEMS
In such situation verify and repair tool might be not able to fix the issue.
Fix
CREATE OR REPLACE FORCE VIEW "<Schema/DB name >"."VF_ANALYSIS_ITEM_FOLDERS" ("VF_AIF_ID", "AIF_PUBLIC") AS SELECT ANALYSIS_ITEM_FOLDERS.AIF_ID AS VF_AIF_ID, ANALYSIS_SEGMENTS.AS_IS_PUBLIC AS AIF_PUBLIC FROM ANALYSIS_ITEM_FOLDERS INNER JOIN ANALYSIS_SEGMENTS ON ANALYSIS_ITEM_FOLDERS.AIF_SEGMENT_ID = ANALYSIS_SEGMENTS.AS_ID;
CREATE OR REPLACE FORCE VIEW "<Schema/DB name >"."VF_ANALYSIS_ITEMS" ("VF_AI_ID", "AI_PUBLIC") AS SELECT ANALYSIS_ITEMS.AI_ID AS VF_AI_ID, ANALYSIS_SEGMENTS.AS_IS_PUBLIC AS AI_PUBLIC FROM ANALYSIS_ITEMS INNER JOIN ANALYSIS_SEGMENTS ON ANALYSIS_ITEMS.AI_SEGMENT_ID = ANALYSIS_SEGMENTS.AS_ID;