Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

QMC not able to Reload Single QVW file

Hi all,

through QMC , not single QVW is able to reload.

actually My Production and Development server is same. Once Server was Hang due to high memory consumption and My DC team restart the server.

after restarting the server QMC is not able to Reload single QVW file.

i have Done so many changes to sort out this problem like upgrade SR version for desktop , Server and SAP connector.

but still problem not solved.

manually reload is happening.

Please Help me in that.

23 Replies
Peter_Cammaert

Can you recover a DocumentLog from a QVW that reloads under task control but doesn't stop? QDS keeps log files for 30 days. If not, in QMC press the play button and let the taks run for a while. Make sure that the run time is longer than the expected run time (see Task History). Then kill the task and recover the DocumentLog. We need to know what the last lines in this log file are.

abhaysingh
Specialist II
Specialist II
Author

Peter pls find below logs as u suggest

(2015-01-12 15:29:09) Information: Loading. LoadTime=03:43:08.4731712

(2015-01-12 15:30:09) Information: Loading. LoadTime=03:44:08.4853829

(2015-01-12 15:31:09) Information: Loading. LoadTime=03:45:08.5187827

(2015-01-12 15:32:09) Information: Loading. LoadTime=03:46:08.5278599

(2015-01-12 15:33:09) Information: Loading. LoadTime=03:47:08.5507069

(2015-01-12 15:34:09) Information: Loading. LoadTime=03:48:08.5848875

(2015-01-12 15:35:09) Information: Loading. LoadTime=03:49:08.5910253

(2015-01-12 15:36:09) Information: Loading. LoadTime=03:50:08.5994436

(2015-01-12 15:37:09) Information: Loading. LoadTime=03:51:08.6255274

(2015-01-12 15:38:09) Information: Loading. LoadTime=03:52:08.6358627

(2015-01-12 15:39:09) Information: Loading. LoadTime=03:53:08.6467181

(2015-01-12 15:40:09) Information: Loading. LoadTime=03:54:08.6525841

(2015-01-12 15:41:09) Information: Loading. LoadTime=03:55:08.6719080

(2015-01-12 15:42:09) Information: Loading. LoadTime=03:56:08.6935958

(2015-01-12 15:43:09) Information: Loading. LoadTime=03:57:08.7073962

(2015-01-12 15:44:09) Information: Loading. LoadTime=03:58:08.7303481

(2015-01-12 15:45:09) Information: Loading. LoadTime=03:59:08.7412465

(2015-01-12 15:45:54) Error: Document open threw an exception. Exception=The currently executing operation was aborted.

(2015-01-12 15:45:54) Error: The sourcedocument failed to open.. Exception=System.Runtime.InteropServices.COMException (0x80010108): The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))

(2015-01-12 15:45:54) Error: at QlikView.IUserPreferences.set_SMTPServer(String _SMTPServer)

(2015-01-12 15:45:54) Error: at QVBWrapper.Document.Load(ILogBucket i_LogBucket, Boolean withData)

(2015-01-12 15:45:54) Information: Attempted to load the document without data.

(2015-01-12 15:45:54) Error: The document failed to open.

(2015-01-12 15:45:54) Information: Closed the QlikView Engine successfully. ProcessID=1264

(2015-01-12 15:45:55) Information: Closed the QlikView Engine successfully. ProcessID=1264

(2015-01-12 15:45:55) Information: Failed to check in document: C:\Shalimar Data Back Server\N 270614\Shalimar\APP\FINAL\CAP.qvw

(2015-01-12 15:45:55) Error: The task "CAP.qvw" failed. Exception:

(2015-01-12 15:45:55) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted.

(2015-01-12 15:45:55) Error: at QVBWrapper.DocumentPool.Checkout(ILogBucket logBucket, eCheckoutMode checkoutMode, String fileName, Boolean clearAll, Boolean clearLocks, Boolean clearOneAndOnlyOnes, Boolean reduce, String variableName, String variableValue, AbortCallbackCheck abortCallbackCheck, String sectionAccessUsername, String sectionAccessPassword, DocumentRestoreMode documentRestoreMode, Boolean withData, Boolean forceQvbAllocation)

(2015-01-12 15:45:55) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-01-12 15:45:55) Error: --- End of inner exception stack trace ---

