Native Reporting - SQL Server - Malformed query in Data Providers when TSV fields are used

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce:

1. Make sure that 'Include SQL Curves' is set to True at Classic UI > System Options. Run a full load of the Load Data Warehouse job after it is set to True
2. Navigate to Modern UX > Reporting
3. Create a new Data Provider
4. In the 'Objects' tab pull in the 'Resource' object
5. Go to 'Preview' tab. Display 'Full Name' and 'Actuals' TSV

Expected Results:

• Both these fields are displayed in the 'Preview'

Actual Results:

• This results in the following error:
  
  • Incorrect syntax near the keyword 'from'

Environment

• Clarity 16.3.3
• SQL Server DB.

Cause

DE185063

Resolution

Use the workaround mentioned in Article 408829.