3 Replies Latest reply: Jan 10, 2013 6:07 AM by Yogi1729 RSS

    Write Back - The system was unable to generate appropriate SQL. Please cont

    880411
      Hi I am facing the below error while implementing writback feature in obiee 11g.

      The system was unable to generate appropriate SQL. Please contact your system administrator.

      Template: 'update OBI_DEV.W_PRODUCT_D_WRITE_BACK SET MON_REL_TARGET = '@{c5b2e8f4d057e4201}', MON_GROSS_TARGET= '@{ce74545331e56f0bc}' where PRODUCT_FAMILY = '@{c9a6eeb6940647d1b}' and PRODUCT_TYPE = '@{c037fcc09911be97b}' and REGION = '@{c0bc248e1e2c13fc4}''

      Record: '<record type="update"><value columnID="c0c5d0de6e8463149"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">PROD_A</sawx:expr></value><value columnID="c9a6eeb6940647d1b"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">DP_CO</sawx:expr></value><value columnID="c037fcc09911be97b"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">Commerical Product</sawx:expr></value><value columnID="c3805a6285c2d923d"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">INTL</sawx:expr></value><value columnID="c0bc248e1e2c13fc4" type="update"><newValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">3</sawx:expr></newValue><oldValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">2</sawx:expr></oldValue></value><value columnID="c5b2e8f4d057e4201"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">6</sawx:expr></value></record>'
      ============================================================================================================'

      here is my XML Template.

      <WebMessage name="Writeback">
      <XML>
      <writeBack connectionPool="Oracle DataWarehouse Connection Pool Write Back">
      <insert> </insert>
      <update>update OBAW_DEV.W_PRODUCT_D_WRITE_BACK SET M MON_REL_TARGET = '@{c5b2e8f4d057e4201}', MON_GROSS_TARGET= '@{ce74545331e56f0bc}' where PROD_FAMILY = '@{c9a6eeb6940647d1b}' and PRODUCT_TYPE = '@{c037fcc09911be97b}' and REGION = '@{c0bc248e1e2c13fc4}'</update>
      </writeBack>
      </XML>
      </WebMessage>

      Thanks
      Kumar

      Edited by: 877408 on Jan 9, 2013 7:57 AM

      Edited by: 877408 on Jan 9, 2013 7:58 AM

      Edited by: 877408 on Jan 9, 2013 8:11 AM