3 Replies Latest reply: Jan 21, 2014 7:44 AM by Richard Benoit RSS

    Scheduled reloads fail instantly until server is restarted

    Josephine Campbell

      Hello all,

       

      We seem to be getting this issue about once a week on average. Scheduled reloads fail as soon as they try and connect to SQL Server - the error is 'OLEDB connection failed'. Stopping and restarting the services doesn't fix the issue however after rebooting the server, everything works perfectly. Obviously rebooting the server once or more per week is not a great solution!!! Has anyone come across this issue before? The problem is not with SQL Server as reloading the documents works fine on the server desktop and other non-related applications can connect quite happily. It's just an issue for the scheduled reloads through the QMC. I'll post a few log extracts....


      Qlikview version is 11.2 SR5.

       

      21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0032  Holidays:

      21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0033  LOAD date(CalendarDate) as BankHoliday,

      21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0034   1 as Marker

      21/01/2014 06:09:04.0325431 Information 21/01/2014 06:09:03: 0035      where WeekDay(CalendarDate)<5

      21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:03: 0036  SQL SELECT  CalendarDate

      21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:03: 0037  FROM xxx.dbo.xxx where CalendarDate>='2012-01-01' and IsShopDate=0

      21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:03: 0038   group  by CalendarDate order by CalendarDate

      21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:       Error: OLEDB connection failed

      21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:       General Script Error

      21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:       Execution Failed

      21/01/2014 06:09:04.1419231 Information 21/01/2014 06:09:04:      Execution finished.

       

      21/01/2014 08:49:00.6138630 Information Waiting for the document log "C:\QV Documents\QVD Gen-ADP.qvw" to become available.. Check until 21/01/2014 08:49:04

      21/01/2014 08:49:00.6919501 Information Found a document log. FileName=C:\QV Documents\QVD Gen-ADP.qvw.log

      21/01/2014 08:49:00.6919501 Information Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140121\084859 - QVD Gen-ADP.qvw\DocumentLog.txt

      21/01/2014 08:49:00.9975336 Information The Source Document reload complete. DocumentPath=C:\QV Documents\QVD Gen-ADP.qvw

      21/01/2014 08:49:00.9975336 Information Memory Allocation Delta for this file=1.79 Mb. Available Physical Memory Before Reload=36542.90 Mb. Available Physical Memory After Reload=36534.03 Mb. Total Physical Memory=36534.03 Mb.

      21/01/2014 08:49:01.2006546 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QV Documents\QVD Gen-ADP.qvw.

      21/01/2014 08:49:01.2631572 Information Closing the document.

      21/01/2014 08:49:01.9037585 Information Closed the QlikView Engine successfully. ProcessID=12304

      21/01/2014 08:49:01.9506736 Error The task "QVD Gen-ADP.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:\QV Documents\QVD Gen-ADP.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)

      21/01/2014 08:49:01.9506736 Information Task Execute Duration=00:00:02.3993355

       

       

       

       

      21/01/2014 08:54:45.9718713 Information 21/01/2014 08:54:45: 3069  if 'all'='21' or 'all'='all' then

      21/01/2014 08:54:46.2062915 Information 21/01/2014 08:54:45: 3075    OLEDB CONNECT*Provider*

      21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46: 3079    Rejects:

      21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46: 3080     SQL SELECT * FROM xxxx.dbo.V_QlikviewRejectReport

      21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:         Error: OLEDB connection failed

      21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:         General Script Error

      21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:         Execution Failed

      21/01/2014 08:54:46.3156678 Information 21/01/2014 08:54:46:      Execution finished.

       

       

      21/01/2014 08:54:46.5031335 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QV Documents\QVD Gen2.qvw.

      21/01/2014 08:54:46.5500095 Information Closing the document.

      21/01/2014 08:54:47.1906960 Information Closed the QlikView Engine successfully. ProcessID=16032

      21/01/2014 08:54:47.2063212 Error The task "QVD Gen2.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:\QV Documents\QVD Gen2.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)

      21/01/2014 08:54:47.2063212 Information Task Execute Duration=00:00:02.3438492

      21/01/2014 08:54:47.2063212 Information Sending Alert mail

      21/01/2014 08:54:47.2375663 Information TaskResult.status=Finished

      21/01/2014 08:54:47.2375663 Information Notifying all triggers of new state:FinishedWithErrors