Hello,
I have Oracle Write Back configured correctly (I Believe). here is a short summary of what I have done:
My design is to always insert into a new table the value of a presentation variable that is created through a dashboard prompt.
My writeBack.xml:
<?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="SytleListInsert">
<XML>
<writeBack connectionPool="MSDE-VDW METADATA CONNECTION">
<insert>INSERT INTO item_list VALUES ('@{cf656474fc275f1ea}','@{ced4b3645f584b425}')</insert>
<update></update>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
The issue is my table item_list is not in BMM or presentation of RPD, as it is used to store data only. Do I need to have table being inserted into created in BMM / Physical layer?
Further, the error I am getting is only in sawlog6.xml, I get no error on screen, or other errors that I can find.
[2016-03-04T10:48:43.000-05:00] [OBIPS] [ERROR:31] [] [saw.views.evc.activate] [ecid: 58ffc888bab8c3fc:365ab964:1532d39465d:-8000-00000000000139de,0:1] [tid: 2231817984] Could not find privilege: [[
File:coprivilegemap.cpp
Line:80
Location:
saw.views.evc.activate
saw.httpserver.processrequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
RptPath: /shared/ItemList/Analysis/Top 10 List Test
SID: 4c9tkk6c8rh5o8ah7cdha2tki2
SessionID: 172.16.100.10.6.6ctrsjk
AuthProps: AuthSchema=UidPwd|PWD=******|UID=weblogic|User=weblogic
ecid: 58ffc888bab8c3fc:365ab964:1532d39465d:-8000-00000000000139de,0:1
ThreadID: 2231817984
HttpCommand: AnswersGetView
RSP: o:viewpreview~r:report
RemoteIP: 172.16.100.10
Privileges are set correctly (I am logged in as weblogic)
| Write Back | Write Back to Database | Authenticated User, BI Administrator Role, BI Author Role, BI Consumer Role, BI System Role, weblogic | | Manage Write Back | Authenticated User, BI Administrator Role, BI Author Role, BI Consumer Role, BI System Role, weblogic |
|
Please let me know what I should try, if possible.
Thank you,
