Missing views after importing a Lab Project .qcp file

  • KM03694219
  • 26-Aug-2020
  • 26-Aug-2020

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