Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
...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
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. |
which type of connection are you using in your qlik doc? 32 or 64?
I am using a 64 bit