Data Source View Missing Definition on Process

Author: Kepion Product Team

Symptom

Application deployment fails at the Process step, and you receive the error message: “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 a compatibility level set to 140.

Resolution

1. To troubleshoot, open SQL Server Management Studio and connect to your server.

2. Select New Query.

3. To determine your database’s compatibility level, copy and paste the following SQL script in the query.

SELECT name, compatibility_level FROM sys.databases;

4. Select Execute and verify the results. 

5. Run the following SQL script to lower the compatibility of your target database one level down:

ALTER DATABASE [<APP_DATABASE_NAME>]
SET COMPATIBILITY_LEVEL = 130