Writeback issue

vai

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 [ ]

cesar.advincula.o

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?

nm.Mani

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

vai

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.

cesar.advincula.o

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.

vai

we are using external tables for authentication.