Hi Experts,
I am trying to enable writeback on My DEV environment for the first time. I have create a small table with two columns and trying to update one of those two columns.
My writeback XML file is below:
<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
<WebMessage name="TestUpdate">
<XML>
<writeBack connectionPool="cmapd">
<insert></insert>
<update>UPDATE DBO.TEST SET Emp_Name = 'c3dcd95040c4544be' WHERE Emp_Id= c2d8ed9a0b466207b</update>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
and i followed all the steps one by one in the link: Srinivasan Software Solutions Pvt.Ltd.: [OBIEE 11g] Write Back Setup
But i keep on getting the same error whatever i do: 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.
excerpt below from Saw.log file.
[2014-06-04T13:33:10.000-04:00] [OBIPS] [ERROR:31] [] [saw.writeback.execute] [ecid: ca1dba83703f26d9:-6474a898:14667eeb855:-8000-0000000000000052,0:1] [tid: 5876] Could not find privilege: [[
File:coprivilegemap.cpp
Line:80
Location:
saw.writeback.execute
saw.httpserver.processrequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
SessionID: kue65aftdboh7k5ram212l0ompaf42bosnn5ig2
AuthProps: AuthSchema=UidPwd|PWD=******|UID=weblogic|User=weblogic
ecid: ca1dba83703f26d9:-6474a898:14667eeb855:-8000-0000000000000052,0:1
ThreadID: 5876
HttpCommand: WriteBack
RemoteIP: 10.7.140.179
]]
[2014-06-04T13:33:10.000-04:00] [OBIPS] [ERROR:16] [] [saw.writeback.action.executeimpl] [ecid: ca1dba83703f26d9:-6474a898:14667eeb855:-8000-0000000000000052,0:1] [tid: 5876] EXECUTE PHYSICAL CONNECTION POOL cmapd UPDATE DBO.TEST SET Emp_Name = 'Swami' WHERE Emp_Id= 2[[
File:writebackaction.cpp
Line:885
Location:
saw.writeback.action.executeimpl
saw.writeback.action.execute
saw.writeback.execute
saw.httpserver.processrequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
SessionID: kue65aftdboh7k5ram212l0ompaf42bosnn5ig2
AuthProps: AuthSchema=UidPwd|PWD=******|UID=weblogic|User=weblogic
ecid: ca1dba83703f26d9:-6474a898:14667eeb855:-8000-0000000000000052,0:1
ThreadID: 5876
HttpCommand: WriteBack
RemoteIP: 10.7.140.179
]]
[2014-06-04T13:33:10.000-04:00] [OBIPS] [ERROR:16] [] [saw.writeback.action.executeimpl] [ecid: ca1dba83703f26d9:-6474a898:14667eeb855:-8000-0000000000000052,0:1] [tid: 5876] 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.\r\n
Any help is highly appreciated to resolve this.
Thanks
Swami