Description
Please increase the DEFAULT_DB_MAX_EXEC_TIME to at least 30 minutes so that our reports can run successfully in the Cloud. Currently, DEFAULT_DB_MAX_EXEC_TIME = 10 minutes, and are reports are failing with 'execeeded time limit' error.
We also noticed that most of our reports are running longer in the cloud than they do in on-prem OBIEE.
Use Case and Business Need
We have over 200 reports that calculate measures around sales,cost,units etc and perform a year over year comparison. The reports have a direct impact on our revenue, sales margin estimates for our business.
Since the reports are erroring in OAC, this means we will have to look for alternative reporting elsewhere so our business executives can get the KPI's that they need to make informed business decisions.
Our business execs have already expressed hesitation in going live with the OAC migration until this is fixed.
If we break down the report into smaller pieces, it is taking almost an hour to run and piece the report back together, time of which our executives don't have.
More details
We have noticed that time series measures (such as qtd, wtd, ytd etc) are taking longer time to execute as compared to on-prem OBIEE. Which has led to time-out errors because of the 10 min threshold value.
These findings have already been demosntrated in SR#: 3-23087944661 discussion phase.
Original Idea Number: 550dc5c643
