Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I am loading a extract file.
When it picks ups all the data drops them into a loaction and save them as a QVD table name.
This has worked fine but today had major problems because when running the script everything seems to load fine but when it comes to saving, on a reload i get a crash right at this point at the end of the script and goes to Reload old Data pop up.
The loaction it is being saved to exists and nothing has changed so does anyone know why all of a sudden this is happening.
We have Qlikview Publisher V11, there is a schedule for this job but i get in the error log
(2014-03-05 11:19:31) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\QlikView Storage\Production\Data Source\QVD_SYSTEM\RAW_To_QVD_Common_DB.qvw.
(2014-03-05 11:19:31) Information: Closing the document.
(2014-03-05 11:19:32) Information: Closed the QlikView Engine successfully. ProcessID=9652
(2014-03-05 11:19:32) Error: The task "\LIVE\RAW_To_QVD_Common_DB.qvw" failed. Exception:
(2014-03-05 11:19:32) Error: 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\Production\Data Source\QVD_SYSTEM\_RAW_To_QVD_Common_DB.qvw.
(2014-03-05 11:19:32) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)
(2014-03-05 11:19:32) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-03-05 11:19:32) Error: --- End of inner exception stack trace ---
(2014-03-05 11:19:32) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-03-05 11:19:32) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-03-05 11:19:32) Error: --- End of inner exception stack trace ---
(2014-03-05 11:19:32) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-03-05 11:19:32) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2014-03-05 11:19:32) Information: Task Execute Duration=00:02:19.2060798
(2014-03-05 11:19:32) Information: Sending Alert mail
(2014-03-05 11:19:33) Information: TaskResult.status=Finished
(2014-03-05 11:19:33) Information: Notifying all triggers of new state:FinishedWithErrors
(2014-03-05 11:19:33) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2014-03-05 11:19:33) Information: Saving Task Result
Last updated @ 05/03/2014 11:51:25 Automatic refresh of task list Refresh
Hi
Check that there is no process owning a lock on the file. Possibly a qv.exe or qvb.exe (server batch) process which has hung while holding a lock on the file. Check in Task Manager and if you can, kill any unknown or hung qv.exe processes. Be carefull killing qvb.exe processes, it could affect you scheduled loads.
HTH
Jonathan
Hi,
Please, include the qvw reload log here.
You can enable it at Menu Settings -> Document Settings -> General Tab -> Enable Log file
The log file will have the same name of the qvw and the extension .log
Best Regards,
Erich
Hi
Check that there is no process owning a lock on the file. Possibly a qv.exe or qvb.exe (server batch) process which has hung while holding a lock on the file. Check in Task Manager and if you can, kill any unknown or hung qv.exe processes. Be carefull killing qvb.exe processes, it could affect you scheduled loads.
HTH
Jonathan
This was it!!!
Fixed my issue a the copy of prod to dev run over night and put a lock on the files after seeing this comment fixed it!
Thanks your your help
Hi,
Any explanation on why random qvps.exe are being hanged? On every reloading i'm facing this problem!
Thanks