2 Replies Latest reply on Jan 15, 2016 2:34 AM by cesar.advincula.o

    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

        • 1. Re: Write Back Error :unable to read the Write Back Template
          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

           

          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,

          • 2. Re: Write Back Error :unable to read the Write Back Template
            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.

             

            XMLADVA.png

             

            Kind Regards,