Incorrect syntax near '|' Error Received When Trying to Publish Data View in Microsoft SQL Server
Last updated on JUNE 30, 2017
Applies to:Primavera Unifier - Version 184.108.40.206 and later
Primavera Unifier Cloud Service - Version 220.127.116.11 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.
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