11 Replies Latest reply: Feb 13, 2012 10:26 AM by Ralf Becher RSS

    [10SR4] Oracle silent errors

    Nicolas Stefaniuk

      Hello all,

       

      I have an issue with 10 SR4.

       

      The oracle errors are silent in SR4 when they are not in SR2.

       

      With this code (after a CONNECT of course), you should get an Oracle error (dividing by zero).

       

      data:
      Load
      * 
      ;
      SQL
      select
      1/0 "test" from dual
      ;
      
      
      drop table data;
      
      

       

      In SR2 i get the error but in SR4 I don't, and so in SR4 I just have the table missing error (because the table is not created).

       

      I haven't found a parameter to manage it.

       

      I am in 32 bits on Windows 7, but same in 64 bits on 2003 server

       

      Thanks for help

        • [10SR4] Oracle silent errors
          Ralf Becher

          Hi,

           

          it's working on my site with QV 10 SR4, QV11 on Oracle 10g & 11g, Win7 x64 with Oracle ODBC driver.

           

          Which ODBC driver you're using?

           

          Maybe you have set ErrorMode=0 ?

           

          - Ralf

            • [10SR4] Oracle silent errors

              Hi,

               

              Same problem with ole-db Oracle connector

               

              SET ErrorMode=1;

              OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=MyUser;Data Source=Mytable;Extended Properties=""] (XPassword is *******);

              data:

              Load

              * ;

              SQL

              select

              1/0 "test" from dual;

              drop table data;

               

              10/02/2012 14:20:14:      Début de l'exécution

              10/02/2012 14:20:14:      QlikView Version:10.00.9282.8

              10/02/2012 14:20:14:      CPU Target                    x86

              10/02/2012 14:20:14:      Operating System              Microsoft Windows XP Service Pack 3 (32 bit edition)

              10/02/2012 14:20:14:      Wow64 mode                    Not using Wow64

              10/02/2012 14:20:14:      MDAC Version                  2.81.1132.0

              10/02/2012 14:20:14:      MDAC Full Install Version     2.81.1132.0

              10/02/2012 14:20:14:      PreferredCompression          0

              10/02/2012 14:20:14:      EnableParallelReload          1

              10/02/2012 14:20:14:      ParallelizeQvdLoads           1

              10/02/2012 14:20:14:      AutoSaveAfterReload           1

              10/02/2012 14:20:14:      BackupBeforeReload            1

              10/02/2012 14:20:14:      EnableFlushLog                0

              10/02/2012 14:20:14:      SaveInfoWhenSavingFile        0

              10/02/2012 14:20:14:      UserLogfileCharset            0

              10/02/2012 14:20:14:      OdbcLoginTimeout              -1

              10/02/2012 14:20:14:      OdbcConnectionTimeout         -1

              10/02/2012 14:20:14:      ScriptWantsDbWrite            false

              10/02/2012 14:20:14:      ScriptWantsExe                false

              10/02/2012 14:20:14:      LogFile CodePage Used:        1252

              10/02/2012 14:20:14: 0002  SET ThousandSep=' '

              10/02/2012 14:20:14: 0003  SET DecimalSep=','

              10/02/2012 14:20:14: 0004  SET MoneyThousandSep=' '

              10/02/2012 14:20:14: 0005  SET MoneyDecimalSep=','

              10/02/2012 14:20:14: 0006  SET MoneyFormat='# ##0,00 €;-# ##0,00 €'

              10/02/2012 14:20:14: 0007  SET TimeFormat='hh:mm:ss'

              10/02/2012 14:20:14: 0008  SET DateFormat='DD/MM/YYYY'

              10/02/2012 14:20:14: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

              10/02/2012 14:20:14: 0010  SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.'

              10/02/2012 14:20:14: 0011  SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.'

              10/02/2012 14:20:14: 0012  set ErrorMode=1

              10/02/2012 14:20:14: 0013  OLEDB CONNECT*Provider*XPassword*

              10/02/2012 14:20:14: 0015  data:

              10/02/2012 14:20:14: 0016  Load

              10/02/2012 14:20:14: 0017  *

               

              10/02/2012 14:20:14: 0019  SQL

              10/02/2012 14:20:14: 0020  select

              10/02/2012 14:20:14: 0021  1/0 "test" from dual

               

              10/02/2012 14:20:14: 0025  drop table data

              10/02/2012 14:20:14:       Erreur: Table non trouvée

              10/02/2012 14:20:16:      Fin de l'exécution.

            • [10SR4] Oracle silent errors
              Nicolas Stefaniuk

              Tested with Qlikview SR4 with OraOLEDB11.dll on a Oracle 11 XE, same issue: the oracle error is silent.

               

              I just don't understand why it works for you Ralf.

               

              In ODBC the error is retrieved.