Error Running Delivered Process For HDL Full Extract in MSQL Platform
(Doc ID 2513413.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When running the delivered process for HDL Full Extract, including Primary data, Worker object data and Salary object data the following error occurs:
File: e:\pt85113b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client
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
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
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 |