My Oracle Support Banner

OBIEE 12c: UNABLE TO SET QUERY GOVERNOR Max Query Time as 1 in RPD (Doc ID 2258764.1)

Last updated on JUNE 15, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Open RPD in admin tool and navigate to  manage --> Identity--> Application Roles --> select role --> Permissions --> Query Limits --> Max Time (minutes)

set query max time limit as 1 , it throws error as below

"Please enter an integer between 1 and 2147483647" 

here , minimum value that can be set is 2 , where as in 11g , users could set this value to 1 .

Changes

In OBIEE 11g , Max Run Time can be set as 1 but  same is giving error in 12c

Trying to set Query limit as 1 minute as per Metadata Repository Builder's Guide https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-3FD454F0-EBE3-4094-8ECB-F6F02F99267C.htm#GUID-7456FDDA-AAD8-45DC-B4EE-BAD49E7D73A2

section: Limiting Queries By Maximum Run Time and Restricting to Particular Time Periods

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.