search cancel

Load Dataware House and Update Report Tables job fail with "[SQLServer]Incorrect syntax near '$.s’" after refresh

book

Article ID: 243602

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

DWH and Update Report Tables job are failing after refresh from prod.

Environment

Release : 16.0.0

Component : PPMARC

Cause

This is Caused by mismatch in compatibility levels between source and target databases.

Resolution

The compatibility was changed to 150 on the Target database which is same Compatibility level as Source database.