Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Enable the "Generate log" for the document in the Settings menu, Document Properties, General tab. Is the connection working?
Hope that helps.
Miguel
In the Qlikview 11 server, I can't see these settings.
Hi,
You need to open the document using QlikView Desktop, set that check then save the QVW file.
Hope that helps.
Miguel
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. |
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
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 |
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
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.
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