Incorrect Syntax Error Message Shows Up When Publishing the Data View Inside Unifier

(Doc ID 2338178.1)

Last updated on DECEMBER 12, 2017

Applies to:

Primavera Unifier - Version 15.2.0.0 and later
Primavera Unifier Cloud Service - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms


Incorrect syntax error message shows up when publishing the data view inside Unifier.

The query works well in SQL management Studio, while it does not work inside Unifier.

ERROR
-----------------------
Incorrect syntax near 1151


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Login to Unifier
  2. Navigate to the Company Workspace in Admin mode > Data Structure Setup > Data Views
  3. Create a new Data View and Publish it
  4. Notice the error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot publish the date view in Unifier.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms