1 Reply Latest reply on Mar 7, 2016 6:05 PM by Felipe_Idalgo

    Write Back Error

    ElieAintabi

      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,