Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-09-14 05:05 AM

Qlikview ODBC coonection issue

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?

Preview file
76 KB
992 Views
0 Likes
9 Replies
Miguel_Angel_Baeyens
Employee
Employee
‎2012-09-14 05:13 AM

Hi,

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

Hope that helps.

Miguel

357 Views
0 Likes
Not applicable
‎2012-09-14 05:29 AM
Author

In response to Miguel_Angel_Baeyens

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

357 Views
0 Likes
Miguel_Angel_Baeyens
Employee
Employee
‎2012-09-14 05:35 AM

In response to

Hi,

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

Hope that helps.

Miguel

357 Views
0 Likes
Not applicable
‎2012-09-14 05:45 AM
Author

In response to Miguel_Angel_Baeyens

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

9/14/2012 01:10:48.1666319InformationWriting 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.0572398InformationReloading.
9/14/2012 01:10:50.0572206InformationReloading..
9/14/2012 01:10:51.0572014InformationReloading...
9/14/2012 01:10:52.0571822InformationReloading....
9/14/2012 01:10:53.0571630InformationReloading.....
9/14/2012 01:10:54.0571438InformationReloading......
9/14/2012 01:10:55.0571246InformationReloading.......
9/14/2012 01:10:56.0571054InformationReloading........
9/14/2012 01:10:57.0570862InformationReloading.........
9/14/2012 01:10:58.0570670InformationReloading..........
9/14/2012 01:10:59.0570478InformationSlow down logging. Log every <2> seconds.
357 Views
0 Likes
Miguel_Angel_Baeyens
Employee
Employee
‎2012-09-14 05:55 AM

In response to

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

357 Views
0 Likes
Not applicable
‎2012-09-14 06:05 AM
Author

In response to Miguel_Angel_Baeyens

in Document log I can see only below info.

9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      Execution started.
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      QlikView Version:11.00.11282.0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      CPU Target                    x86
9/14/2012 01:10:48.1666319Information14/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.1666319Information14/09/2012 1:10:48 AM:      Wow64 mode                    Not using Wow64
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      MDAC Version                  2.82.3959.0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      MDAC Full Install Version     2.82.3959.0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      PreferredCompression          2
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      EnableParallelReload          1
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      ParallelizeQvdLoads           1
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      AutoSaveAfterReload           0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      BackupBeforeReload            0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      EnableFlushLog                0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      SaveInfoWhenSavingFile        0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      UserLogfileCharset            0
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      OdbcLoginTimeout              -1
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      OdbcConnectionTimeout         -1
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      ScriptWantsDbWrite            false
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      ScriptWantsExe                false
9/14/2012 01:10:48.1666319Information14/09/2012 1:10:48 AM:      LogFile CodePage Used:        1252
357 Views
0 Likes
Miguel_Angel_Baeyens
Employee
Employee
‎2012-09-14 06:17 AM

In response to

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

357 Views
0 Likes
Not applicable
‎2012-09-14 06:28 AM
Author

In response to Miguel_Angel_Baeyens

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.

357 Views
0 Likes
Miguel_Angel_Baeyens
Employee
Employee
‎2012-09-14 08:49 AM

In response to

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

357 Views
0 Likes