My Oracle Support Banner

E-MSS: Data Mover UPD28702779 Error During PUM 34 (Doc ID 2626883.1)

Last updated on JANUARY 07, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.

Symptoms

Data Mover UPD28702779 Error during PUM 34 using CA on tools 8.57.xx

SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'A'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
DELETE FROM PSPTSF_ATTRS A WHERE NOT EXISTS (SELECT 'X' FROM PSPTSF_SD_ATTR B WHERE B.PTSF_SRCATTR_NAME=A.PTSF_SRCATTR_NAME)
Error: SQL execute error for DELETE FROM PSPTSF_ATTRS A WHERE NOT EXISTS (SELECT 'X' FROM PSPTSF_SD_ATTR B WHERE B.PTSF_SRCATTR_NAME=A.PTSF_SRCATTR_NAME)
Ended: Fri Dec 27 14:56:09 2019
Unsuccessful completion






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.