Task execution still running - server went down

[#1]

Hi Floks, I am facing very wired situation on one qlikview report.

Recently, I did change the expression values on the layout and I ran the qlikview file on my local desktop client and all should be fine. The size of qvw file is around 205MB. But I am trying to test the reload task on the QA server, the task still executed and its never ending after some time later the server went down. I check the .qvw logfile on the server and shown as execution was finished. but the source or user documents didn't change to new version. I observed the the CPU usage is 90-100% and Memory usage as maximum on the task manager. I believe its distribution service problem.

The interesting thing is, I rollback all the expression changes into previous version and there is no problem on the server.

Please help me how to avoid this type scenario's and where is the problem exactly ?

Thanks in advance ....

[#2]

Any help ?

[#3]

Any Help

[jerrysvensson]

I encountered something similar last week.

An application didn't publish, altough the task failed in our case.

It was a problem with the database and every expression failed to recalculate. I saw this when I reloaded the app maually.

Try reloading your app in Developer and after that press Clear all selection.

[#5]

My application reloaded successfully on the Desktop client and my data sources are QVD's.

I had this problem only on server (while reload on publisher) only.

[#6]

Hi,

Can you put up the log file for us to look at?

[#7]

I tested the reload task with out distribution and it ran successfully. But I create the task for both reload & distribute , the task got failed. How can I debug the distribution task ?

[#8]

Please find the log file:

(2013-12-10 17:50:52) Information: Starting task 'Reload and Distribute of Stage\Test ipad vesrion.qvw'. Id:f49143c9-c043-4df4-9b37-b7364e2fd5d6. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2013-12-10 17:50:52) Information: Entering Task Execution.

(2013-12-10 17:50:52) Information: ClusterID=1

(2013-12-10 17:50:52) Information: QDSID=fd30fc1a-e64f-39b8-9eef-bb8ba39244ee

(2013-12-10 17:50:52) Information: TaskID=f49143c9-c043-4df4-9b37-b7364e2fd5d6

(2013-12-10 17:50:52) Information: MaxRunTime=1.00:00:00

(2013-12-10 17:50:52) Information: MachineName=QV01-LAB

(2013-12-10 17:50:52) Information: Max attempts:1

(2013-12-10 17:50:52) Information: Current Attempt=0

(2013-12-10 17:50:52) Information: Task Dependencies are OK

(2013-12-10 17:50:52) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2013-12-10 17:50:52) Information: Opening "D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw"

(2013-12-10 17:50:52) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

(2013-12-10 17:50:52) Information: Max retries:5

(2013-12-10 17:50:52) Information: Attempt:01

(2013-12-10 17:50:53) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=111.

(2013-12-10 17:50:53) Information: Loading document "D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw" (0.45 Mb)

(2013-12-10 17:50:54) Information: Physical FileSize=0.45 Mb. Memory Allocation Delta for this file=7.44 Mb. Available Physical Memory Before Open=31454.58 Mb. Available Physical Memory After Open=31444.12 Mb. Total Physical Memory=32771.55 Mb.

(2013-12-10 17:50:54) Information: Attempted to load the document without data.

(2013-12-10 17:50:54) Information: The document was loaded successfully.

(2013-12-10 17:50:54) Information: Starting reload

(2013-12-10 17:50:54) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2013-12-10 17:50:54) Information: Waiting for the document log "D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw" to become available..

(2013-12-10 17:50:54) Information: The Source Document is being reloaded. DocumentPath=D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw

(2013-12-10 17:50:54) Information: Found a document log. FileName=D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw.log

(2013-12-10 17:50:54) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20131210\175052 - Reload and Distribute of Stage_Test ipad vesrion.qvw.log.qvw\DocumentLog.txt

(2013-12-10 17:50:55) Information: Reloading.

(2013-12-10 17:50:56) Information: Reloading..

(2013-12-10 17:50:57) Information: Reloading...

(2013-12-10 17:50:58) Information: Reloading....

(2013-12-10 17:50:59) Information: Reloading.....

(2013-12-10 17:51:00) Information: Reloading......

(2013-12-10 17:51:01) Information: Reloading.......

(2013-12-10 17:51:02) Information: Reloading........

(2013-12-10 17:51:03) Information: Reloading.........

(2013-12-10 17:51:04) Information: Reloading..........

(2013-12-10 17:51:05) Information: Slow down logging. Log every <2> seconds.

(2013-12-10 17:51:05) Information: Reloading

(2013-12-10 17:51:07) Information: Reloading.

(2013-12-10 17:51:09) Information: Reloading..

(2013-12-10 17:51:11) Information: Reloading...

(2013-12-10 17:51:13) Information: Reloading....

(2013-12-10 17:51:15) Information: Reloading.....

(2013-12-10 17:51:17) Information: Reloading......

(2013-12-10 17:51:19) Information: Reloading.......

(2013-12-10 17:51:21) Information: Reloading........

(2013-12-10 17:51:23) Information: Reloading.........

(2013-12-10 17:51:25) Information: Reloading..........

(2013-12-10 17:51:27) Information: Slow down logging. Log every <10> seconds.

2013-12-10 17:51:37) Information: Reloading.

(2013-12-10 17:51:48) Information: Reloading..

(2013-12-10 17:51:58) Information: Reloading...

(2013-12-10 17:52:08) Information: Reloading....

(2013-12-10 17:52:18) Information: Reloading.....

(2013-12-10 17:52:28) Information: Reloading......

(2013-12-10 17:52:38) Information: Reloading.......

(2013-12-10 17:52:48) Information: Reloading........

(2013-12-10 17:52:59) Information: Reloading.........

(2013-12-10 17:53:09) Information: Reloading..........

(2013-12-10 17:53:19) Information: Slow down logging. Log every <60> seconds.

(2013-12-10 17:53:19) Information: Reloading

(2013-12-10 17:53:28) Information: The Source Document reload complete. DocumentPath=D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw

(2013-12-10 17:53:28) Information: Memory Allocation Delta for this file=882.95 Mb. Available Physical Memory Before Reload=31444.11 Mb. Available Physical Memory After Reload=30528.01 Mb. Total Physical Memory=30528.01 Mb.

(2013-12-10 17:53:31) Information: The Source Document was reloaded successfully.

(2013-12-10 17:53:32) Information: Reload finished successfully

(2013-12-10 17:53:32) Information: Start saving document

(2013-12-10 17:54:25) Information: Check in document: D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw

(2013-12-10 17:54:25) Information: Closing the document

(2013-12-10 17:54:25) Information: Closed the QlikView Engine successfully. ProcessID=5952

(2013-12-10 17:54:25) Information: Start document distribution.

(2013-12-10 17:54:25) Information: Opening source document

(2013-12-10 17:54:25) Information: Opening document: "Test ipad vesrion.qvw"

(2013-12-10 17:54:25) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

(2013-12-10 17:54:25) Information: Max retries:5

(2013-12-10 17:54:25) Information: Attempt:01

(2013-12-10 17:54:27) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=112.

(2013-12-10 17:54:27) Information: Loading document "D:\QlikView\Publisher\Stage\Test ipad vesrion.qvw" (193.62 Mb)

(2013-12-10 17:54:28) Information: Loading. LoadTime=00:00:01.0140325

(2013-12-10 17:54:30) Information: Loading. LoadTime=00:00:03.0420975

(2013-12-10 17:54:34) Information: Loading. LoadTime=00:00:07.0982275

(2013-12-10 17:54:42) Information: Loading. LoadTime=00:00:15.2104875

(2013-12-10 17:54:46) Information: Physical FileSize=193.62 Mb. Memory Allocation Delta for this file=705.62 Mb. Available Physical Memory Before Open=31410.58 Mb. Available Physical Memory After Open=30715.02 Mb. Total Physical Memory=32771.55 Mb.

(2013-12-10 17:54:46) Information: Attempted to load the document with data.

(2013-12-10 17:54:46) Information: The document was loaded successfully.

(2013-12-10 17:54:46) Information: Reduce skipped, nothing is selected.

(2013-12-10 17:54:46) Information: Document was opened successfully

(2013-12-10 17:54:46) Information: Determined 1 static recipients spread over 1 Distribution Resources.

(2013-12-10 17:54:46) Information: Number of rule combinations was calculated successfully. Rounds=1

(2013-12-10 17:54:46) Information: Empty rules

(2013-12-10 17:54:46) Information: Rules resulted in distribution

(2013-12-10 17:54:46) Information: ROUND: 0 of 1. WarningCount=0

(2013-12-10 17:54:46) Information: Building filename

(2013-12-10 17:54:46) Information: Destination name: Test ipad vesrion.qvw

(2013-12-10 17:54:46) Information: Set script

(2013-12-10 17:54:46) Information: Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear

(2013-12-10 17:54:46) Information: Offer resources

(2013-12-10 17:54:46) Information: Commencing ReduceData

(2013-12-10 17:55:54) Error: Could not run ReduceData. Exception=QVBWrapper.Exceptions.ReduceAndSaveFailedException: Failed to save document: C:\ProgramData\QlikTech\DistributionService\1\temp\c11aa242-8b91-4f9b-bea0-65c8425149a4\document.qvw

(2013-12-10 17:55:54) Error: at QVBWrapper.Document.Save(ILogBucket logBucket, String savePath, Boolean checkoutSavedDocument)

(2013-12-10 17:55:54) Error: at QVBWrapper.Document.ReduceData(ILogBucket logBucket, Boolean reduce, String savePath, Boolean checkoutReducedDocument, Boolean save)

(2013-12-10 17:55:54) Error: Failed to generate QVW files.. Exception=System.ArgumentException: Empty path name is not legal.

(2013-12-10 17:55:54) Error: at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)

(2013-12-10 17:55:54) Error: at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)

(2013-12-10 17:55:54) Error: at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)

