My Oracle Support Banner

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.

Goal

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'.
  Statement:
  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
 

Solution

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
Goal
Solution


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.