For more information, please refer to this announcement explaining best practices for getting answers to questions.
change sql query timeout
Summary:
Content (required):
Hi team,
we need to increase sql query timeout. We saw from some service requests (https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=363384310697855&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2797848.1&_afrWindowMode=0&_adf.ctrl-state=kytz7ngm_4) that it's possibile form xmlpserver administration> properties > xql query timeout. The option is defaulted at 600 seconds and it should be modifiable to administrators.
However it's not modifiable to me, i created a Bi Administrator Role as i read in this documentation (https://docs.oracle.com/en/cloud/saas/sales/facaa/bi-administrator-permissions.html#s20060433) but it's still not modifiable. Can someone help please?
Version (include the version you are using, if applicable):