3 Replies Latest reply: Jun 17, 2013 3:18 AM by ReddyG RSS

    Write Back Error : The system was unable to generate appropriate SQL. Please contact your system administrator.

    hzyadeh

      Hi,

       

      I am struggling with the write back function in OBIEE 11.1.1.7 and do not know what I am doing wrong. I went all the posted messages and could not find any hint there.

      I am just trying to update a column in  simple table  and get always the following error:

       

      Template: 'UPDATE RGBU.LOCATION SET square_m=@{c2} WHERE LOCATION_NAME='@{c1}' and COUNTRY='@{c0}''

       

      Record: '<record type="update"><value columnID="c54d3ef683932703e"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">GB</sawx:expr></value><value columnID="c7a8d037eee002636"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">Plymouth</sawx:expr></value><value columnID="c214d1c05d4b60a9e" type="update"><newValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xsi:type="xsd:decimal" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">301.00</sawx:expr></newValue><oldValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xsi:type="xsd:decimal" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">300</sawx:expr></oldValue></value></record>'



      my XML file looks like this:


      <?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_STORE">

       

       

      - <XML>

       

       

      - <writeBack connectionPool="LA_CP">

       

       

      <insert> </insert>

       

       

      <update>UPDATE RGBU.LOCATION SET square_m=@{c2} WHERE LOCATION_NAME='@{c1}' and COUNTRY='@{c0}'</update>

       

      </writeBack>

      </XML>

      </WebMessage>

      </WebMessageTable>

      </WebMessageTables>



      TThanks for any hint

      hHaitham