Error Running Delivered Process For HDL Full Extract in MSQL Platform
(Doc ID 2513413.1)
Last updated on JUNE 22, 2022
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
When running the delivered process for HDL Full Extract, including Primary data, Worker object data and Salary object data the following error occurs:
10.0][SQL Server]Incorrect syntax near 'A'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '+'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. (S
Failed SQL stmt:UPDATE PS_FH_JOBCLN_TAO7 A SET A.EFFSEQ = A.EFFSEQ + ( SELECT COUNT(*) FROM PS_FH_JOBCLN_TAO7 A1 WHERE A1.EMPLID = 'XXXXX' AND A1.EMPL_RCD
= 0 AND A1.EFFDT = '2016-12-16' AND A1.EFFSEQ >= 0 AND A1.PROCESS_INSTANCE = xxxxxxx) + 1 WHERE A.EMPLID = 'XXXXX' AND A.EMPL_RCD = 0 AND A.EFFDT =
DATEADD(DAY, 1, '2016-12-16') AND A.PROCESS_INSTANCE = xxxxxxx
Process xxxxxxx ABENDED at Step FH_JOBXFM_BL.CMPCHTE2.Step02 (SQL) -- RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESVR completed service request at 16.10.43 2018-10-01
Steps to reproduce the issue:
1. Run delivered process HDL Full Extract, including Primary data, Worker object data and Salary object data
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