topic Re: Reload task error in QlikView

Reload task error

Tue, 01 Apr 2014 11:40:16 GMT

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.0306197	Information	Starting task 'Productivity3.qvw'. Id:e4ca950e-9596-4c93-b6bf-893c45f0fe92. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
2014/04/01 09:04:25.0306197	Information	Entering Task Execution.
2014/04/01 09:04:25.0306197	Information	ClusterID=1
2014/04/01 09:04:25.0306197	Information	QDSID=e5aa9590-29c5-0208-1b10-55fb74ceddc8
2014/04/01 09:04:25.0306197	Information	TaskID=e4ca950e-9596-4c93-b6bf-893c45f0fe92
2014/04/01 09:04:25.0306197	Information	MaxRunTime=06:00:00
2014/04/01 09:04:25.0306197	Information	MachineName=SRCCQV01
2014/04/01 09:04:25.0306197	Information	Max attempts:1
2014/04/01 09:04:25.0306197	Information	Current Attempt=0
2014/04/01 09:04:25.0306197	Information	Task Dependencies are OK
2014/04/01 09:04:25.0774953	Information	Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
2014/04/01 09:04:25.0774953	Information	Opening "D:\Qlikview Storage\Live server models\Productivity3.qvw"
2014/04/01 09:04:25.0931205	Information	Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
2014/04/01 09:04:25.0931205	Information	Max retries:5
2014/04/01 09:04:25.0931205	Information	Attempt:01
2014/04/01 09:04:26.5775145	Information	Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=493.
2014/04/01 09:04:26.5775145	Information	Loading document "D:\Qlikview Storage\Live server models\Productivity3.qvw" (185.94 Mb)
2014/04/01 09:04:27.2337729	Information	Physical 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.2337729	Information	Attempted to load the document without data.
2014/04/01 09:04:27.2337729	Information	The document was loaded successfully.
2014/04/01 09:04:27.2337729	Information	Document was opened successfully
2014/04/01 09:04:27.2337729	Information	Starting reload
2014/04/01 09:04:27.2806485	Information	QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
2014/04/01 09:04:27.2806485	Information	The Source Document is being reloaded. DocumentPath=D:\Qlikview Storage\Live server models\Productivity3.qvw
2014/04/01 09:04:27.9056565	Information	The Source Document reload complete. DocumentPath=D:\Qlikview Storage\Live server models\Productivity3.qvw
2014/04/01 09:04:27.9056565	Information	Memory 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.1244093	Error	The Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview Storage\Live server models\Productivity3.qvw.
2014/04/01 09:04:28.1400345	Information	Closing the document.
2014/04/01 09:04:28.7650425	Information	Closed the QlikView Engine successfully. ProcessID=4688
2014/04/01 09:04:28.7650425	Error	The 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.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.7650425	Information	Task Execute Duration=00:00:03.7344228
2014/04/01 09:04:28.7650425	Information	Sending Alert mail
2014/04/01 09:04:29.1400473	Information	TaskResult.status=Finished
2014/04/01 09:04:29.1400473	Information	Notifying all triggers of new state:FinishedWithErrors
2014/04/01 09:04:29.1400473	Information	Notifying all triggers of new state:FinishedWithErrors - completed
2014/04/01 09:04:29.1400473	Information	Saving Task Result

Thanks

Theo

Re: Reload task error

Tue, 01 Apr 2014 11:45:57 GMT

Hi Theo

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

Lukasz

Re: Reload task error

maxgro — Tue, 01 Apr 2014 11:47:51 GMT

2014/04/01 09:04:27.2806485

Information

QlikView->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

Re: Reload task error

Tue, 01 Apr 2014 12:00:36 GMT

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.

Re: Reload task error

sivarajs — Tue, 01 Apr 2014 12:11:42 GMT

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

Re: Reload task error

Tue, 01 Apr 2014 12:18:57 GMT

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

Re: Reload task error

nizamsha — Tue, 01 Apr 2014 12:25:13 GMT

Here is the original problem from here

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

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

its_anandrjs — Tue, 01 Apr 2014 12:25:18 GMT

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

Re: Reload task error

sivarajs — Tue, 01 Apr 2014 12:57:17 GMT

Yes... check the shared folder

Re: Reload task error

Tue, 01 Apr 2014 13:06:29 GMT

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.

Re: Reload task error

Wed, 02 Apr 2014 13:44:26 GMT

Thank you Sivaraj it works!