3 Replies Latest reply: Jul 29, 2014 4:02 PM by Francisco Montalva RSS

    Program a Task in Qlikview Server with Oracle 9i - Windows 2012

    Francisco Montalva

      Hello,

      I have a QlikView Document that reloads the data without problems with OLEDB but when I program the task in Qlikview Server this don't works. I have a database Oracle 9i in a windows server 2012 64 bits and the only way for connect with OLEDB or ODBC is to use "Oracle Data Access Component 11g 64 bit".

       

      I think that Qlikview Server try to connect doing a conection of 32 bits.

       

      regards,

        • Re: Program a Task in Qlikview Server with Oracle 9i - Windows 2012
          Massimo Grossi

          ...this don't works.....

          and the error is?

           

          which type of connection are you using in your qlik doc? 32 or 64?

          the connection in qlik doc (when you deploy it to the server) should match the oracle client you have on qlikvew server

          • Re: Program a Task in Qlikview Server with Oracle 9i - Windows 2012
            Francisco Montalva

            Hi Massimo,

            Look this is the log if I push the button "Reloads"

            29-07-2014 15:43:34:  Ejecución iniciada.
            29-07-2014 15:43:34:  QlikView Version:11.20.12354.0
            29-07-2014 15:43:34:  CPU Target                x64
            29-07-2014 15:43:34:  Operating System          Windows Server 2012 R2 Standard  (64 bit edition)
            29-07-2014 15:43:34:  Wow64 mode                Not using Wow64
            29-07-2014 15:43:34:  MDAC Version              6.3.9600.16384
            29-07-2014 15:43:34:  MDAC Full Install Version 6.3.9600.16384
            29-07-2014 15:43:34:  PreferredCompression      2
            29-07-2014 15:43:34:  EnableParallelReload      1
            29-07-2014 15:43:34:  ParallelizeQvdLoads       1
            29-07-2014 15:43:34:  AutoSaveAfterReload       0
            29-07-2014 15:43:34:  BackupBeforeReload        1
            29-07-2014 15:43:34:  EnableFlushLog            0
            29-07-2014 15:43:34:  SaveInfoWhenSavingFile    0
            29-07-2014 15:43:34:  UserLogfileCharset        1200
            29-07-2014 15:43:34:  OdbcLoginTimeout          -1
            29-07-2014 15:43:34:  OdbcConnectionTimeout     -1
            29-07-2014 15:43:34:  ScriptWantsDbWrite        false
            29-07-2014 15:43:34:  ScriptWantsExe            false
            29-07-2014 15:43:34:  LogFile CodePage Used:    1200
            29-07-2014 15:43:34:   Reload Executed By MEF\fmontalva
            29-07-2014 15:43:34:   Process Executing: QlikView Desktop
            29-07-2014 15:43:34:   Process ID: 1768

            29-07-2014 15:43:34: 0002  SET ThousandSep='.'

            29-07-2014 15:43:34: 0003  SET DecimalSep=','

            29-07-2014 15:43:34: 0004  SET MoneyThousandSep='.'

            29-07-2014 15:43:34: 0005  SET MoneyDecimalSep=','

            29-07-2014 15:43:34: 0006  SET MoneyFormat='$ #.##0,00;-$ #.##0,00'

            29-07-2014 15:43:34: 0007  SET TimeFormat='h:mm:ss'

            29-07-2014 15:43:34: 0008  SET DateFormat='DD-MM-YYYY'

            29-07-2014 15:43:34: 0009  SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]'

            29-07-2014 15:43:34: 0010  SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic'

            29-07-2014 15:43:34: 0011  SET DayNames='lun;mar;mié;jue;vie;sáb;dom'

            29-07-2014 15:43:34: 0013  Let RepositorioQvd = '..\..\Qvd\Generador QVD\'

            29-07-2014 15:43:34: 0019  OLEDB CONNECT*Provider*XPassword*

            29-07-2014 15:43:34: 0052  SQL SELECT

            29-07-2014 15:43:34: 0058  ATTRIBUTE10 as CALIBRE_INF,
            29-07-2014 15:43:34: 0059  ATTRIBUTE11 as CALIBRE_SUP,
            29-07-2014 15:43:34: 0060  ATTRIBUTE12 as UN_CALIBRE,
            29-07-2014 15:43:34: 0111  "INACTIVE_IND",
            29-07-2014 15:43:34: 0116  "ITEM_DESC1",
            29-07-2014 15:43:34: 0118  "ITEM_ID",
            29-07-2014 15:43:34: 0119  "ITEM_NO"

            29-07-2014 15:43:34: 0167  FROM GMI."IC_ITEM_MST_B"

            29-07-2014 15:43:34:  7 campos encontrados: CALIBRE_INF, CALIBRE_SUP, UN_CALIBRE, INACTIVE_IND, ITEM_DESC1, ITEM_ID, ITEM_NO, 4.910 registros leídos

            29-07-2014 15:43:34: 0169  STORE IC_ITEM_MST_B Into "D:\QlikView\QVD\GMI.IC_ITEM_MST_B.QVD"

            29-07-2014 15:43:34: 0172  EXIT Script

            29-07-2014 15:43:35: 

            Ejecución finalizada.


             

            But if I go to the QlikView Management Console ->[Choose my doc] -> Reload -> and choose a reload schedule this is the result:

             

             

            28-07-2014 16:23:34:  Execution started.
            28-07-2014 16:23:34:  QlikView Version:11.20.12354.0
            28-07-2014 16:23:34:  CPU Target                x64
            28-07-2014 16:23:34:  Operating System          Windows Server 2012 R2 Standard  (64 bit edition)
            28-07-2014 16:23:34:  Wow64 mode                Not using Wow64
            28-07-2014 16:23:34:  MDAC Version              6.3.9600.16384
            28-07-2014 16:23:34:  MDAC Full Install Version 6.3.9600.16384
            28-07-2014 16:23:34:  PreferredCompression      2
            28-07-2014 16:23:34:  EnableParallelReload      1
            28-07-2014 16:23:34:  ParallelizeQvdLoads       1
            28-07-2014 16:23:34:  AutoSaveAfterReload       0
            28-07-2014 16:23:34:  BackupBeforeReload        0
            28-07-2014 16:23:34:  EnableFlushLog            0
            28-07-2014 16:23:34:  SaveInfoWhenSavingFile    0
            28-07-2014 16:23:34:  UserLogfileCharset        1200
            28-07-2014 16:23:34:  OdbcLoginTimeout          -1
            28-07-2014 16:23:34:  OdbcConnectionTimeout     -1
            28-07-2014 16:23:34:  ScriptWantsDbWrite        false
            28-07-2014 16:23:34:  ScriptWantsExe            false
            28-07-2014 16:23:34:  LogFile CodePage Used:    1200
            28-07-2014 16:23:34:   Reload Executed By MEF\qlikview
            28-07-2014 16:23:34:   Process Executing: QVB
            28-07-2014 16:23:34:   Process ID: 4804

            28-07-2014 16:23:34: 0002  SET ThousandSep='.'

            28-07-2014 16:23:34: 0003  SET DecimalSep=','

            28-07-2014 16:23:34: 0004  SET MoneyThousandSep='.'

            28-07-2014 16:23:34: 0005  SET MoneyDecimalSep=','

            28-07-2014 16:23:34: 0006  SET MoneyFormat='$ #.##0,00;-$ #.##0,00'

            28-07-2014 16:23:34: 0007  SET TimeFormat='h:mm:ss'

            28-07-2014 16:23:34: 0008  SET DateFormat='DD-MM-YYYY'

            28-07-2014 16:23:34: 0009  SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]'

            28-07-2014 16:23:34: 0010  SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic'

            28-07-2014 16:23:34: 0011  SET DayNames='lun;mar;mié;jue;vie;sáb;dom'

            28-07-2014 16:23:34: 0013  Let RepositorioQvd = '..\..\Qvd\Generador QVD\'

            28-07-2014 16:23:34: 0016  OLEDB CONNECT*Provider*XPassword*

            28-07-2014 16:23:34:   Error: ErrorSource: (null), ErrorMsg: No se puede encontrar el módulo especificado.
            28-07-2014 16:23:34:   General Script Error
            28-07-2014 16:23:34:   Execution Failed
            28-07-2014 16:23:34:  Execution finished.
            • Re: Program a Task in Qlikview Server with Oracle 9i - Windows 2012
              Francisco Montalva

              which type of connection are you using in your qlik doc? 32 or 64?

              I am using a 64 bit