(2013-12-10 17:55:54) Error: at QVBWrapper.Document.GetStream(ILogBucket i_LogBucket, eDocumentType i_DocumentType, String i_URL, Boolean i_ShowToolBar, String i_ReportID)

(2013-12-10 17:55:54) Error: Failed to generate QVW File package.. Exception=System.NullReferenceException: Object reference not set to an instance of an object.

(2013-12-10 17:55:54) Error: at QDSMain.DistributeHelper.GrabQVWFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document)

(2013-12-10 17:55:54) Information: Deleting temporary files.

(2013-12-10 17:55:55) Error: The task "Reload and Distribute of Stage\Test ipad vesrion.qvw" failed. Exception:

(2013-12-10 17:55:55) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.LogBucketErrorException: Failed to generate QVW File package.. Exception=System.NullReferenceException: Object reference not set to an instance of an object.

(2013-12-10 17:55:55) Error: at QDSMain.DistributeHelper.GrabQVWFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document)

(2013-12-10 17:55:55) Error: at QDSMain.DistributeTask.RevertOneAndAlwaysOne(Document qvbDocument)

(2013-12-10 17:55:55) Error: at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument)

(2013-12-10 17:55:55) Error: at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

(2013-12-10 17:55:55) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-12-10 17:55:55) Error: --- End of inner exception stack trace ---

(2013-12-10 17:55:55) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-12-10 17:55:55) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2013-12-10 17:55:55) Information: Task Execute Duration=00:05:02.3844915

(2013-12-10 17:55:55) Information: Sending Alert mail(2013-12-10 17:55:57) Information: TaskResult.status=Finished(2013-12-10 17:55:57)

Information: Notifying all triggers of new state:FinishedWithErrors(2013-12-10 17:55:57)

Information: Notifying all triggers of new state:FinishedWithErrors - completed(2013-12-10 17:55:57)

Information: Saving Task Result

[#9]

Any help why I distribution got failed

[jerrysvensson]

Are you running any anti virus software on your server?

If so make an exception on the catalogue C:\ProgramData\QlikTech