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
Write Back Error

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)
|
Please let me know what I should try, if possible.
Thank you,
Answers
-
Hi,
Open your RPD online, go to Menu > Identity > Double-Click on Administration Role and then go to privilegies and set this role (or user if you want) to "allow directly database requests".
Try once again
Hope this help
Felipe Idalgo
0