Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.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.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
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
Hi Theo
Please post the log file from D:\Qlikview Storage\Live server models\
Lukasz
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
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.
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
Are you talking about the folder where the Access database is held?
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
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
Yes... check the shared folder
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.