E-PUM: Invalid Column Name 'ROWNUM' In Update Manager Dashboard (Doc ID 2124155.1)

Last updated on MARCH 09, 2017

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

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