3 Replies Latest reply on Aug 19, 2019 1:07 PM by JohnGoodwin

    Trying to load data using Load rule from Oracle database

    3979789

      Hi Team,

       

      We are trying to load data through load rule directly from Oracle database (EBS) but facing some issues. Created load rule and inserted the SQL statement and trying to Retrieve but facing the below issue

       

      Sql error.PNG

       

      The log says as below

       

      OR (ledger_id = 647 AND currency_Mon~Aug~19~01:35:18~2019~~4788~Info~(1021043)~Connection has been established

       

      Mon~Aug~19~01:35:18~2019~Local~~4788~Info~(1021044)~Starting to execute query

       

       

      Mon~Aug~19~01:35:18~2019~Local~~4788~Info~(1021013)~ODBC Layer Error: ~[S1000]~ ==> ~[[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00936: missing expression]

       

       

      Mon~Aug~19~01:35:18~2019~Local~~4788~Info~(1021014)~ODBC Layer Error: Native Error code ~[936]

       

       

      Mon~Aug~19~01:35:18~2019~Local~~4788~Error~(1021106)~Failed to Execute SQL Statement. See log for more information

       

       

      Mon~Aug~19~01:35:18~2019~Local~~4788~Warning~(1080014)~Transaction ~[ 0x790008( 0x5d5a3516.0xbcf70 ) ]~ aborted due to status ~[1021106]~.

       

      COuld you please help me on this? Thanks!

        • 1. Re: Trying to load data using Load rule from Oracle database
          JohnGoodwin

          Make sure you are entering the SQL correctly into the SQL statement window.

          The following is incorrect:

          This will generate

          ODBC Layer Error: [S1000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00936: missing expression]

           

          You can see in the log the query is incorrect as it contains select twice

          SELECT Statement [SELECT SELECT * FROM V_ACTDATA] is generated

           

          The following is valid

          You can also read up on the Oracle error - ORA-00936 which usually means the SQL statement is not valid.

           

          Cheers

           

          John

          • 2. Re: Trying to load data using Load rule from Oracle database
            3979789

            Hi John,

             

            Now that is resolved and came up with different error message. Could you also please help on this

             

            Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021043)~Connection has been established

             

             

            Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021044)~Starting to execute query

             

             

            Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021013)~ODBC Layer Error: ~[S1000]~ ==> ~[[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01008: not all variables bound]

             

             

            Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021014)~ODBC Layer Error: Native Error code ~[1008]

             

             

            Mon~Aug~19~05:06:33~2019~Local~~19644~Error~(1021106)~Failed to Execute SQL Statement. See log for more information

             

             

            Mon~Aug~19~05:06:33~2019~Local~WHGAR~AR~C27128@hotelgroup_com~19644~Warning~(1080014)~Transaction ~[ 0x185000a( 0x5d5a6699.0x4de18 ) ]~ aborted due to status ~[1021106]~.

            • 3. Re: Trying to load data using Load rule from Oracle database
              JohnGoodwin

              Have a search for the Oracle error as you will find the reason behind it, sounds like you are trying to include variables.

              also try to simplify your query so it works and then start to build on that with more complexity, at least you will understand where the issue is.