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 and later
Primavera Unifier Cloud Service - Version and later
Information in this document applies to any platform.


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.

Incorrect syntax near 1151

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

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


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