OBIEE 12c: Direct Database Request Configuration (nQSError: 13017)
Direct Database Request is the ability to execute SQL statements directly against the data warehouse. DDR skips BI Server and execute the physical SQL statemente every time you open an Answer or a Dashboard. Consequwntly DDR don’t use all BI Server features like Cache Management.
I use DDR when the report requirement cannot be represented into a data model, or when is very expensive the design of a data model for a simple report.
To allow access to DDR, from the OBIEE Administration link, you can enable Direct Database Requests for each role, within the “Manage Privileges” Section:
After applying the above security privilege, the user is still unable to execute a direct database request:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 13017] User or application role has not been granted the Direct Database Access privilege to access the database. Please verify the User/Group Permissions in the Oracle BI Administration Tool.Please have your System Administrator look at the log for more details on this error. (HY000)
Please have your System Administrator look at the log for more details on this error.
Now, access to Administration Tool and select Manage -> Identity -> Application Roles Tab -> Permissions
Note that by default “Execute Direct Database Requests” is set to ignore. Set the permission to “allow” to grant user role the ability to run a direct database request against a specific subject area.
