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

Tue, 29 Jul 2014 18:48:42 GMT

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

maxgro — Tue, 29 Jul 2014 19:40:05 GMT

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

Tue, 29 Jul 2014 19:58:52 GMT

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

Tue, 29 Jul 2014 20:02:10 GMT

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

I am using a 64 bit

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

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

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

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

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