Write Back Error :unable to read the Write Back Template

2804071

Hello

I'm trying to create a report that perform  Writeback (update field ).

I built it step by step according to  instructions.

When I try to update in the report, I get the message:

The system is unable to read the Write Back Template 'testwriteback'. Please contact your system administrator

the "Write Back Template" saved in file with name  "writebacktemplate.xml"

the location of writebacktemplate.xml file is :

...\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\customMessages

A few important points:

I didn't find folder with name "customMessages" . I created it myself!

I work with version: 11.1.1.7.140715

The content of the XML file is:

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

<XML>

<writeBack connectionPool="SxCx">

<insert></insert>

<update>

UPDATE O_P_GROUPS SET GRP_ID='@2' WHERE CLT_ID='@1'

</update>

</writeBack>

</XML>

</WebMessage>

</WebMessageTable>

</WebMessageTables>

</WebMessageTable>

</WebMessageTables>

I looked  for solution in the WEB and according to everything I saw I was doing exactly what it should be. The issue of the filename and file location is not clear to me. There are several options

Thank in advance

Yochai

cesar.advincula.o

Hello Yochai,

First you have to go inside your OS where the Oracle BI EE is installed:

1- Go to this path

<OracleBIInstance>/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages

2- Inside this you have to create a XML file. What the name? whatever do you want, but the file should has the .XML extension.

THE XML FILE SHOULD BE HAS THIS STRUCTURE

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

      <XML>

         <writeBack connectionPool="CONNECTION_POOL_PHYSICAL_LAYER">

            <insert></insert>

            <update>UPDATE FCT_ADM_RESTRICCIONES SET RESTR_PEND=@{c4e556929cb7c403b}, RESTR_TOT=@{c1a1f6213b0196921} where PERIODO_ID=@{ca14d3644ae6c1c5b} and PROYECTO_COD='@{c16055791cde24448}' and EMPRESA_COD='@{c575cf897bec518f1}'</update>

         </writeBack>

      </XML>

   </WebMessage>

</WebMessageTable>

</WebMessageTables>

3- You have to check WRITEABLE, Go to the BMM, go to the LOGICAL TABLE.LOGICAL COLUMN double clic

4. Go to the BI Answers, column Properties, check the WriteBack

5. Go to the table property.

  <WebMessage name="TEMPLATE_NAME">

      <XML>

         <writeBack connectionPool="CONNECTION_POOL_PHYSICAL_LAYER">

            <insert></insert>

            <update>UPDATE FCT_ADM_RESTRICCIONES SET RESTR_PEND=@{c4e556929cb7c403b}, RESTR_TOT=@{c1a1f6213b0196921} where PERIODO_ID=@{ca14d3644ae6c1c5b} and PROYECTO_COD='@{c16055791cde24448}' and EMPRESA_COD='@{c575cf897bec518f1}'</update>

         </writeBack>

      </XML>

   </WebMessage>

Kind Regards,

cesar.advincula.o

Please, you have to keep in mind these:

1. You only apply WRITEBACK to TABLE (VIEW)

2. When you use, your XML TEMPLATE WRITEBACK, you should consider:

-   FOR CHAR DATA TYPE    : '@{column_id}'

-   FOR NUMBER DATA TYPE: @{column_id}

3. I strongly recommend the using of COLUMN_ID.

    Because if you use @1 or @2 sintaxys, if you move the column you move also the value of you column.

Kind Regards,