Reload taking too much time

[Anonymous]

Hi  ,

I hv scheduled task for reload in morning earlier it was taking hardly 5 mins to reload but now its taking 2 hours for reload what cud be the   problem plz suggest.

i checked the log files but could not found exact problem

thnx in advance

[#2]

Just in case, are other tasks running on the server at the same time as the reload? Maybe the server is running other intensive tasks at the same time as the reload during the morning. This could be a reason for it to take a lot longer. It could happen even if the tasks are not QlikView related.

[Anonymous]

where is preload option??

Will it affect other functionality of qv???

[ashfaq_haseeb]

Hi,

Go to QEMC --> Document's tab --> User  Documents --> Select your Application --> To right side you will find server tab --> go to performance sub tab --> and make supe preload is unchecked.

Secondly

go to QEMC--> System --> Setup --> QlikView Server --> Document tab --> make sure allow session recovery is unchecked.

Let me know if that solved your problem. Otherwise we will diagonose in other direction.

Regards

ASHFAQ

[Colin-Albert]

This could be a locking issue. Are there other tasks accessing the data, possibly a backup or an update task.

Can you add a nolock hint to your SQL query?

[Anonymous]

i hv made changes as per ur advice lets see what happens in tomorrow morning's load

[ashfaq_haseeb]

All the best.

Regards

ASHFAQ

[Anonymous]

i did not work still reload taking too much time for 1 dashboard and one dashboard failed...plz suggest

[Anonymous]

today i found this error in logs

(2014-09-05 06:30:47) Error: The task "Reload and distribute USD(Local) dashboard" failed. Exception:

(2014-09-05 06:30:47) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.DistributeToResourcesFailedException: Distribute to resource failed. ---> QDSMain.Exceptions.DscOffLineException: Failed to AddNamedUsers

(2014-09-05 06:30:47) Error: at QDSMain.Support.DSCHelper.AddNamedUsers(ILogBucket logBucket, XmlDocument xml, List`1 namedUsers, FileSystemPluginHelper fileSystemPluginHelper)

(2014-09-05 06:30:47) Error: at QDSMain.Support.DSCHelper.GetFileSystemSecurity(ILogBucket logBucket, FileSystemPluginHelper fileSystemPluginHelper, List`1 recipients)

(2014-09-05 06:30:47) Error: at QDSMain.QlikViewServerDistributionResource.CreateSettingsBlock(ILogBucket i_LogBucket, FileSystemPluginHelper i_FileSystemPluginHelper, String i_SourceDocumentName, DateTime i_LastUpdate, DateTime i_NextUpdate, Boolean i_EventDriven, String i_Category, eDistributionFileType i_TotalDistributionFileTypeMask, FilePackageContainer i_FilePackageContainer)

(2014-09-05 06:30:47) Error: at QDSMain.QlikViewServerDistributionResource.Distribute(ILogBucket i_LogBucket, DistributionRequest i_DistributionRequest)

(2014-09-05 06:30:47) Error: at QDSMain.DistributeTask.DistributeStreamToResources(Int32 round, Distribution distribution, IEnumerable`1 distributionResources)

(2014-09-05 06:30:47) Error: --- End of inner exception stack trace ---

(2014-09-05 06:30:47) Error: at QDSMain.DistributeTask.DistributeStreamToResources(Int32 round, Distribution distribution, IEnumerable`1 distributionResources)

(2014-09-05 06:30:47) Error: at QDSMain.DistributeTask.DistributionExecution(String fileName, Document qvbDocument, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

(2014-09-05 06:30:47) Error: at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

(2014-09-05 06:30:47) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-09-05 06:30:47) Error: --- End of inner exception stack trace ---

(2014-09-05 06:30:47) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-09-05 06:30:47) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-09-05 06:30:47) Information: Task Execute Duration=00:00:47.4522139

(2014-09-05 06:30:47) Information: TaskResult.status=Finished

(2014-09-05 06:30:47) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-09-05 06:30:47) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-09-05 06:30:47) Information: Saving Task Result

[flipside]

Have you got Document Logs enabled in the documents - these logs will tell you whereabouts in your load script it is having a problem. Try comparing a manually loaded document log with a scheduled document log (you will either need to set the logs to be timestamped or rename the first log created before creating the second log). The failed job you had may be as a result of the first task tying up resources.

EDIT: have you got any logs stored at C:\ProgramData\QlikTech\DistributionService\1\Log\20140905\ (the date folder may be numbered differently). Look for the scheduled task/time folder and there may be a DocumentLog in there for the scheduled task.

[ashfaq_haseeb]

HI,

Can you send document log of the same.

secondly do you have any antivirus software running.

Can you let me know what happens if you schedule the same task at different time?

While that task runs do some of its generating qvd's were read in some other application at the same time, If yes you need to schedule dependent tasks.

Regards

ASJFAQ