My Oracle Support Banner

Error Running Delivered Process For HDL Full Extract in MSQL Platform (Doc ID 2513413.1)

Last updated on NOVEMBER 15, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Other

When running delivered process for HDL Full Extract, including Master data, Worker object data and Salary object data the following error occurs:


ERROR
-----------------------
PeopleTools 8.51.13 - Application Engine Server
Copyright (c) 1988-2018 Oracle and/or its affiliates.
All Rights Reserved

PSAESRV started service request at 16.10.28 2018-10-01

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
-----------------------
The issue can be reproduced at will with the following steps:
1. Run delivered process HDL Full Extract, including Master 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.