Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Yes.
Documents Tab->User Documents->Reload->
Omg. Timeout seconds -> 31560 and all is gona be OK )))
Any way thnx.
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.
Is that possible at all?
Processor: Intel Xeon CPU E7-4870 @ 2.40 GHz (8 processors)
RAM: 128-GB
64-bit Operating System
It depends...
Still, the question - are you able to reload in QV Desktop?
Yes.
Documents Tab->User Documents->Reload->
Omg. Timeout seconds -> 31560 and all is gona be OK )))
Any way thnx.