2 Replies Latest reply: Jan 24, 2013 12:21 AM by Satya Ranki Reddy RSS

    Custom Error Messages for Write Back

    SriramKarthik
      Hi All,

      In Write Back, we will get an error message saying that 'An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator'. Can we customize this message of our own? Is there a way by modifying it in any file?

      Please let me know on this.

      Edited by: SwapnaPrerana on Jan 24, 2013 12:22 AM
        • 1. Re: Custom Error Messages for Write Back
          Srini VEERAVALLI
          Check section Section: 19.8.3.2 at link
          http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/answersconfigset.htm#i1018283

          'analyticsRes' directory might help you...

          If you are thru with this share the steps
          • 2. Re: Custom Error Messages for Write Back
            Satya Ranki Reddy
            Hi,

            http://gerardnico.com/wiki/dat/obiee/write_back -- recheck your configuration following this link step by step with screen shots.

            Note : The Problem Occurred two ways,

            1. Problem your XMl Script

            2. If null value not present in your columns in your table in database.The ; problem has occured.

            please check below steps.

            1. Are you using OCI or ODBC in your connection pool? Try it with OCI Call Interface 11g.

            2.Remove the commit tag from the XML file.
            <postUpdate>COMMIT</postUpdate>

            =============================================================================================================
            This xml file working for me.

            Insert--

            A couple of small adjustments got your XML to work here:

            <?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="WriteBack">
            <XML>
            <writeBack connectionPool="Connection Pool">
            <insert> INSERT INTO FACT (PRICE,PRODUCT_KEY,REGION_KEY,SALE_UNIT,TIMEKEY,SALES_QUOTA)
            values (@{c7},@{c8},@{c9},@{c10},@{c11},@{c5} ) </insert>
            <update> </update>
            </writeBack>
            </XML>
            </WebMessage>
            </WebMessageTable>
            </WebMessageTables>

            The <writeBack> tag is written with a lower case "w".
            The "connetionPool" needs an upper case "P".

            Update--


            I think that you have to specify also an SQL statement for the update tag, for example:

            <?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="pmet_update">
            <XML>
            <writeBack connectionPool="PMTCOG">
            <insert> select null from dual</insert>
            <update> UPDATE XREF_PMET_URL SET URL= '@{c1}' WHERE API='@{c0}'</update>
            </writeBack>
            </XML>
            </WebMessage>
            </WebMessageTable>
            </WebMessageTables>
            The witeback wants for both the tags (<insert></insert> and <update></update>) an SQL Statement.

            Hope this help's

            Thanks
            Satya