(2015-01-12 15:45:55) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-01-12 15:45:55) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-01-12 15:45:55) Error: --- End of inner exception stack trace ---

(2015-01-12 15:45:55) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-01-12 15:45:55) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-01-12 15:45:55) Error: Task failed with exception

(2015-01-12 15:45:55) Error: Exception=The currently executing operation was aborted.

(2015-01-12 15:45:55) Information: TaskResult.status=Finished

(2015-01-12 15:45:55) Information: Notifying all triggers of new state:FinishedWithErrors

(2015-01-12 15:45:55) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2015-01-12 15:45:55) Information: Saving Task Result

Peter_Cammaert

Sorry Abhay, this is a TaskLog like the previous one you posted, not a DocumentLog.

A DocumentLog lists the script statements while they are executed. I'm interested in the last few lines of a DocumentLog because they will tell us whether the script executed ok, but the task failed to finish (hanging)

abhaysingh
Specialist II
Specialist II
Author

Peter Document logs are not generating when i am trying to reload it from QMC.

Peter_Cammaert

If they're not being generated, you should first enable "Generate Log File" in QV Desktop->Settings->Document Properties->General in the document you intend to use as a test subject.

Peter_Cammaert

Here is an interesting discussion that talks about tasks that run forever in recent QVS releases (and what can be done about them). In an early QVS11 release there was a bug that showed tasks as still running while they finished long ago.

See the last few posts in:http://community.qlik.com/message/500551#500551

Maybe they can help.

abhaysingh
Specialist II
Specialist II
Author

well peter i did this but not helped

Peter_Cammaert

Just curious: what exactly did you do that didn't help? Enable "Generate Log"?

abhaysingh
Specialist II
Specialist II
Author

yes peter i generate logs. and as i sad manually reload happening and Document logs are generating. but through QMC even  document are not generating and QMC logs i have shared earlier

abhaysingh
Specialist II
Specialist II
Author

hi peter

please find some QMC logs, may it will help to sort out issue..

05:44:18) Information: Loading. LoadTime=05:58:15.2807489

(2015-01-21 05:45:18) Information: Loading. LoadTime=05:59:15.3213838

(2015-01-21 05:46:09) Error: Document open threw an exception. Exception=The currently executing operation was aborted.

(2015-01-21 05:46:10) Information: Load was aborted

(2015-01-21 05:46:10) Information: Closed the QlikView Engine successfully. ProcessID=8724

(2015-01-21 05:46:10) Information: Attempted to load the document without data.

(2015-01-21 05:46:10) Error: The document failed to open.

(2015-01-21 05:46:10) Information: Closed the QlikView Engine successfully. ProcessID=8724

(2015-01-21 05:46:10) Information: Closed the QlikView Engine successfully. ProcessID=8724

(2015-01-21 05:46:10) Information: Failed to check in document: C:\Shalimar Data Back Server\N 270614\Shalimar\APP\FINAL\CAP.qvw

(2015-01-21 05:46:10) Error: The task "CAP.qvw" failed. Exception:

(2015-01-21 05:46:10) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted.

(2015-01-21 05:46:10) Error: at QVBWrapper.DocumentPool.Checkout(ILogBucket logBucket, eCheckoutMode checkoutMode, String fileName, Boolean clearAll, Boolean clearLocks, Boolean clearOneAndOnlyOnes, Boolean reduce, String variableName, String variableValue, AbortCallbackCheck abortCallbackCheck, String sectionAccessUsername, String sectionAccessPassword, DocumentRestoreMode documentRestoreMode, Boolean withData, Boolean forceQvbAllocation)

(2015-01-21 05:46:10) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-01-21 05:46:10) Error: --- End of inner exception stack trace ---

(2015-01-21 05:46:10) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-01-21 05:46:10) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-01-21 05:46:10) Error: --- End of inner exception stack trace ---

(2015-01-21 05:46:10) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-01-21 05:46:10) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-01-21 05:46:10) Error: Task failed with exception

(2015-01-21 05:46:10) Error: Exception=The currently executing operation was aborted.

(2015-01-21 05:46:10) Information: TaskResult.status=Finished

(2015-01-21 05:46:10) Information: Notifying all triggers of new state:FinishedWithErrors

(2015-01-21 05:46:10) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2015-01-21 05:46:10) Information: Saving Task Result