OBIEE 12c: UNABLE TO SET QUERY GOVERNOR Max Query Time as 1 in RPD
Last updated on JUNE 15, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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 .
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
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