Data Source View Missing Definition on Process

Author: Kepion Product Team

Symptom

The deployment of an application fails at the process step:

“Errors in the high-level relational engine. The data source view does not contain a definition for the ‘V_…’ table or view. The Source property may not have been set.”

This issue may occur when using a database with compatibility level set to 140.

Resolution

To determine your database’s compatibility level, use the following SQL script:

SELECT name, compatibility_level FROM sys.databases;

We recommend setting the compatibility to one level down by using the following:

ALTER DATABASE [<APP_DATABASE_NAME>]
SET COMPATIBILITY_LEVEL = 130