My Oracle Support Banner

Incorrect syntax near '|' Error Received When Trying to Publish Data View in Microsoft SQL Server (Doc ID 2282187.1)

Last updated on JUNE 30, 2017

Applies to:

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


Customer has installed Unifier Project Controls with Microsoft SQL Server 2012 SP2, which is certified with it as per tested configuration.
When trying to publishing the Data View "AP_Daily_Reports", error received, this happen to several Data Views and we are not able to create production bundle.

Incorrect syntax near '|'

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

1. Locate the issued Data View

2. Try to publish the Data View (change the status to Published)

3. Alert type error received.


To view full details, 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 a vibrant support community of peers and Oracle experts.