Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II
‎2015-01-09 01:19 AM

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.

3,662 Views
0 Likes
23 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2015-01-12 05:11 AM

In response to abhaysingh

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.

652 Views
0 Likes
abhaysingh
Specialist II
Specialist II
‎2015-01-12 05:17 AM
Author

In response to Peter_Cammaert

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

652 Views
0 Likes
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2015-01-12 05:23 AM

In response to abhaysingh

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)

652 Views
0 Likes
abhaysingh
Specialist II
Specialist II
‎2015-01-12 05:34 AM
Author

In response to Peter_Cammaert

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

652 Views
0 Likes
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2015-01-12 05:39 AM

In response to abhaysingh

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.

652 Views
0 Likes
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2015-01-12 05:45 AM

In response to abhaysingh

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.

651 Views
0 Likes
abhaysingh
Specialist II
Specialist II
‎2015-01-12 06:40 AM
Author

In response to Peter_Cammaert

well peter i did this but not helped

652 Views
0 Likes
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2015-01-12 07:42 AM

In response to abhaysingh

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

652 Views
0 Likes
abhaysingh
Specialist II
Specialist II
‎2015-01-15 06:01 AM
Author

In response to Peter_Cammaert

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

652 Views
0 Likes
abhaysingh
Specialist II
Specialist II
‎2015-01-20 10:44 PM
Author

In response to abhaysingh

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

652 Views
0 Likes