My Oracle Support Banner

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.

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


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


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