7 Replies Latest reply: Nov 8, 2012 7:37 AM by Foad Reddahi RSS

    I have a problem when using the auto reload [Qlikview Server 11]

      Hi,

       

      1] scheduled auto reload via the management console


      I have a qwv file that should connect to an oracle database and gather some data.

      If I run the file manually then there is no issue. If I configure this in the management console to run automatically at a certain time then the reload fails and in the logfile I see the following info.

       

            Good to know: I'm running Qlikview Server 11 - 64 bit on a Window 2008 R2.

            My connectionstring in the qvw is based on the 'Microoft ole db provider for Oracle'[Force 32 bit].

       

      *********************************************************************************************************************************************************************************

      The task "Reloaddata.qvw" failed. Exception:

      QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Reloaddata.qvw.

         at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

         at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

         --- End of inner exception stack trace ---

         at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

         at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

         --- End of inner exception stack trace ---

         at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

         at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

      ********************************************************************************************************************************************************************************

       

       

       

      2] I thought, let's try something else


      I removed the 32 bit oracle client and installed the 64 bit oracle client. Problem there is that 'Microsoft oledb provider for oracle' is not available.

      Only available option is 'Oracle provider for Ole DB'. Now the reload works in both cases [Manually \ Auto reload].

      As soon as the reload is done, I opened a financial report and refreshed the data based on the previous reload.

      Result: All the number values are changed and it looks like about 10 extra zero's were added after the comma.

       

       

      Does anyone have a solution for the first issue or at least the second?

        • I have a problem when using the auto reload [Qlikview Server 11]
          Stefan Wühl

          If you say you manually loaded successfully, do yo load in a desktop client or from the server QMC?

           

          Regarding your second problem, I remember some similar issues reported here, please search the forum, e.g.

          http://community.qlik.com/message/134940

          http://community.qlik.com/thread/27844

            • I have a problem when using the auto reload [Qlikview Server 11]

              Desktop client is installed on the server and,

               

              With manual reload i mean loading the file from the desktop client.

              As soon as i schedule it in the QMC, I get 'reload Failed' and the error as I mentioned above is the only info I can get out of the logfile

                • I have a problem when using the auto reload [Qlikview Server 11]
                  Rob Wunderlich

                  Do you have a document logfile turned on for the document? What is in the document logfile?

                   

                  -Rob

                    • I have a problem when using the auto reload [Qlikview Server 11]

                      Nothing much.

                       

                       

                      30/12/2011 18:09:12:      Execution started.

                      30/12/2011 18:09:12:      QlikView Version:11.00.11149.0

                      30/12/2011 18:09:12:      CPU Target                    x64

                      30/12/2011 18:09:12:      Operating System              Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

                      30/12/2011 18:09:12:      Wow64 mode                    Not using Wow64

                      30/12/2011 18:09:12:      MDAC Version                  6.1.7601.17514

                      30/12/2011 18:09:12:      MDAC Full Install Version     6.1.7601.17514

                      30/12/2011 18:09:12:      PreferredCompression          2

                      30/12/2011 18:09:12:      EnableParallelReload          1

                      30/12/2011 18:09:12:      ParallelizeQvdLoads           1

                      30/12/2011 18:09:12:      AutoSaveAfterReload           0

                      30/12/2011 18:09:12:      BackupBeforeReload            0

                      30/12/2011 18:09:12:      EnableFlushLog                0

                      30/12/2011 18:09:12:      SaveInfoWhenSavingFile        0

                      30/12/2011 18:09:12:      UserLogfileCharset            0

                      30/12/2011 18:09:12:      OdbcLoginTimeout              -1

                      30/12/2011 18:09:12:      OdbcConnectionTimeout         -1

                      30/12/2011 18:09:12:      ScriptWantsDbWrite            false

                      30/12/2011 18:09:12:      ScriptWantsExe                false

                      30/12/2011 18:09:12:      LogFile CodePage Used:        1252

                      30/12/2011 18:09:12: 0002  SET ThousandSep='.'

                      30/12/2011 18:09:12: 0003  SET DecimalSep=','

                      30/12/2011 18:09:12: 0004  SET MoneyThousandSep='.'

                      30/12/2011 18:09:12: 0005  SET MoneyDecimalSep=','

                      30/12/2011 18:09:12: 0006  SET MoneyFormat='€ #.##0,00;€ -#.##0,00'

                      30/12/2011 18:09:12: 0007  SET TimeFormat='h:mm:ss'

                      30/12/2011 18:09:12: 0008  SET DateFormat='D/MM/YYYY'

                      30/12/2011 18:09:12: 0009  SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff]'

                      30/12/2011 18:09:12: 0010  SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec'

                      30/12/2011 18:09:12: 0011  SET DayNames='ma;di;wo;do;vr;za;zo'

                      30/12/2011 18:09:12: 0013  OLEDB CONNECT32*Provider*XPassword*

                      30/12/2011 18:09:12:       Error: ErrorSource: (null), ErrorMsg: (null)

                      30/12/2011 18:09:12:       General Script Error

                      30/12/2011 18:09:12:       Execution Failed

                      30/12/2011 18:09:12:      Execution finished.

                • Re: I have a problem when using the auto reload [Qlikview Server 11]
                  Eleni Theodoridou

                  I have exact the same problem. Any suggestion?