Write Back Error — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Write Back Error

Received Response
11
Views
1
Comments
ElieAintabi
ElieAintabi Rank 1 - Community Starter

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 BackWrite Back to DatabaseAuthenticated User, BI Administrator Role, BI Author Role, BI Consumer Role, BI System Role, weblogic
Manage Write BackAuthenticated 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,

Answers

  • Felipe_Idalgo
    Felipe_Idalgo Rank 5 - Community Champion

    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