SQL Server Specific: Error During PUM 23 Upgrade On Step "Run Post Data Conversion AE - PODC23636172" (Doc ID 2295062.1)

Last updated on AUGUST 08, 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

Error during PUM 23 Upgrade on step "Run Post Data Conversion AE - PODC23636172"

While applying full PUM 23 to our environment (All updates not yet applied), We received an error on the step: Run Post Data Conversion AE - PODC23636172

It appears that an update statement is being called and the alias is trying to be assigned on the update statement but SQL does not allow this.

From the error:
  UPDATE PS_PTPN_TBE_CFG_2 PN
  SET PTPN_ENABLE = 'N'
  ...

But for SQL it should be:
  UPDATE PN
  SET PTPN_ENABLE = 'N'
  ...
  FROM PS_PTPN_TBE_CFG_2 PN


ERROR


opleTools 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 'PN'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt: UPDATE PS_PTPN_TBE_CFG_2 PN SET PTPN_ENABLE = 'N' WHERE EXISTS ( SELECT 1 FROM PSEVENTDEFN E WHERE PN.PTPN_ACTIVITYNAME = E.ACTIVITYNAME AND PN.PTPN_EVENTNAME1 = E.EVENTNAME AND E.ACTIVE = 0)
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 'PN'.

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt: UPDATE PS_PTPN_TBE_CFG_2 PN SET PTPN_ENABLE = 'N' WHERE EXISTS ( SELECT 1 FROM PSEVENTDEFN E WHERE PN.PTPN_ACTIVITYNAME = E.ACTIVITYNAME AND PN.PTPN_EVENTNAME1 = E.EVENTN (200,0)
Process 670433 ABENDED at Step PODC23636172.TBEDATA.UpdFlg2 (SQL) -- RC = 8601 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 670433 ABENDED at Step PODC23636172.TBEDATA.UpdFlg2 (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