1 Reply Latest reply: Mar 3, 2014 10:08 AM by BluShadow RSS

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

    Bhas

      Hello EveryOne,

       

      I tries set up write back option to one my report it throws an above error since a day.

       

      here's the xml code from D:\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\customMessages

       

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

            <XML>

               <writeBack connectionPool="Connection Pool11">

                  <insert> </insert>

                  <update>UPDATE cra.LEXICON SET GLOSSARY='@{c62aa189afc70f5a5}',

                                             DESCRIPTION='@{cd3f69f5016af030b}',

                                             SRC='@{c36ec539fae0b081f}',

                                             SYSTM='@{c17c07f4ef3af2451}'

                                             WHERE ID='@{cf4f71d84cde7b1a2}'

                  </update>

                  <postUpdate>COMMIT </postUpdate>

               </writeBack>

            </XML>

         </WebMessage>

      </WebMessageTable>

      </WebMessageTables>

       

      and Report Advance tab code

      <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">

         <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;LEXICON&quot;" withinHierarchy="true">

            <saw:columns>

               <saw:column xsi:type="saw:regularColumn" columnID="cf4f71d84cde7b1a2">

                  <saw:columnFormula>

                     <sawx:expr xsi:type="sawx:sqlExpression">"LEXICON_dim"."ID"</sawx:expr></saw:columnFormula>

                  <saw:displayFormat>

                     <saw:formatSpec suppress="suppress" fontSize="9" wrapText="true">

                        <sawwb:writeBack xmlns:sawwb="com.siebel.analytics.web/writeback/v1" required="false" xsi:type="sawwb:editBox" inputSize="10" inputHeight="1"/></saw:formatSpec></saw:displayFormat>

                  <saw:columnHeading>

                     <saw:displayFormat>

                        <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>

               <saw:column xsi:type="saw:regularColumn" columnID="c62aa189afc70f5a5">

                  <saw:columnFormula>

                     <sawx:expr xsi:type="sawx:sqlExpression">"LEXICON_dim"."GLOSSARY"</sawx:expr></saw:columnFormula>

                  <saw:displayFormat>

                     <saw:formatSpec suppress="suppress" fontSize="9" wrapText="true">

                        <sawwb:writeBack xmlns:sawwb="com.siebel.analytics.web/writeback/v1" required="false" xsi:type="sawwb:editBox" inputSize="10" inputHeight="1"/></saw:formatSpec></saw:displayFormat>

                  <saw:columnHeading>

                     <saw:displayFormat>

                        <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>

               <saw:column xsi:type="saw:regularColumn" columnID="cd3f69f5016af030b">

                  <saw:columnFormula>

                     <sawx:expr xsi:type="sawx:sqlExpression">"LEXICON_dim"."DESCRIPTION"</sawx:expr></saw:columnFormula>

                  <saw:displayFormat>

                     <saw:formatSpec suppress="suppress" fontSize="9" wrapText="true">

                        <sawwb:writeBack xmlns:sawwb="com.siebel.analytics.web/writeback/v1" required="false" xsi:type="sawwb:editBox" inputSize="10" inputHeight="1"/></saw:formatSpec></saw:displayFormat>

                  <saw:columnHeading>

                     <saw:displayFormat>

                        <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>

               <saw:column xsi:type="saw:regularColumn" columnID="c36ec539fae0b081f">

                  <saw:columnFormula>

                     <sawx:expr xsi:type="sawx:sqlExpression">"LEXICON_dim"."SRC"</sawx:expr></saw:columnFormula>

                  <saw:displayFormat>

                     <saw:formatSpec suppress="suppress" fontSize="9" wrapText="true">

                        <sawwb:writeBack xmlns:sawwb="com.siebel.analytics.web/writeback/v1" required="false" xsi:type="sawwb:editBox" inputSize="10" inputHeight="1"/></saw:formatSpec></saw:displayFormat>

                  <saw:columnHeading>

                     <saw:displayFormat>

                        <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>

               <saw:column xsi:type="saw:regularColumn" columnID="c17c07f4ef3af2451">

                  <saw:columnFormula>

                     <sawx:expr xsi:type="sawx:sqlExpression">"LEXICON_dim"."SYSTM"</sawx:expr></saw:columnFormula>

                  <saw:displayFormat>

                     <saw:formatSpec suppress="suppress" fontSize="9" wrapText="true">

                        <sawwb:writeBack xmlns:sawwb="com.siebel.analytics.web/writeback/v1" required="false" xsi:type="sawwb:editBox" inputSize="10" inputHeight="1"/></saw:formatSpec></saw:displayFormat>

                  <saw:columnHeading>

                     <saw:displayFormat>

                        <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column></saw:columns>

            <saw:filter>

               <sawx:expr op="notEqual" xsi:type="sawx:comparison">

                  <sawx:expr xsi:type="sawx:sqlExpression">"LEXICON_dim"."ID"</sawx:expr>

                  <sawx:expr xsi:type="xsd:string">lex130</sawx:expr></sawx:expr></saw:filter></saw:criteria>

         <saw:views currentView="0">

            <saw:view xsi:type="saw:compoundView" name="compoundView!1">

               <saw:cvTable>

                  <saw:cvRow>

                     <saw:cvCell viewName="titleView!1">

                        <saw:displayFormat>

                           <saw:formatSpec/></saw:displayFormat></saw:cvCell></saw:cvRow>

                  <saw:cvRow>

                     <saw:cvCell viewName="tableView!1">

                        <saw:displayFormat>

                           <saw:formatSpec/></saw:displayFormat></saw:cvCell></saw:cvRow></saw:cvTable></saw:view>

            <saw:view xsi:type="saw:titleView" name="titleView!1"/>

            <saw:view xsi:type="saw:tableView" name="tableView!1" autoPreview="false">

               <saw:displayFormat>

                  <saw:formatSpec>

                     <sawwb:writeBack xmlns:sawwb="com.siebel.analytics.web/writeback/v1" xsi:type="sawwb:tableProperties" enabled="true" toggleTableMode="true" templateName="SetLEXICON" useTemplate="true" buttonPos="right"/></saw:formatSpec></saw:displayFormat>

               <saw:edges>

                  <saw:edge axis="page" showColumnHeader="true"/>

                  <saw:edge axis="section"/>

                  <saw:edge axis="row" showColumnHeader="true">

                     <saw:edgeLayers>

                        <saw:edgeLayer type="column" columnID="cf4f71d84cde7b1a2"/>

                        <saw:edgeLayer type="column" columnID="c62aa189afc70f5a5"/>

                        <saw:edgeLayer type="column" columnID="cd3f69f5016af030b"/>

                        <saw:edgeLayer type="column" columnID="c36ec539fae0b081f"/>

                        <saw:edgeLayer type="column" columnID="c17c07f4ef3af2451"/></saw:edgeLayers></saw:edge>

                  <saw:edge axis="column"/></saw:edges></saw:view></saw:views>

         <saw:prompts scope="report" subjectArea="&quot;LEXICON&quot;"/></saw:report>

       

       

      please help me out or any suggestions....

      Thanks