My Oracle Support Banner

E-MSS: Create Views Script fails to generate complete SQL on MS SQL Server (Doc ID 2438499.1)

Last updated on OCTOBER 30, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.56 [Release 8.4]
Information in this document applies to any platform.

Symptoms

On : PeopleSoft 9.2 version, Campus Solutions installation

When running the Data Mover import for create Views, the following error occurs.

ERROR
-------
SQL Error. Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'AS'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.