Set Essbase Query Governor Execution Time (v2)

This API sets the Oracle Essbase Query Governor Execution Time (maximum number of seconds that a query can run before the Essbase Server terminates it) for all the Essbase cubes.

The governor value can be set to any value from 0 to 70000.

Required Roles

Service Administrator

REST Resource

PUT /interop/rest/{api_version}/config/services/essbaseqrygovexectime

Request

Supported Media Types: application/json

Table 9-96 Parameters

Name	Description	Type	Required	Default
qryexectime	Query Governor Execution Time Value	Payload	Yes	None

Sample Request Payload

{
  "qryexectime": "<Query_Execution_Time>"
}

Response

Supported Media Types: application/json

Table 9-97 Parameters

Parameters	Description
details	In case of errors, details are published with the error string
status	See Migration Status Codes
links	Detailed information about the link
href	Links to API call
action	The HTTP call type
rel	Can be self and/or Job Status. If set to Job Status, you can use the href to get the status of the import operation
data	Parameters as key value pairs passed in the request

Example of Response Body

{  
  "details": null,  
  "status": 0,  
  "items": null,  
  "links": [  
    {  
      "href": "https://<BASE-URL>/interop/rest/v2/config/services/essbaseqrygovexectime",  
      "action": "PUT",  
      "rel": "self",  
      "data": null  
    }  
  ]  
}  

Sample cURL Command

curl -s -u <USERNAME>:<PASSWORD>-H 'Content-Type: application/json' --request PUT https://<BASE-URL>/interop/rest/v2/config/services/essbaseqrygovexectime -d '{  
  "qryexectime": "<Query_Execution_Time>"  
}'