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: 
lylererger
Creator II
Creator II

Problem with QV Server Reload Engine

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

1 Solution

Accepted Solutions
lylererger
Creator II
Creator II
Author

Yes.

Documents Tab->User Documents->Reload->

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

Any way thnx.

View solution in original post

4 Replies
mov
Champion III
Champion III

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.

lylererger
Creator II
Creator II
Author

Is that possible at all?

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

mov
Champion III
Champion III

It depends...

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

lylererger
Creator II
Creator II
Author

Yes.

Documents Tab->User Documents->Reload->

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

Any way thnx.

View solution in original post