Abend at DCSP14277802.MAIN.Step01 (SQL) -- RC = 8601 (108,524) in SQL Server (Doc ID 1921565.1)

Last updated on DECEMBER 13, 2016

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 Services Procurement, Upgrade

Receiving the following abend during application of PUM 9.2.08 when running on Microsoft SQL Server

ABENDED at Step DCSP14277802.MAIN.Step01 (SQL) -- RC = 8601 (108,524)


ERROR
-----------------------
PeopleTools 8.53.14 - Application Engine
Copyright (c) 1988-2014 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85314b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 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 37000) 8180
Failed SQL stmt: UPDATE PS_SPF_REQ_LINE A SET A.ENGAGEMENT_MNGR= A.REQUESTOR_ID WHERE A.ENGAGEMENT_MNGR = ' '
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt85314b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 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 37000) 8180
Failed SQL stmt: UPDATE PS_SPF_REQ_LINE A SET A.ENGAGEMENT_MNGR= A.REQUESTOR_ID WHERE A.ENGAGEMENT_MNGR = ' ' (200,0)
Process 17586 ABENDED at Step DCSP14277802.MAIN.Step01 (SQL) -- RC = 8601 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 17586 ABENDED at Step DCSP14277802.MAIN.Step01 (SQL) -- RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

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