10 Replies Latest reply: Feb 24, 2015 7:47 AM by it man RSS

    Schedule reload failure

    Kelvin Davis
      We have reloads that are scheduled to run at around 06:30 and they keep failing. When we run them manually a few hours later they are successful. Any ideas on what could be causing the problem? Details bellow:
      Environment
      QlikView Server is on version 11.20, Windows Server 2012 R2
      Database server is running SQL Server 2008 R2, Windows Server 2008 R2
        From the document log (Build_Sales_Baseline.qvw.log)
      29/01/2015 06:34:04: 0611  SQL SELECT * FROM AquaDW.dbo.FactAccountsRebates WHERE LastUpdated >= '1900-01-01'
      29/01/2015 06:34:04:       Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionRead (Error SIO_KEEPALIVE_VALS()).]General network error. Check your network documentation.
      29/01/2015 06:34:04:       General Script Error
      29/01/2015 06:34:04:       Execution Failed
      From the QlikView Windows Event Viewer
      The Source Document was NOT reloaded successfully. DocumentPath=D:\QlikView\Documents\Live\DataMart\Build_Sales_Baseline.qvw.

      The task "DataMart/Build_Sales_Baseline.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=D:\QlikView\Documents\Live\DataMart\Build_Sales_Baseline.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)

      SQL server Windows Event Viewer and SQL Log File Viewer have no errors/warnings at the time of failures.
        • Re: Schedule reload failure
          Gysbert Wassenaar

          Check the file D:\QlikView\Documents\Live\DataMart\Build_Sales_Baseline.qvw.log  for errors. If that file does not exist open the document and enable the option Generate Logfile and save the file. Then reload the document again from the QMC and then check the log file.

            • Re: Schedule reload failure
              Kelvin Davis

              Hi,

               

              There is an error in the log file (as I mentioned in the first post). I have no idea what "[DBNETLIB][ConnectionRead (Error SIO_KEEPALIVE_VALS()).]General network error." means.

               

               

              From the document log (Build_Sales_Baseline.qvw.log)

              29/01/2015 06:34:04: 0611  SQL SELECT * FROM AquaDW.dbo.FactAccountsRebates WHERE LastUpdated >= '1900-01-01'
              29/01/2015 06:34:04:       Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionRead (Error SIO_KEEPALIVE_VALS()).]General network error. Check your network documentation.
              29/01/2015 06:34:04:       General Script Error
              29/01/2015 06:34:04:       Execution Failed
                • Re: Schedule reload failure
                  Avinash R

                  Hi Kelvin,

                   

                  Their is some issue in the Qlikview script:

                  Go to>edit script> and use debug option and trace the issue.

                  this will get you know the exact issue.

                   

                  Hope this helps you

                  • Re: Schedule reload failure
                    Gysbert Wassenaar

                    My apologies, I didn't read your post as thoroughly as I should have. Have you tried searching the internet for this error. Or perhaps your network administrator can assist in troubleshooting the issue. In any case the problem is not caused by Qlikview. Qlikview merely logs the error that the OLEDB driver for SQL Server returns.

                      • Re: Schedule reload failure
                        Kelvin Davis

                        I agree I think the error is related to our SQL server.

                         

                        I've posted a similar question on Microsoft TechNet SQL server forum for some help. I'll let you know how I get on..

                          • Re: Schedule reload failure
                            it man

                            Please let me know if you were able to resolve this issue

                             

                            Error that I have in the Log:

                            Error: The task failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath= || 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)

                              • Re: Schedule reload failure
                                it man

                                Reload task that i created in QMC is still failing.

                                When I debug in the 'Edit Script' of my qlikview document,Result is :'connected'.

                                 

                                Here's my connection info in qlikview document:

                                OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=xxxx;Data Source=yyyyyy;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=zzzzzz;Use Encryption for Data=False;Tag with column collation when possible=False];

                                  • Re: Schedule reload failure
                                    Colin Albert

                                    Who are you logged in as when you say "When I debug in the 'Edit Script' of my qlikview document,Result is :'connected'."

                                     

                                    The scheduled reload will run as the user account that runs the QDS service (QlikView Distribution Service)

                                    Does the service account have permission to access the database?

                                     

                                    Can you login to the server using the service account, and then test if the reload works from QlikView Desktop?

                                      • Re: Schedule reload failure
                                        it man

                                        Ok., its the Database permissions issue...

                                        Found this out by connecting to the database utilizing the service account that was created for Qlikview server.

                                         

                                        service account (This is usually the account that was utilized to install Qlikview server) has access to the SQL Server database or whatever your database may be.


                                        In order to validate and ensure that all your services are running with the service account credentials you need to go to "Start > Run", typing in "services.msc" and validate that your Qlilview services are running with the service account credentials.


                                        Then,

                                        Informed company DBA to provide authorization to SQL server data  . He added the Service Account username at:

                                        SQL server > Databases > xxxdatabase > Security > Users > R.Click > New User.. > enter the Username and Login name > Make selection under 'Owned Schemas' and 'Role Members'  ( eg: db_datareader , db_datawriter) 

                                         

                                        Now, Reload task is successfully working. Thank you.