Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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?

9 Replies

Re: Qlikview ODBC coonection issue

Hi,

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

Hope that helps.

Miguel

Not applicable

Re: Qlikview ODBC coonection issue

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

Re: Qlikview ODBC coonection issue

Hi,

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

Hope that helps.

Miguel

Not applicable

Re: Qlikview ODBC coonection issue

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.

Re: Qlikview ODBC coonection issue

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

Not applicable

Re: Qlikview ODBC coonection issue

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

Re: Qlikview ODBC coonection issue

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

Not applicable

Re: Qlikview ODBC coonection issue

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

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

Community Browser