Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Writeback issue

I tried to implement writeback feature using below link on OBIEE 11.1.1.7, but i am getting error when trying to hit on Apply button.
Link -
OBIEE: Write Back Setting in OBIEE 11G http://obieetutorialguide.blogspot.in/2015/04/write-back-setting-in-obiee-11g.html
I checked the bi server diagnostic logs and found below error message , but i am unable to get the exact error details with the below error log -
[2017-01-25T19:15:30.765+05:30] [bi_server1] [ERROR] [OWS-04115] [oracle.webservices.service] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 39156269eea85b2d:-379deb64:15979291141:-8000-0000000000d9414a,0:1:1:6:1] [APP: bisecurity#11.1.1] An error occurred for port: {http://oracle/bi/security/}SecurityWebServicePort: oracle.webservices.provider.ProviderException: javax.xml.ws.WebServiceException: BI Security Service Access Denied - credentials supplied in SOAP Message header failed authentication.
[2017-01-25T19:15:30.877+05:30] [bi_server1] [WARNING] [OBI-SEC-00046] [oracle.bi.security.service] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 39156269eea85b2d:-379deb64:15979291141:-8000-0000000000d9414a,0:1:1:6:19] [APP: bisecurity#11.1.1] [J2EE_APP.name: bisecurity_11.1.1] [J2EE_MODULE.name: bisecurity] [WEBSERVICE.name: SecurityWebService] [WEBSERVICE_PORT.name: SecurityWebServicePort] Invalid external roles [ ]
Answers
-
It looks like access security, Did you check the Administration privileges? Go inside Oracle BI Analytics -> Administration -> Manage Privilage -> WriteBack?
Did you check the permissions to allow "Execute Direct Request to Database" in your the connection pool?
Go inside AdminTool -> Menu -> Identity -> Your Application Role -> Permissions -> Query Limits -> Execute Direct Database Request -> Allow?
0 -
Hi Vai
The log says - BI Security Service Access Denied - credentials supplied in SOAP Message header failed authentication.
There could be 2 reasons,
1. you do not have access to the database
2. not configured correctly
try this,
Write Back Functionality in OBIEE ClearPeaks Blog
Thanks
MM
0 -
Thanks for the info Cesar & Mani
I have enabled and scrutinized all the options provided by you.
But still i am facing the same issue and getiing same error messages in logs.
0 -
Does this user use and LDAP or SQL Authentication Provider?
[userId: <anonymous>] [ecid: 39156269eea85b2d:-379deb64:15979291141:-8000-0000000000d9414a,0:1:1:6:1] [APP: bisecurity#11.1.1] An error occurred for port: {http://oracle/bi/security/}SecurityWebServicePort: oracle.webservices.provider.ProviderException: javax.xml.ws.WebServiceException: BI Security Service Access Denied - credentials supplied in SOAP Message header failed authentication.
0 -
we are using external tables for authentication.
0