Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-09-03 09:04 AM

Reload taking too much time

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

8,039 Views
31 Replies
Anonymous
Not applicable
‎2014-09-09 02:04 AM
Author

In response to ashfaq_haseeb

Hi,

This worked finr for 2 days but im facing same problem again,now i got this error when i checked in event viewer

System.Exception: Failed to retrieve document list from the specified QVS

   at QMSBackendCore.Service.ServiceImpl.GetUserDocumentList(Guid qvsID)

   at QMSBackendCore.Service.ServiceImpl.Diagnostics.CacheDocumentAvailable()



plz guide on it

1,121 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2014-09-09 02:25 AM

In response to Anonymous

Hi,

Which of my solution works, can you specify.

Secondly can you attach document log after you schedule task from server.

Regards

ASHFAQ

1,121 Views
0 Likes
Anonymous
Not applicable
‎2014-09-09 02:53 AM
Author

In response to Anonymous

actly i restarted the qv services it wored for 2 days but now im facing same issue of reload failuer and taking too much time ,im attacing document log and task log for the one task which was taking too much time

9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      Execution started.
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      QlikView Version:11.0.11440.0
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      CPU Target                    x64
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      Operating System              Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      Wow64 mode                    Not using Wow64
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      MDAC Version                  6.1.7601.17514
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      MDAC Full Install Version     6.1.7601.17514
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      PreferredCompression          2
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      EnableParallelReload          1
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      ParallelizeQvdLoads           1
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      AutoSaveAfterReload           0
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      BackupBeforeReload            0
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      EnableFlushLog                0
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      SaveInfoWhenSavingFile        0
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      UserLogfileCharset            0
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      OdbcLoginTimeout              -1
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      OdbcConnectionTimeout         -1
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      ScriptWantsDbWrite            false
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      ScriptWantsExe                false
9/9/2014 07:15:21.3488764Information09-09-2014 07:15:21:      LogFile CodePage Used:        1252
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0002  SET ThousandSep=','
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0003  SET DecimalSep='.'
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0004  SET MoneyThousandSep=','
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0005  SET MoneyDecimalSep='.'
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0006  SET MoneyFormat='? #,##0.00;? -#,##0.00'
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0007  SET TimeFormat='hh:mm:ss'
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0008  SET DateFormat='DD-MM-YYYY'
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0009  SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]'
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
9/9/2014 07:15:21.3645011Information09-09-2014 07:15:21: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
9/9/2014 07:15:22.2394843Information09-09-2014 07:15:21: 0015  OLEDB CONNECT*Provider*XPassword*
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0023  [tmp MySeatData]:
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0024 
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0025  SQL SELECT distinct
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0026     Case when DASID like '%User without%' Then 'Seat with Printer/Server' else  DASID end as DASID
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0027    ,case when Office='' then '<Blank>'         else Office end as Office
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0028    ,ProjectName as MSPName
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0029    ,SeatType
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0030    ,ShiftText
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0031    ,Location as WSNumber
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0032    ,Case when DASID like '%User without%' Then 'Reserved'
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0033    else  Status end as Status
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0034    from
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22: 0035  BETI.dbo.MySeatData
9/9/2014 07:15:22.5676030Information09-09-2014 07:15:22:      7 fields found: DASID, Office, MSPName, SeatType, ShiftText, WSNumber,
9/9/2014 07:15:22.7863488InformationStatus, 10,012 lines fetched

task log is

