Data Conversion App Engine DCPO36842673 Process Abends at Step DCPO36842673.MAIN.Step001 (SQL) -- RC = 8601 (108,524) Stmt #: 1851 Error Position: 0 Return: 8601 SQL Server Incorrect syntax near 'E'
(Doc ID 3076794.1)
Last updated on MARCH 16, 2025
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When applying PUM 52 or later data conversion App Engine DCPO36842673 process abends with error:
Error specific to MSSQL:
File: C:\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1851 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver for SQL Server][SQL Server]Incorrect syntax near 'E'.
[Microsoft][ODBC Driver for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: DELETE FROM PS_PO_PO_ATTCH E WHERE EXISTS (SELECT 1 FROM PS_PO_COMMENTS A WHERE E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.PO_ID = A.PO_ID AND E.SCM_ATTACH_ID = A.SCM_ATTACH_ID)
Message Set Number: 200
Message Number: 0
Message Reason: File: C:\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1851 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver for SQL Server][SQL Server]Incorrect syntax near 'E'.
[Microsoft][ODBC Driver for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: DELETE FROM PS_PO_PO_ATTCH E WHERE EXISTS (SELECT 1 FROM PS_PO_COMMENTS A WHERE E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.PO_ID = A.PO_ID AND E.SCM_ATTACH_ID = A (200,0)
Process xxxxxxx ABENDED at Step DCPO36842673.MAIN.Step001 (SQL) -- RC = 8601 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 3841762 ABENDED at Step DCPO36842673.MAIN.Step001 (SQL) -- RC = 8601 (108,524)
Steps to Reproduce Issue:
Install PUM 52 or later with Change Assistant.
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 |
| References |