Summary
Missing views after importing a Lab Project .qcp file
Question
When importing the ALM 'Lab Project' from a .qcp file the db/schema views are missing
Answer
It is possible to export/import a Lab Project to/from a .qcp file by adding the following Site Configuration parameter...
Param Name: SHOW_LAB_PROJECT
Param Value: Y (N is Default)
Because the import mechanism in ALM treats the lab project structure as a standard project the views in the db/schema will be missing.
To correct this issue use the queries in the attached: LabProject_DropCreate_Views.zip
The aforementioned .zip file contains queries for both MSSQL and Oracle.
It is recommended to first use the 'drop' statements to eliminate duplicate or malformed views
Then use the 'create' statements to create the expected views