Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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,

3 Replies
MVP
MVP

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

...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

Not applicable

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

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.
Not applicable

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

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

I am using a 64 bit

Community Browser