9/9/2014 07:15:19.5520359InformationStarting task 'Reload and distribute  Administrator Dashboard'. Id:ef412254-0574-4e0e-8bdf-0d107cf4b9e2. Triggered by 'ScheduleTrigger'. Id:40e7c9fa-0af8-4be7-aeec-3e1c9a90f121
9/9/2014 07:15:19.5832853InformationEntering Task Execution.
9/9/2014 07:15:19.5832853InformationClusterID=1
9/9/2014 07:15:19.5832853InformationQDSID=a094f72c-abff-3f25-ac3d-cfd270785ac7
9/9/2014 07:15:19.5832853InformationTaskID=ef412254-0574-4e0e-8bdf-0d107cf4b9e2
9/9/2014 07:15:19.5832853InformationMaxRunTime=1.00:00:00
9/9/2014 07:15:19.5832853InformationMachineName=INPCG022
9/9/2014 07:15:19.5832853InformationMax attempts:1
9/9/2014 07:15:19.5832853InformationCurrent Attempt=0
9/9/2014 07:15:19.5832853InformationTask Dependencies are OK
9/9/2014 07:15:19.5989100InformationDocument is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
9/9/2014 07:15:19.5989100InformationOpening "C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw"
9/9/2014 07:15:19.5989100InformationAllocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).
9/9/2014 07:15:19.5989100InformationMax retries:5
9/9/2014 07:15:19.5989100InformationAttempt:01
9/9/2014 07:15:20.6926390InformationAllocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=33.
9/9/2014 07:15:20.6926390InformationLoading document "C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw" (1.41 Mb)
9/9/2014 07:15:21.2082541InformationPhysical FileSize=1.41 Mb. Memory Allocation Delta for this file=18.31 Mb. Available Physical Memory Before Open=5966.49 Mb. Available Physical Memory After Open=5947.14 Mb. Total Physical Memory=8191.49 Mb.
9/9/2014 07:15:21.2082541InformationAttempted to load the document without data.
9/9/2014 07:15:21.2082541InformationThe document was loaded successfully.
9/9/2014 07:15:21.2082541InformationDocument was opened successfully
9/9/2014 07:15:21.2082541InformationStarting reload
9/9/2014 07:15:21.2551282InformationQlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
9/9/2014 07:15:21.2551282InformationWaiting for the document log "C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw" to become available..
9/9/2014 07:15:21.2551282InformationThe Source Document is being reloaded. DocumentPath=C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw
9/9/2014 07:15:21.3176270InformationFound a document log. FileName=C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw.2014_09_09_07_15_21.log
9/9/2014 07:15:21.3176270InformationWriting documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140909\071519 - Reload and distribute  Administrator Dashboard\DocumentLog.txt
9/9/2014 07:15:22.2082349InformationReloading.
9/9/2014 07:15:23.2082157InformationReloading..
9/9/2014 07:15:24.2081965InformationReloading...
9/9/2014 07:15:25.2081773InformationReloading....
9/9/2014 07:15:26.2081581InformationReloading.....
9/9/2014 07:15:27.2081389InformationReloading......
9/9/2014 07:15:28.2081197InformationReloading.......
9/9/2014 07:15:29.2081005InformationReloading........
9/9/2014 07:15:30.2080813InformationReloading.........
9/9/2014 07:15:31.2080621InformationReloading..........
9/9/2014 07:15:32.2080429InformationSlow down logging. Log every <2> seconds.
9/9/2014 07:15:32.2080429InformationReloading
9/9/2014 07:15:34.2080045InformationReloading.
9/9/2014 07:15:37.5048162InformationReloading..
9/9/2014 07:15:39.5360272InformationReloading...
9/9/2014 07:15:41.5359888InformationReloading....
9/9/2014 07:15:43.5359504InformationReloading.....
9/9/2014 07:15:45.5359120InformationReloading......
9/9/2014 07:15:47.5358736InformationReloading.......
9/9/2014 07:15:49.5358352InformationReloading........
9/9/2014 07:15:51.5357968InformationReloading.........
9/9/2014 07:15:53.5357584InformationReloading..........
9/9/2014 07:15:55.5357200InformationSlow down logging. Log every <10> seconds.
9/9/2014 07:15:55.5357200InformationReloading
9/9/2014 07:16:05.5355280InformationReloading.
9/9/2014 07:16:15.5353360InformationReloading..
9/9/2014 07:16:25.5351440InformationReloading...
9/9/2014 07:16:35.5349520InformationReloading....
9/9/2014 07:16:45.5503847InformationReloading.....
9/9/2014 07:16:55.5814421InformationReloading......
9/9/2014 07:17:06.7218532InformationReloading.......
9/9/2014 07:17:16.7216612InformationReloading........
9/9/2014 07:17:26.7214692InformationReloading.........
9/9/2014 07:17:36.7212772InformationReloading..........
9/9/2014 07:17:46.7210852InformationSlow down logging. Log every <60> seconds.
9/9/2014 07:17:46.7210852InformationReloading
9/9/2014 07:18:47.1105507InformationReloading.
9/9/2014 07:19:47.3437692InformationReloading..
9/9/2014 07:20:47.9207311InformationReloading...
9/9/2014 07:21:48.3414460InformationReloading....
9/9/2014 07:22:48.3402940InformationReloading.....
9/9/2014 07:23:49.0735029InformationReloading......
9/9/2014 07:24:50.2285787InformationReloading.......
9/9/2014 07:25:51.2058581InformationReloading........
9/9/2014 07:26:51.2792021InformationReloading.........
9/9/2014 07:27:52.6197182InformationReloading..........
9/9/2014 07:28:54.1010312InformationSlow down logging. Log every <300> seconds.
9/9/2014 07:28:54.1010312InformationReloading
9/9/2014 07:33:54.9262191InformationReloading.
9/9/2014 07:38:58.4221809InformationReloading..
9/9/2014 07:43:59.6320481InformationReloading...
9/9/2014 07:49:01.2779411InformationReloading....
9/9/2014 07:54:04.3229081InformationReloading.....
9/9/2014 07:59:07.9739654InformationReloading......
9/9/2014 08:04:10.4837821InformationReloading.......
9/9/2014 08:09:14.3529477InformationReloading........
9/9/2014 08:14:16.8783891InformationReloading.........
9/9/2014 08:19:20.1694408InformationReloading..........
9/9/2014 08:24:25.3823306InformationSlow down logging. Log every <600> seconds.
9/9/2014 08:24:25.3823306InformationReloading
9/9/2014 08:34:30.0738453InformationReloading.
9/9/2014 08:44:38.0309223InformationReloading..
9/9/2014 08:54:44.8005221InformationReloading...
9/9/2014 09:04:50.4920176InformationReloading....
9/9/2014 09:14:57.6834843InformationReloading.....
9/9/2014 09:25:02.1093791InformationReloading......
9/9/2014 09:35:09.3008458InformationReloading.......
9/9/2014 09:45:14.9923413InformationReloading........
9/9/2014 09:55:21.5119459InformationReloading.........
9/9/2014 10:05:29.1252795InformationReloading..........
9/9/2014 10:15:36.2542474InformationSlow down logging. Log every <900> seconds.
9/9/2014 10:15:36.2542474InformationReloading
9/9/2014 10:30:47.5804996InformationReloading.
9/9/2014 10:45:57.6724005InformationReloading..
9/9/2014 10:50:29.1984371WarningThe QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).
9/9/2014 10:50:29.1984371InformationKilling the QlikView Engine. ProcessID=4992
9/9/2014 10:50:29.1984371InformationReload was aborted.
9/9/2014 10:50:29.3078100InformationClosed the QlikView Engine successfully. ProcessID=4992
9/9/2014 10:50:29.3703088ErrorThe task "Reload and distribute  Administrator Dashboard" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted.

   at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)

   at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)

   at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle)

   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)

9/9/2014 10:50:29.3859335ErrorTask failed with exception
9/9/2014 10:50:29.3859335ErrorException=The currently executing operation was aborted.
9/9/2014 10:50:29.3859335InformationTaskResult.status=Finished
9/9/2014 10:50:29.4171829InformationNotifying all triggers of new state:FinishedWithErrors
9/9/2014 10:50:29.4171829InformationNotifying all triggers of new state:FinishedWithErrors - completed
9/9/2014 10:50:29.4328076InformationSaving Task Result
1,123 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2014-09-09 03:05 AM

In response to Anonymous

Hi,

I have seen logs again I would like to re-quote  my reply

Do you have any antivirus software running, Then make sure to eliminate C:\Programdata\Qliktech folder from scanning.

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

1,123 Views
0 Likes
Anonymous
Not applicable
‎2014-09-09 03:12 AM
Author

In response to ashfaq_haseeb
  • actly i am fetching data from database, no qvds are generating in this dashboard,
  • i hv antivirus on server,but how to eliminate folder from scanning
  • if the problem was with antivirus then how it worked in past with same antivirus settings
  • when i schedule the same task on different time it workes fine like normal task

1,123 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2014-09-09 03:19 AM

In response to Anonymous

harshal hajare wrote:

  • actly i am fetching data from database, no qvds are generating in this dashboard,

This is not suggested at all, Always have a 3 tier Architecture to build your QlikView applications.

Step 1 DB fetch whit no or some transformations

Step 2 Transformations / ETL

Step 3 Optimized qvd loads for better performance.

harshal hajare wrote:

i hv antivirus on server,but how to eliminate folder from scanning

For this you need to talk with your security guys or sysadmins.

and make sure your server is not hosted in shared SAN drive, if yes try by moving it to server locally and check if that helped.

harshal hajare wrote:

  • if the problem was with antivirus then how it worked in past with same antivirus settings
  • when i schedule the same task on different time it workes fine like normal task

Its not blocking you always, may be you have scanning schedule or what i'm not sure you need to check with security or sysadmins.

Hope it helps.

If it answered your questions, make sure to close this thread.

Regards

ASHFAQ

4,893 Views
0 Likes
Anonymous
Not applicable
‎2014-09-09 03:19 AM
Author

In response to Anonymous

this is the Task  log of task scheduled on different time plz check

9/9/2014 12:45:27.5972353InformationStarting task 'Reload and distribute  Administrator Dashboard'. Id:ef412254-0574-4e0e-8bdf-0d107cf4b9e2. Triggered by 'ScheduleTrigger'. Id:43371ed0-4d59-4f6b-8302-37f3166ba6af
9/9/2014 12:45:27.6284847InformationEntering Task Execution.
9/9/2014 12:45:27.6284847InformationClusterID=1
9/9/2014 12:45:27.6284847InformationQDSID=a094f72c-abff-3f25-ac3d-cfd270785ac7
9/9/2014 12:45:27.6284847InformationTaskID=ef412254-0574-4e0e-8bdf-0d107cf4b9e2
9/9/2014 12:45:27.6284847InformationMaxRunTime=1.00:00:00
9/9/2014 12:45:27.6284847InformationMachineName=INPCG022
9/9/2014 12:45:27.6284847InformationMax attempts:1
9/9/2014 12:45:27.6284847InformationCurrent Attempt=0
9/9/2014 12:45:27.6284847InformationTask Dependencies are OK
9/9/2014 12:45:27.6441094InformationDocument is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
9/9/2014 12:45:27.6441094InformationOpening "C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw"
9/9/2014 12:45:27.6441094InformationAllocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).
9/9/2014 12:45:27.6441094InformationMax retries:5
9/9/2014 12:45:27.6441094InformationAttempt:01
9/9/2014 12:45:28.4409691InformationAllocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=3.
9/9/2014 12:45:28.4409691InformationLoading document "C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw" (1.41 Mb)
9/9/2014 12:45:28.9097101InformationPhysical FileSize=1.41 Mb. Memory Allocation Delta for this file=18.30 Mb. Available Physical Memory Before Open=6105.29 Mb. Available Physical Memory After Open=6084.12 Mb. Total Physical Memory=8191.49 Mb.
9/9/2014 12:45:28.9097101InformationAttempted to load the document without data.
9/9/2014 12:45:28.9097101InformationThe document was loaded successfully.
9/9/2014 12:45:28.9097101InformationDocument was opened successfully
9/9/2014 12:45:28.9097101InformationStarting reload
9/9/2014 12:45:28.9565842InformationQlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
9/9/2014 12:45:28.9565842InformationWaiting for the document log "C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw" to become available..
9/9/2014 12:45:28.9565842InformationThe Source Document is being reloaded. DocumentPath=C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw
9/9/2014 12:45:29.0190830InformationFound a document log. FileName=C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw.2014_09_09_12_45_28.log
9/9/2014 12:45:29.0190830InformationWriting documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140909\124527 - Reload and distribute  Administrator Dashboard\DocumentLog.txt
9/9/2014 12:45:29.9096909InformationReloading.
9/9/2014 12:45:30.9096717InformationReloading..
9/9/2014 12:45:31.9096525InformationReloading...
9/9/2014 12:45:32.9096333InformationReloading....
9/9/2014 12:45:33.9096141InformationReloading.....
9/9/2014 12:45:34.9095949InformationReloading......
9/9/2014 12:45:35.9095757InformationReloading.......
9/9/2014 12:45:36.3158179InformationThe Source Document reload complete. DocumentPath=C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw
9/9/2014 12:45:36.3158179InformationMemory Allocation Delta for this file=139.63 Mb. Available Physical Memory Before Reload=6084.11 Mb. Available Physical Memory After Reload=5950.50 Mb. Total Physical Memory=5950.50 Mb.
9/9/2014 12:45:36.9095565InformationReloading........
9/9/2014 12:45:37.0189294InformationThe Source Document was reloaded successfully.
9/9/2014 12:45:37.0970529InformationReload finished successfully
9/9/2014 12:45:37.0970529InformationStart saving document
9/9/2014 12:45:39.7532519InformationCheck in document: C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw
9/9/2014 12:45:39.8001260InformationClosing the document.
9/9/2014 12:45:40.4407387InformationClosed the QlikView Engine successfully. ProcessID=6164
9/9/2014 12:45:40.4407387InformationStart document distribution.
9/9/2014 12:45:40.4407387InformationOpening source document
9/9/2014 12:45:40.4407387InformationOpening document: "AdministratorDashboard.qvw"
9/9/2014 12:45:40.4407387InformationAllocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).
9/9/2014 12:45:40.4407387InformationMax retries:5
9/9/2014 12:45:40.4407387InformationAttempt:01
9/9/2014 12:45:41.6438406InformationAllocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=4.
9/9/2014 12:45:41.6438406InformationLoading document "C:\QlikView\Dev\Admin\Dashboards\AdministratorDashboard.qvw" (1.41 Mb)
9/9/2014 12:45:42.6438214InformationLoading. LoadTime=00:00:00.9999808
9/9/2014 12:45:43.2844341InformationPhysical FileSize=1.41 Mb. Memory Allocation Delta for this file=22.66 Mb. Available Physical Memory Before Open=5950.11 Mb. Available Physical Memory After Open=6077.91 Mb. Total Physical Memory=8191.49 Mb.
9/9/2014 12:45:43.3000588InformationAttempted to load the document with data.
9/9/2014 12:45:43.3000588InformationThe document was loaded successfully.
9/9/2014 12:45:43.3469329InformationReduce skipped, nothing is selected.
9/9/2014 12:45:43.3469329InformationDocument was opened successfully
9/9/2014 12:45:43.3469329InformationDetermined 2 static recipients spread over 1 Distribution Resources.
9/9/2014 12:45:43.3469329InformationNumber of rule combinations was calculated successfully. Rounds=1
9/9/2014 12:45:43.3469329InformationEmpty rules
9/9/2014 12:45:43.3469329InformationRules resulted in distribution.
9/9/2014 12:45:43.3469329InformationROUND: 0 of 1. WarningCount=0
9/9/2014 12:45:43.3469329InformationBuilding filename
9/9/2014 12:45:43.3469329InformationDestination name: AdministratorDashboard.qvw
9/9/2014 12:45:43.3469329InformationSet script
9/9/2014 12:45:43.3938070InformationResetting of the Document Script for the Distributed Document was successful. ScriptType=Clear
9/9/2014 12:45:43.3938070InformationOffer resources
9/9/2014 12:45:43.4406811InformationCommencing ReduceData
9/9/2014 12:45:44.0031703InformationCompleted ReduceData
9/9/2014 12:45:44.0031703InformationMemory Allocation Delta for this file=1.39 Mb. Available Physical Memory Before Reduce=6077.81 Mb. Available Physical Memory After Reduce=6073.35 Mb. Total Physical Memory=6073.35 Mb.
9/9/2014 12:45:44.0031703InformationDistributing
9/9/2014 12:45:44.0031703InformationDistributing using resource "Reload and distribute  Administrator Dashboard_QVS_1".
9/9/2014 12:45:44.0031703InformationTrying to distribute. QVS=qvp://inpcg022/
9/9/2014 12:45:44.0031703InformationConnecting to QlikView Server. Address=inpcg022:4747
9/9/2014 12:45:46.2843765InformationSuccessfully connected to QlikView Server. Address=inpcg022:4747
9/9/2014 12:45:46.3312506InformationCreating/Updating file: qvp://inpcg022/AdministratorDashboard.qvw
9/9/2014 12:45:46.3312506Information<request monitor="Performance"/>
9/9/2014 12:45:46.3468753Information<?xml version="1.0" encoding="UTF-8" ?><Performance><ExeType>RLS64</ExeType><ExeVersion>11.0.11440.0409.10</ExeVersion><Timestamp>2014-09-09 12:45:46</Timestamp><DocSessions>0</DocSessions><AnonymousDocSessions>0</AnonymousDocSessions><TunneledDocSessions>0</TunneledDocSessions><DocSessionStartsSinceMidnight>1</DocSessionStartsSinceMidnight><RefDocs>0</RefDocs><LoadedDocs>1</LoadedDocs><IpAddrs>0</IpAddrs><Users>0</Users><CPULoad>0</CPULoad><VMCommitted>108.128906</VMCommitted><VMAllocated>236.953125</VMAllocated><VMFree>6074.824219</VMFree><VMLargestFreeBlock>6074.824219</VMLargestFreeBlock><UsageCalBalance>-1.000000</UsageCalBalance><TimeZoneBias>-330</TimeZoneBias></Performance>
9/9/2014 12:45:46.3468753Information<Global method="FileUpload"><Path>AdministratorDashboard.qvw</Path></Global>
9/9/2014 12:45:46.3468753Information<Global><_retval_>0</_retval_></Global>
9/9/2014 12:45:46.4093741Information<Global method="FileWrite"><h>0</h><Pos>0</Pos><Buffer /></Global>
9/9/2014 12:45:46.6593693InformationExecuteWithAttachments returned no data in buffer.
9/9/2014 12:45:46.6593693Information<Global></Global>
9/9/2014 12:45:46.6593693Information<Global method="FileWrite"><h>0</h><Pos>1480448</Pos><Buffer /></Global>
9/9/2014 12:45:46.6593693InformationExecuteWithAttachments returned no data in buffer.
9/9/2014 12:45:46.6593693Information<Global></Global>
9/9/2014 12:45:46.6593693Information<Global method="FileCloseWithMetaData"><h>0</h><Data><Category>Default</Category><Description></Description><LastUpdate>41891.3025925926</LastUpdate><NextUpdate>41892.0731365741</NextUpdate><Clients>5</Clients><RestrictDownload>false</RestrictDownload><AccessList><MetaServiceAccessData><Anonymous>false</Anonymous><User>QV\QV_SEAT_ADMIN</User><Allow>0</Allow></MetaServiceAccessData><MetaServiceAccessData><Anonymous>false</Anonymous><User>QV\QV_SUPER_USER</User><Allow>0</Allow></MetaServiceAccessData></AccessList><AjaxUrl></AjaxUrl><EventDriven>false</EventDriven><MaxOpenSessions>-1</MaxOpenSessions><SessionTimeout>0</SessionTimeout><DocumentTimeoutMinutes>0</DocumentTimeoutMinutes><EnableSessionCollaboration>false</EnableSessionCollaboration><LoadGranularityMode>0</LoadGranularityMode><DocumentLoadInfo><DocumentLoadInfo><Mode>0</Mode><ServerId>INPCG022</ServerId></DocumentLoadInfo></DocumentLoadInfo><EnableServerObjectsCreation>0</EnableServerObjectsCreation><ServerObjectsUsers /><EnableAuditLog>true</EnableAuditLog><RestrictExport>0</RestrictExport><SourceName>AdministratorDashboard.qvw</SourceName></Data><Part>39</Part><AjaxFolder></AjaxFolder></Global>
9/9/2014 12:45:46.6749940Information<Global></Global>
9/9/2014 12:45:46.6749940InformationPerformance data (CopyFile): Connecting to QVS. (0), DMSAccessRules=2 (0), Uploading file: AdministratorDashboard.qvw (16), Write complete. (1480448 bytes processed) (328)
9/9/2014 12:45:46.6749940InformationQVS Distribution completed with success.
9/9/2014 12:45:46.6749940InformationDistribution finished successfully.
9/9/2014 12:45:46.6749940InformationDeleting temporary files.
9/9/2014 12:45:46.7218681InformationClosing the document.
9/9/2014 12:45:47.3624808InformationClosed the QlikView Engine successfully. ProcessID=2396
9/9/2014 12:45:47.3624808InformationDocument distribution done.
9/9/2014 12:45:47.3624808InformationTask Execute Duration=00:00:19.7339961
9/9/2014 12:45:47.3624808InformationThe task "Reload and distribute  Administrator Dashboard" finished successfully
9/9/2014 12:45:47.3624808InformationTaskResult.status=Finished
9/9/2014 12:45:47.3781055InformationNotifying all triggers of new state:Finished
9/9/2014 12:45:47.3781055InformationNotifying all triggers of new state:Finished - completed
9/9/2014 12:45:47.3937302InformationSaving Task Result
1,123 Views
0 Likes
flipside
Partner - Specialist II
Partner - Specialist II
‎2014-09-09 03:58 AM

In response to Anonymous

In the task log you posted, there is a line which tells you where your document log is written - this is not the same as the task log and will tell you exactly where in your script it is failing.

9/9/2014 07:15:21.3176270InformationWriting documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140909\071519 - Reload and distribute  Administrator Dashboard\DocumentLog

These logs are kept for 30 days (default) so you can look at all the failures in that period to see if it happens at the same point in the script each time.

Whilst Ashfaq's points are valid, I wouldn't change anything yet until you at least narrow down the possibilities of the error.

EDIT: My error - I see you attached the document log on an earlier post - still it's worth checking it's failing at the same stage each time.

1,123 Views
0 Likes
flipside
Partner - Specialist II
Partner - Specialist II
‎2014-09-09 04:13 AM

In response to flipside

Do all your document logs just end like your example? Normally if there's an error they'll say so in the last line.

1,123 Views
0 Likes
Anonymous
Not applicable
‎2014-09-09 04:47 AM
Author

In response to flipside

i hv documents log enabled,actly sql query is taking time in my dashboard ,,i think because of some other task is running over those SQL tables at the time of reload of qv db,,,i hv rescheduled the db lets see wat happen tomorrow morning,,,suggest anything u hv on it

1,123 Views
0 Likes