11 Replies Latest reply on Sep 1, 2015 6:49 AM by Saro

    Writeback Updation is not working

    Saro

      Hi friends,

       

      Im in OBIEE 11.1.1.7. Im performing the writeback operation to update the data in the DWH.

       

      I have done all the steps by following the oracle metalink doc note:

      OBIEE 11g:How To Configure Write Back In OBIEE 11g In Analysis and Dashboard? (Doc ID 1435698.1)

       

      OBIEE11: Error: "The system is unable to read the Write Back Template 'writeback'. Please contact your system administrator" when using Write Back (Doc ID 1593885.1)

      This is my writeback template update operation in the writebacktemplate.xml

       

      <WebMessage name="wb_ledger">

      <XML>

      <writeBack connectionPool="Oracle Data Warehouse Connection Pool">

      <insert>SELECT NULL FROM DUAL</insert>

      <update>UPDATE W_LEDGER_D SET LEDGER_NAME='@{c68e02cfa19257a47}' WHERE LEDGER_CATEGORY_CODE='@{cea433c0681d6ad6e}'

      commit</update>

      </writeBack>

      </XML>

      </WebMessage>

       

      But now if i update any value and hit save changes then the report refreshes and the updation is not happening. On each time of my update the report is getting refreshed and reverting to the oriiginal value. Hence im not facing any writeback error. But the only thing is that the updation is not working.

       

      Im getting message like updates were successful, but it is not updating.

       

      What could be the reason for this issue.

       

      Thanks in advance.

       

      Regards,

      Saro

        • 1. Re: Writeback Updation is not working
          Felipe_Idalgo

          Hi,

           

          Remove your commit from code (tag <update> ) and add that using the following tag after <update> tag

           

          <postUpdate>COMMIT</postUpdate>


          For example:


          <WebMessage name="wb_ledger">

          <XML>

          <writeBack connectionPool="Oracle Data Warehouse Connection Pool">

          <insert>SELECT NULL FROM DUAL</insert>

          <update>UPDATE W_LEDGER_D SET LEDGER_NAME='@{c68e02cfa19257a47}' WHERE LEDGER_CATEGORY_CODE='@{cea433c0681d6ad6e}'</update>

          <postUpdate>COMMIT</postUpdate>

          </writeBack>

          </XML>

          </WebMessage>


          Mark right if help you


          Felipe Idalgo

          1 person found this helpful
          • 2. Re: Re: Writeback Updation is not working
            Saro

            Hi felipe,

             

            Thanks for the reply. If i though add commit into the code like you said, im expecting the same behaviour

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

            <XML>

            <writeBack connectionPool="Oracle Data Warehouse Connection Pool">

            <insert>SELECT NULL FROM DUAL</insert>

            <update>

            UPDATE W_LEDGER_D SET LEDGER_NAME='@{c68e02cfa19257a47}' WHERE LEDGER_CATEGORY_CODE='@{cea433c0681d6ad6e}'</update>

            <postUpdate>COMMIT</postUpdate>

            </writeBack>

            </XML>

            </WebMessage>

            </WebMessageTable>

            </WebMessageTables>

             

             

             

            it says updation is successful but the updation is not happening as the report refreshes and retains with the original values only.

             

            Does im missing something here!!!

             

            Regards,

            Saro

            • 3. Re: Writeback Updation is not working
              Saro

              Hi Felipe,

               

              One more thing is that i couldnt find writebacktemplate.xml file defaultly in the path, so i downloaded the writebacktemplate file from the below MOS note

               

              OBIEE 11g:How To Configure Write Back In OBIEE 11g In Analysis and Dashboard? (Doc ID 1435698.1)

               

              And moved that template after adding my update stmt with it. Is my writeback problem is because of that?

               

              Also i make sure of following all the steps from the below oracle doc, but then too the updation is not working, as the report is getting refreshed and updation is not happening and inturn it is not giving any error.

               

              Is this could be a bug with 11.1.1.7.0 (Build 130322.1000.5 64-bit)?

               

              https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/answersconfigset.htm#BIESG1354

               

              Regards,

              Saro

              • 4. Re: Writeback Updation is not working
                Saro

                Hi friends,

                 

                We can see the message "Updated successfully" for a moment; the analysis refreshes and returns so that the modified value is no longer updated in the report and it showing the old value only.

                 

                Regards,

                Saro

                • 5. Re: Writeback Updation is not working
                  Felipe_Idalgo

                  HI Saro,

                   

                  If you see directly in your database Can You see value modified?

                   

                  If so, you cannot see modified value in your report 'cause you´re hitting values by OBI cache. For that you must purge your cache.

                   

                  Felipe Idalgo

                  1 person found this helpful
                  • 6. Re: Writeback Updation is not working
                    Saro

                    Hi Felipe,

                     

                    Thanks again for the reply.

                     

                    Nope it is not changing in the database once after my update in the BI(as in bi itself the updation is not happening, as the report refreshes back with original value)

                     

                    Regards,

                    Saro

                    • 7. Re: Writeback Updation is not working
                      Felipe_Idalgo

                      Hi Saro,

                       

                      1) Did you check if your user has update privilege in your DB? User from your Connection Pool

                       

                      2) Verify if your logical columns (that must be updated) is set to "write"  (Logical Layer from your RPD)

                       

                      3) Verify if user that you´re using to update has privilege to "Read" and "Write" on this column (Presentation Layer)

                       

                      Please post BI Server logs about this transaction

                       

                      Tks

                       

                      Felipe Idalgo

                      1 person found this helpful
                      • 8. Re: Writeback Updation is not working
                        Saro

                        Hi Felipe,

                         

                        Thanks for the reply again.

                         

                        1) Did you check if your user has update privilege in your DB? User from your Connection Pool

                        >> Yes i have the user read/write privilege under the permission of the DB Connection Pool

                         

                        2) Verify if your logical columns (that must be updated) is set to "write"  (Logical Layer from your RPD)

                        >> Yes i have the writeable option been enabled for the logical column in the RPD

                         

                        3) Verify if user that you´re using to update has privilege to "Read" and "Write" on this column (Presentation Layer)

                        >. Yes i have read/write privilege for those presentation column and presentation table.

                         

                        Please post BI Server logs about this transaction

                        >> From the nqserver.log i found the below message like

                         

                        [nQSError: 27022] Unresolved Connection Pool object: "BSC".
                        [nQSError: 43113] Message returned from OBIS.

                         

                        Is that i missed any?

                         

                        Regards,

                        Saro

                        • 9. Re: Writeback Updation is not working
                          Saro

                          Dear Felipe,

                           

                          i have done the same steps in my TEST Env and the updation is working fine and i can update those values. But not sure what is wrong with the PROD environment.

                           

                          Thanks for your replies and views. Closing this thread;-)

                           

                          Regards,

                          Saro

                          • 10. Re: Writeback Updation is not working
                            Felipe_Idalgo

                            Hi Saro,

                             

                            Verify your connection pool name from your repository (looking for blank spaces, etc...)

                             

                            This name must match to the physical layer

                            <writeBack connectionPool="Oracle Data Warehouse Connection Pool">


                            Felipe Idalgo

                            • 11. Re: Writeback Updation is not working
                              Saro

                              Hi Felipe,

                               

                              I verified that it is same.

                               

                              Regards,

                              Saro