Problem with QV Server Reload Engine

lylererger — Tue, 10 Jun 2014 18:36:35 GMT

Hello!

Creating data model for a single customer.

Scares 2 things:

1. Assemble the model takes about 6 hours in a rather small amount of data (100 000 000 lines). Topology - Multipack. In which mainly use Concatenate. No any JOINs.

2. Falls ETL process for assembling the data model. Can't identify the cause.

Below is the QVS log:

(2014-06-10 13:57:10) Information: Slow down logging. Log every <900> seconds.

(2014-06-10 13:57:10) Information: Reloading

(2014-06-10 14:12:23) Information: Reloading.

(2014-06-10 14:27:36) Information: Reloading..

(2014-06-10 14:42:48) Information: Reloading...

(2014-06-10 14:58:01) Information: Reloading....

(2014-06-10 15:13:13) Information: Reloading.....

(2014-06-10 15:28:27) Information: Reloading......

(2014-06-10 15:43:39) Information: Reloading.......

(2014-06-10 15:58:52) Information: Reloading........

(2014-06-10 16:14:05) Information: Reloading.........

(2014-06-10 16:29:17) Information: Reloading..........

(2014-06-10 16:44:30) Information: Slow down logging. Log every <1200> seconds.

(2014-06-10 16:44:30) Information: Reloading

(2014-06-10 16:56:24) Warning: The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).

(2014-06-10 16:56:24) Information: Killing the QlikView Engine. ProcessID=5624

(2014-06-10 16:56:24) Information: Reload was aborted.

(2014-06-10 16:56:28) Information: Closed the QlikView Engine successfully. ProcessID=5624

(2014-06-10 16:56:28) Error: The task "DataModels/Model Sales Analysis.qvw" failed. Exception:

(2014-06-10 16:56:28) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted.

(2014-06-10 16:56:28) Error: at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)

(2014-06-10 16:56:28) Error: at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)

(2014-06-10 16:56:28) Error: at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle)

(2014-06-10 16:56:28) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-06-10 16:56:28) Error: --- End of inner exception stack trace ---

(2014-06-10 16:56:28) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-06-10 16:56:28) Error: --- End of inner exception stack trace ---

(2014-06-10 16:56:28) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-06-10 16:56:28) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-06-10 16:56:28) Error: Task failed with exception

(2014-06-10 16:56:28) Error: Exception=The currently executing operation was aborted.

(2014-06-10 16:56:28) Information: TaskResult.status=Finished

(2014-06-10 16:56:28) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-06-10 16:56:28) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-06-10 16:56:28) Information: Saving Task Result

Last updated @ 10.06.2014 22:23:39

Any advices to fix the problem?

Help!!!

Thanks in advance!

Re: Problem with QV Server Reload Engine

Anonymous — Tue, 10 Jun 2014 18:41:03 GMT

You're saying that the problem is with QVS reload. Do you mean that reload works in QV Desktop? If yes, maybe the Server resources are too low.

Re: Re: Problem with QV Server Reload Engine

lylererger — Tue, 10 Jun 2014 18:49:03 GMT

Is that possible at all?

Processor: Intel Xeon CPU E7-4870 @ 2.40 GHz (8 processors)
RAM: 128-GB
64-bit Operating System

Re: Problem with QV Server Reload Engine

Anonymous — Tue, 10 Jun 2014 20:35:40 GMT

It depends...

Still, the question - are you able to reload in QV Desktop?

Re: Problem with QV Server Reload Engine

lylererger — Wed, 11 Jun 2014 07:28:54 GMT

Yes.

Documents Tab->User Documents->Reload->

Omg. Timeout seconds -> 31560 and all is gona be OK )))

Any way thnx.

topic Re: Problem with QV Server Reload Engine in QlikView

Problem with QV Server Reload Engine

Re: Problem with QV Server Reload Engine

Re: Re: Problem with QV Server Reload Engine

Re: Problem with QV Server Reload Engine

Re: Problem with QV Server Reload Engine