SQL Server Specific: Error Received During PUM 23 Upgrade On Step "Run Data Conversion AE - DC25906443" (Doc ID 2294089.1)

Last updated on OCTOBER 23, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, HR Upgrade
SQL Server Specific


Error received during PUM 23 upgrade on step "Run Data Conversion AE - DC25906443"

While attempting to apply full PUM 23 to an environment that currently has full PUM 21 installed fails at the step "Run Data Conversion AE - DC25906443".

It appears the update statement was not written with proper SQL syntax. 


MSSQL/SSMS does not allow this syntax
  UPDATE PS_DEP_BENEF_ARG A

It has to be
  UPDATE A
  SET ….
  FROM PS_DEP_BENEF_ARG A

Syntax looks to be Oracle database Specific.

ERROR

PeopleTools 8.55.15 - Application Engine
Copyright (c) 1988-2017 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near 'A'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near
Failed SQL stmt: UPDATE PS_DEP_BENEF_ARG A SET A.INC_TAX_ENDDT_ARG = ( SELECT DATEADD(YEAR, 18, B.BIRTHDATE) FROM PS_DEP_BEN B WHERE B.EMPLID = A.EMPLID AND B.DEPENDENT_BENEF = A.DEPENDENT_BENEF) WHERE A.EFFDT IN ( SELECT D.EFFDT FROM PS_DEP_BEN_EFF D WHERE D.EMPLID = A.EMPLID AND D.DEPENDENT_BENEF = A.DEPENDENT_BENEF AND D.DISABLED = 'N' AND D.EFFDT >= '2017-01-01') AND A.INC_TAX_DEPEN_ARG = 'C'

Message Set Number: 200
Message Number: 0
Message Reason: File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near 'A'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near
Failed SQL stmt: UPDATE PS_DEP_BENEF_ARG A SET A.INC_TAX_ENDDT_ARG = ( SELECT DATEADD(YEAR, 18, B.BIRTHDATE) FROM PS_DEP_BEN B (200,0)
Process 670136 ABENDED at Step DC25906443.MAIN.Upd2017 (SQL) -- RC = 8601 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 670136 ABENDED at Step DC25906443.MAIN.Upd2017 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms