This discussion is archived
2 Replies Latest reply: Jan 23, 2013 10:21 PM by Satya Ranki Reddy RSS

Custom Error Messages for Write Back

SriramKarthik Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points