Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Write Back Error :unable to read the Write Back Template

Received Response
1
Views
2
Comments
2804071
2804071 Rank 3 - Community Apprentice
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

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

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    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

    Writeable.png

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

    EnableWrite.png

    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>

    TABLEPROPER.png

    Kind Regards,

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    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.

    XMLADVA.png

    Kind Regards,