OBIEE 11g - Users Without BI Administrator Role Cannot Write Back with Error "An error occurred while writing to the server."
Last updated on SEPTEMBER 19, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 126.96.36.199.12 and later
Information in this document applies to any platform.
Though users with BIAdministrator role can write back, users without BIAdministrator role cannot write back with the following error on the screen:
An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator.
The following error is logged in nqserver.log:
[nQSError: 13017] User or application role has not been granted the Direct Database Access privilege to access the database 'orcl SH'. Please verify the User/Group Permissions in the Oracle BI Administration Tool.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms