Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Reload task error

Hi guys,

I have this error on reloading a task? If I open the model up on the server in Qlikview development and reload it there is works fine. Other QVWs load fine. This productivity3.qvd is a new model I just added.

2014/04/01 09:04:25.0306197InformationStarting task 'Productivity3.qvw'. Id:e4ca950e-9596-4c93-b6bf-893c45f0fe92. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
2014/04/01 09:04:25.0306197InformationEntering Task Execution.
2014/04/01 09:04:25.0306197InformationClusterID=1
2014/04/01 09:04:25.0306197InformationQDSID=e5aa9590-29c5-0208-1b10-55fb74ceddc8
2014/04/01 09:04:25.0306197InformationTaskID=e4ca950e-9596-4c93-b6bf-893c45f0fe92
2014/04/01 09:04:25.0306197InformationMaxRunTime=06:00:00
2014/04/01 09:04:25.0306197InformationMachineName=SRCCQV01
2014/04/01 09:04:25.0306197InformationMax attempts:1
2014/04/01 09:04:25.0306197InformationCurrent Attempt=0
2014/04/01 09:04:25.0306197InformationTask Dependencies are OK
2014/04/01 09:04:25.0774953InformationDocument is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
2014/04/01 09:04:25.0774953InformationOpening "D:\Qlikview Storage\Live server models\Productivity3.qvw"
2014/04/01 09:04:25.0931205InformationAllocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
2014/04/01 09:04:25.0931205InformationMax retries:5
2014/04/01 09:04:25.0931205InformationAttempt:01
2014/04/01 09:04:26.5775145InformationAllocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=493.
2014/04/01 09:04:26.5775145InformationLoading document "D:\Qlikview Storage\Live server models\Productivity3.qvw" (185.94 Mb)
2014/04/01 09:04:27.2337729InformationPhysical FileSize=185.94 Mb. Memory Allocation Delta for this file=11.61 Mb. Available Physical Memory Before Open=3170.32 Mb. Available Physical Memory After Open=3155.23 Mb. Total Physical Memory=4095.55 Mb.
2014/04/01 09:04:27.2337729InformationAttempted to load the document without data.
2014/04/01 09:04:27.2337729InformationThe document was loaded successfully.
2014/04/01 09:04:27.2337729InformationDocument was opened successfully
2014/04/01 09:04:27.2337729InformationStarting reload
2014/04/01 09:04:27.2806485InformationQlikView->Settings->Document Peferences->Generate Logfile in document is not set.
2014/04/01 09:04:27.2806485InformationThe Source Document is being reloaded. DocumentPath=D:\Qlikview Storage\Live server models\Productivity3.qvw
2014/04/01 09:04:27.9056565InformationThe Source Document reload complete. DocumentPath=D:\Qlikview Storage\Live server models\Productivity3.qvw
2014/04/01 09:04:27.9056565InformationMemory Allocation Delta for this file=1.07 Mb. Available Physical Memory Before Reload=3155.21 Mb. Available Physical Memory After Reload=3146.27 Mb. Total Physical Memory=3146.27 Mb.
2014/04/01 09:04:28.1244093ErrorThe Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview Storage\Live server models\Productivity3.qvw.
2014/04/01 09:04:28.1400345InformationClosing the document.
2014/04/01 09:04:28.7650425InformationClosed the QlikView Engine successfully. ProcessID=4688
2014/04/01 09:04:28.7650425ErrorThe task "Productivity3.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 Storage\Live server models\Productivity3.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)

2014/04/01 09:04:28.7650425InformationTask Execute Duration=00:00:03.7344228
2014/04/01 09:04:28.7650425InformationSending Alert mail
2014/04/01 09:04:29.1400473InformationTaskResult.status=Finished
2014/04/01 09:04:29.1400473InformationNotifying all triggers of new state:FinishedWithErrors
2014/04/01 09:04:29.1400473InformationNotifying all triggers of new state:FinishedWithErrors - completed
2014/04/01 09:04:29.1400473InformationSaving Task Result

Thanks

Theo

1 Solution

Accepted Solutions
sivarajs
Valued Contributor II

Re: Reload task error

Seems like the permission error.

The userid running the QV Services needs write access to the directory.

Right click on shared folder and set the permission on folders as full

View solution in original post

10 Replies
Not applicable

Re: Reload task error

Hi Theo

Please post the log file from D:\Qlikview Storage\Live server models\

Lukasz

MVP
MVP

Re: Reload task error

2014/04/01 09:04:27.2806485InformationQlikView->Settings->Document Peferences->Generate Logfile in document is not set.

open your Qlik doc

in Document Properties  --> General -->

check Generate Logfile

reload

and post the log file (same folder) with the error

Not applicable

Re: Reload task error

Thanks for the quick reply guys! It complains about the Access database but it doesn't have a password on it?

01/04/2014 13:56:15:      Execution started.

01/04/2014 13:56:15:      QlikView Version:11.20.11718.0

01/04/2014 13:56:15:      CPU Target                    x64

01/04/2014 13:56:15:      Operating System              Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)

01/04/2014 13:56:15:      Wow64 mode                    Not using Wow64

01/04/2014 13:56:15:      MDAC Version                  6.1.7601.17514

01/04/2014 13:56:15:      MDAC Full Install Version     6.1.7601.17514

01/04/2014 13:56:15:      PreferredCompression          2

01/04/2014 13:56:15:      EnableParallelReload          1

01/04/2014 13:56:15:      ParallelizeQvdLoads           1

01/04/2014 13:56:15:      AutoSaveAfterReload           0

01/04/2014 13:56:15:      BackupBeforeReload            0

01/04/2014 13:56:15:      EnableFlushLog                0

01/04/2014 13:56:15:      SaveInfoWhenSavingFile        0

01/04/2014 13:56:15:      UserLogfileCharset            1200

01/04/2014 13:56:15:      OdbcLoginTimeout              -1

01/04/2014 13:56:15:      OdbcConnectionTimeout         -1

01/04/2014 13:56:15:      ScriptWantsDbWrite            false

01/04/2014 13:56:15:      ScriptWantsExe                false

01/04/2014 13:56:15:      LogFile CodePage Used:        1200

01/04/2014 13:56:15: 0002  SET ThousandSep=' '

01/04/2014 13:56:15: 0003  SET DecimalSep='.'

01/04/2014 13:56:15: 0004  SET MoneyThousandSep=' '

01/04/2014 13:56:15: 0005  SET MoneyDecimalSep=','

01/04/2014 13:56:15: 0006  SET MoneyFormat='R # ##0,00;R-# ##0,00'

01/04/2014 13:56:15: 0007  SET TimeFormat='hh:mm:ss'

01/04/2014 13:56:15: 0008  SET DateFormat='DD/MM/YYYY'

01/04/2014 13:56:15: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

01/04/2014 13:56:15: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

01/04/2014 13:56:15: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

01/04/2014 13:56:15: 0013  OLEDB CONNECT*Provider*Password*Password*

01/04/2014 13:56:16:       Error: ErrorSource: Microsoft Access Database Engine, ErrorMsg: The Microsoft Access database engine cannot open or write to the file '\\srccfile01\HEEAdmin\ProductionReporting\Production 2005 Jo-Anne.mdb'. It is already opened exclusively by another user, or you need permission to view and write its data.

01/04/2014 13:56:16:       General Script Error

01/04/2014 13:56:16:       Execution Failed

01/04/2014 13:56:16:      Execution finished.

sivarajs
Valued Contributor II

Re: Reload task error

Seems like the permission error.

The userid running the QV Services needs write access to the directory.

Right click on shared folder and set the permission on folders as full

View solution in original post

Not applicable

Re: Reload task error

Are you talking about the folder where the Access database is held?

nizamsha
Valued Contributor II

Re: Reload task error

Here is the original problem  from here

01/04/2014 13:56:15: 0013  OLEDB CONNECT*Provider*Password*Password*

01/04/2014 13:56:16:       Error: ErrorSource: Microsoft Access Database Engine, ErrorMsg: The Microsoft Access database engine cannot open or write to the file '\\srccfile01\HEEAdmin\ProductionReporting\Production 2005 Jo-Anne.mdb'. It is already opened exclusively by another user, or you need permission to view and write its data.

while giving  OLEDB connection string u need to give user name and password  there u have check box,allow blank password check that one and then load  .so when u load each and every time it will take the password what u given before that might be the problem

Re: Reload task error

May be the access file is not properly closed by user or may be it is open and not saved properly so please check that one and also check ms-access file permission that it is permission of read and write

Hope this helps

Thanks & Regards

sivarajs
Valued Contributor II

Re: Reload task error

Yes... check the shared folder

Not applicable

Re: Reload task error

Is there a way to get the services userid? I've spoken to the network admin and he will give that user access but I don't know where to get it.