9 Replies Latest reply: Sep 14, 2012 8:49 AM by Miguel Angel Baeyens de Arce RSS

    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?

        • Re: Qlikview ODBC coonection issue
          Miguel Angel Baeyens de Arce

          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

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

                • Re: Qlikview ODBC coonection issue
                  Miguel Angel Baeyens de Arce

                  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

                      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
                          Miguel Angel Baeyens de Arce

                          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

                              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
                                  Miguel Angel Baeyens de Arce

                                  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