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

Symptoms

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.


ERROR
-----------------------
Incorrect syntax near '|'


STEPS
-----------------------
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.

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