Missing views after importing a Lab Project .qcp file

  • KM03694219R
  • 26-Aug-2020
  • 26-Aug-2020

This document is under revision.


Missing views after importing a Lab Project .qcp file


When importing the ALM 'Lab Project' from a .qcp file the db/schema views are missing


It is possible to export/import a Lab Project to/from a .qcp file by adding the following Site Configuration parameter...

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