My Oracle Support Banner

Run Data Conversion AE DCGL32909825 Step Fails With SQL Server Incorrect Syntax While Applying PUM40 (Doc ID 2814030.1)

Last updated on OCTOBER 13, 2021

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On MS SQL Server database, while upgrading to 9.2 PUM 40 on PT 8.58.12 when running Data Conversion AE - DCGL32909825 step it is getting incorrect syntax error shown below -

ERROR
File: e:\pt858p12b_2105190501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1738 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'SELECT'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: INSERT INTO PS_PV_ATT_DB_SRV( SELECT * FROM PSFILE_ATTDET X WHERE X.ATTACHSYSFILENAME NOT IN ( SELECT Y.ATTACHSYSFILENAME FROM PS_PV_ATT_DB_SRV Y) AND EXISTS( SELECT 'X' FROM PS_GLRN_RECON_ATTA YY WHERE X. ATTACHSYSFILENAME = YY.ATTACHSYSFILENAME))

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt858p12b_2105190501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1738 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'SELECT'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: INSERT INTO PS_PV_ATT_DB_SRV( SELECT * FROM PSFILE_ATTDET (200,0)
Process 1837768 ABENDED at Step DCGL32909825.MAIN.Step01 (SQL) -- RC = 8601 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 1837768 ABENDED at Step DCGL32909825.MAIN.Step01 (SQL) -- RC = 8601 (108,524)

STEPS:
The issue can be reproduced at will with the following steps:
1. Run CA Job to update PUM 26 to 40 on PT 8.58.12
2. Run Data Conversion AE - DCGL32909825
3. Observe error

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


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