topic Re: QMC not able to Reload Single QVW file in QlikView

QMC not able to Reload Single QVW file

abhaysingh — Fri, 09 Jan 2015 06:19:53 GMT

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.

Re: QMC not able to Reload Single QVW file

abhaysingh — Fri, 09 Jan 2015 10:21:11 GMT

no one knows???

Re: QMC not able to Reload Single QVW file

Colin-Albert — Fri, 09 Jan 2015 16:29:20 GMT

Have you looked at the task logs on the QMC?

Select on of the reload tasks that is failing on the left side of the screen. Then Click on "Show Task Details" at the top right corner of the screen and then select the Log tab. You should see more details of the error here.

Re: QMC not able to Reload Single QVW file

abhaysingh — Mon, 12 Jan 2015 05:56:43 GMT

Hi Colin

thanks for revert,,, but the problem is when i am reloading file through QMC logs are not generating. in that case please suggest me something.

giving me these logs.. these are not full logs but may it will help

(2015-01-12 10:59:16) Information: Loading. LoadTime=01:43:05.4854736

(2015-01-12 11:00:16) Information: Loading. LoadTime=01:44:05.5079903

(2015-01-12 11:01:16) Information: Loading. LoadTime=01:45:05.5384292

(2015-01-12 11:02:17) Information: Loading. LoadTime=01:46:05.5498667

(2015-01-12 11:03:17) Information: Loading. LoadTime=01:47:05.5607698

(2015-01-12 11:04:17) Information: Loading. LoadTime=01:48:05.5726661

(2015-01-12 11:05:17) Information: Loading. LoadTime=01:49:05.5773959

(2015-01-12 11:06:17) Information: Loading. LoadTime=01:50:05.5857810

(2015-01-12 11:07:17) Information: Loading. LoadTime=01:51:05.6019259

(2015-01-12 11:08:17) Information: Loading. LoadTime=01:52:05.6223941

(2015-01-12 11:09:17) Information: Loading. LoadTime=01:53:05.6546209

(2015-01-12 11:10:17) Information: Loading. LoadTime=01:54:05.6776767

(2015-01-12 11:11:17) Information: Loading. LoadTime=01:55:05.7007034

(2015-01-12 11:12:17) Information: Loading. LoadTime=01:56:05.7131005

(2015-01-12 11:13:17) Information: Loading. LoadTime=01:57:05.7201333

(2015-01-12 11:14:17) Information: Loading. LoadTime=01:58:05.7361712

(2015-01-12 11:15:17) Information: Loading. LoadTime=01:59:05.7637485

(2015-01-12 11:16:17) Information: Loading. LoadTime=02:00:05.7727494

(2015-01-12 11:17:17) Information: Loading. LoadTime=02:01:05.7802461

(2015-01-12 11:18:17) Information: Loading. LoadTime=02:02:05.8060059

(2015-01-12 11:19:17) Information: Loading. LoadTime=02:03:05.8204745

(2015-01-12 11:20:17) Information: Loading. LoadTime=02:04:05.8253119

(2015-01-12 11:21:17) Information: Loading. LoadTime=02:05:05.8375952

(2015-01-12 11:22:17) Information: Loading. LoadTime=02:06:05.8518473

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 08:27:26 GMT

Are tasks starting and reloading forever (like the logs seem to indicate), or are tasks simply not getting triggered?

Re: QMC not able to Reload Single QVW file

abhaysingh — Mon, 12 Jan 2015 08:49:18 GMT

yes Peter u r right.. what is the solution kindly suggest..

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 08:53:22 GMT

Huh? I do not know what I'm right about, since you didn't answer my question... Are A) tasks starting but not stopping, or B) are tasks nog getting launched at all?

Re: QMC not able to Reload Single QVW file

abhaysingh — Mon, 12 Jan 2015 09:05:45 GMT

oh sory i was misunderstood....

A) Tast starting but not stopping

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 09:15:49 GMT

Check the DocumentLog of a task that isn't stopping. If the log shows that the script runs till the end, then you probably have a QVS that isn't able to terminate tasks that have ended. Some releases do epxerience this problem. What version of QlikView Server do you have at the moment?

Re: QMC not able to Reload Single QVW file

abhaysingh — Mon, 12 Jan 2015 10:01:58 GMT

well peter. before when this problem came i was using SR3 version for server and SR6 for Desktop and SR1 For SAP connector,,

but i have upgraded it to SERVER SR7, QV Desktop SR7 and SAP Connector SR3.

and i have checked not even single QVW file which has no Dependencies to other is not reloading.

so in that case i am struck and doing all reload manually..

kindly suggest

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 10:11:48 GMT

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.

Re: QMC not able to Reload Single QVW file

abhaysingh — Mon, 12 Jan 2015 10:17:51 GMT

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.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

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 10:23:10 GMT

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)

Re: QMC not able to Reload Single QVW file

abhaysingh — Mon, 12 Jan 2015 10:34:02 GMT

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

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 10:39:00 GMT

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.

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 10:45:55 GMT

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.

Re: QMC not able to Reload Single QVW file

abhaysingh — Mon, 12 Jan 2015 11:40:44 GMT

well peter i did this but not helped

Re: QMC not able to Reload Single QVW file

Peter_Cammaert — Mon, 12 Jan 2015 12:42:43 GMT

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

Re: QMC not able to Reload Single QVW file

abhaysingh — Thu, 15 Jan 2015 11:01:24 GMT

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

Re: QMC not able to Reload Single QVW file

abhaysingh — Wed, 21 Jan 2015 03:44:23 GMT

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: 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.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