topic Qlikview ODBC coonection issue in QlikView

Qlikview ODBC coonection issue

Fri, 14 Sep 2012 09:05:00 GMT

Hi,

I am running Qlikview 11 on windows server 2003 -32 Bit, And trying to connect a Oracle DB which is also in windows server 2003 -32 Bit

I am getting the below log but no tracing about the DB conneciton. Where can i see?

Re: Qlikview ODBC coonection issue

Miguel_Angel_Baeyens — Fri, 14 Sep 2012 09:13:03 GMT

Hi,

Enable the "Generate log" for the document in the Settings menu, Document Properties, General tab. Is the connection working?

Hope that helps.

Miguel

Re: Qlikview ODBC coonection issue

Fri, 14 Sep 2012 09:29:00 GMT

In the Qlikview 11 server, I can't see these settings.

Re: Qlikview ODBC coonection issue

Miguel_Angel_Baeyens — Fri, 14 Sep 2012 09:35:07 GMT

Hi,

You need to open the document using QlikView Desktop, set that check then save the QVW file.

Hope that helps.

Miguel

Re: Qlikview ODBC coonection issue

Fri, 14 Sep 2012 09:45:17 GMT

I can see below log in tasklog.txt . But I can't see the DB connection is fine.

9/14/2012 01:10:48.1666319	Information	Writing documentLog to C:\Documents and Settings\All Users\Application Data\QlikTech\DistributionService\1\Log\20120914\011047 - RefreshStaticReportData\DocumentLog.txt
9/14/2012 01:10:49.0572398	Information	Reloading.
9/14/2012 01:10:50.0572206	Information	Reloading..
9/14/2012 01:10:51.0572014	Information	Reloading...
9/14/2012 01:10:52.0571822	Information	Reloading....
9/14/2012 01:10:53.0571630	Information	Reloading.....
9/14/2012 01:10:54.0571438	Information	Reloading......
9/14/2012 01:10:55.0571246	Information	Reloading.......
9/14/2012 01:10:56.0571054	Information	Reloading........
9/14/2012 01:10:57.0570862	Information	Reloading.........
9/14/2012 01:10:58.0570670	Information	Reloading..........
9/14/2012 01:10:59.0570478	Information	Slow down logging. Log every <2> seconds.

Re: Qlikview ODBC coonection issue

Miguel_Angel_Baeyens — Fri, 14 Sep 2012 09:55:38 GMT

Hi,

Yes, that makes sense. The task does not show each and every line of the script. That is stored into the Document log, that can be set up as I mentioned above. Did you check that logfile?

Hope that helps.

Miguel

Re: Qlikview ODBC coonection issue

Fri, 14 Sep 2012 10:05:47 GMT

in Document log I can see only below info.

9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: Execution started.
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: QlikView Version:11.00.11282.0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: CPU Target x86
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: Operating System Microsoft Windows Server 2003 R2 Service Pack 2 (32 bit edition)
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: Wow64 mode Not using Wow64
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: MDAC Version 2.82.3959.0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: MDAC Full Install Version 2.82.3959.0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: PreferredCompression 2
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: EnableParallelReload 1
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: ParallelizeQvdLoads 1
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: AutoSaveAfterReload 0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: BackupBeforeReload 0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: EnableFlushLog 0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: SaveInfoWhenSavingFile 0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: UserLogfileCharset 0
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: OdbcLoginTimeout -1
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: OdbcConnectionTimeout -1
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: ScriptWantsDbWrite false
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: ScriptWantsExe false
9/14/2012 01:10:48.1666319	Information	14/09/2012 1:10:48 AM: LogFile CodePage Used: 1252

Re: Qlikview ODBC coonection issue

Miguel_Angel_Baeyens — Fri, 14 Sep 2012 10:17:48 GMT

Mmm,

I'm missing something here... The document log looks like this:

14/09/2012 12:17:05: 0008 SET DateFormat='DD/MM/YYYY'
14/09/2012 12:17:05: 0009 SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]'
14/09/2012 12:17:05: 0010 SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic'
14/09/2012 12:17:05: 0011 SET DayNames='lun;mar;mié;jue;vie;sáb;dom'
14/09/2012 12:17:05: 0013 ODBC CONNECT32*
14/09/2012 12:17:05: 0016 LOAD ID,
14/09/2012 12:17:05: 0017      Field1
14/09/2012 12:17:05: 0018 SQL SELECT *
14/09/2012 12:17:05: 0019 FROM Table1
14/09/2012 12:17:06:                 2 fields found: ID, Field1, 3 lines fetched
14/09/2012 12:17:06:      Execution finished.

Specifying each of the lines of the script that are executed, how many fields and rows have been retrieved...

Did you check the setting I mentioned?

Hope that helps.

Miguel

Re: Qlikview ODBC coonection issue

Fri, 14 Sep 2012 10:28:21 GMT

In the document log, there is nothing which you mentioned above. I assume that connection between Qlikview and DB is not established. If the conenction get established then it will execute the query and display in the log which you mentioned?

I can't find any clue.

Re: Qlikview ODBC coonection issue

Miguel_Angel_Baeyens — Fri, 14 Sep 2012 12:49:50 GMT

Hi,

In the script editor, did you try testing the connection when you create it? Remove the whole CONNECT line and use the wizard to create it again. Make sure you test the connection successfully, so QlikView can connect with the same user that is running the QlikView services to the ODBC you have created.

Hope that helps.

Miguel