E-PUM: Invalid Column Name 'ROWNUM' In Update Manager Dashboard
(Doc ID 2124155.1)
Last updated on APRIL 26, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
Why when navigating to the Update Manager Dashboard in our MSS Demo environment do we get the following?
Return: 0 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'ROWNUM'.
Original Statement: BEGIN INSERT INTO PS_PTIAUSERTGTSELS(USERID, DBNAME) SELECT 'PS', DBNAME FROM PS_PTIASPUSERTGTS WHERE USERID ='PS' AND ROWNUM=1 ORDER BY DBNAME ASC; END;
PSAPPSRV.5340 (5674) [2016-03-23T07:08:12.143 PS@10.20.105.164 (IE 11.0; WIN7) ICPanel] xFlTUvFcarL+8A - PS (0) SQL Error in Compile. (2,277) PTIA_MD.Controllers.MDPagesHandler.OnExecute Name:PreBuild PCPC:1391 Statement:32
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|