Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

adil_hussain
Contributor II

Qlikview Crashing not reloading data

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Qlikview Crashing not reloading data

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
5 Replies
adil_hussain
Contributor II

Re: Qlikview Crashing not reloading data

Q.PNG.png

erich_shiino
Honored Contributor

Re: Qlikview Crashing not reloading data

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

MVP
MVP

Re: Qlikview Crashing not reloading data

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
adil_hussain
Contributor II

Re: Qlikview Crashing not reloading data

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

ameer_hakme
New Contributor II

Re: Qlikview Crashing not reloading data

Hi,

Any explanation on why random qvps.exe are being hanged? On every reloading i'm facing this problem!

Thanks 

Community Browser