Changing the Essbase Query Timeout Setting

If you're receiving an error along the lines of the following, it is likely because your query governor setting is too low --

Error executing query Error internal JAPI

Error:[Cannot perform cube view operation ESSbase Error(1024016): Request [xxxx] from user [xxxx] was terminated since it exceeded the time limit

To fix this, navigate to the location of your Essbase configuration file (essbase.cfg) on your Essbase server.

For Windows, the path is:
X:\Oracle\Middleware\user_projects\epmsystem#\EssbaseServer\essbaseserver#\bin

Open the file in a text editor and modify the value of setting QRYGOVEXECTIME to be the number of seconds to allow before the query times out.

Note: You must stop and start the Essbase services for this change to take effect.

---

Here is a link to another post that covers the topic fairly well.