Oracle Analytics Cloud and Server

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

Writeback Error

Question
1
Views
0
Comments
Rank 3 - Community Apprentice

Hi,

I am using OBIEE 12.1.2.1 and implementinh writeback, I have followed the steps to configure as outlined below

https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6F16F7CA-E525-4569-A5A0-C1C0F851F57E.htm#BIESG9156

When attempting to insert a record in the analysis I get the following error

The system is unable to read the write back temple 'xyz'. please contact your administrator

I stored a copy of the file in the following both directories

/apps/oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/msgdb/l_en

/apps/oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/components/OBIPS/custommessages

Below is XML template content

<?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="Load123">

      <XML>

         <writeBack connectionPool="54321">

            <insert>INSERT INTO 123 VALUES('@{c1}','@{c2}')</insert>

         </writeBack>

      </XML>

   </WebMessage>

</WebMessageTable>

</WebMessageTables>

Welcome!

It looks like you're new here. Sign in or register to get started.