5 Replies Latest reply: Jun 14, 2013 8:09 PM by Sandip Patel RSS

    Error Saving - Application Hang with Qv.exe

    Brian Maynard

      Hi everyone,

       

      We just upgraded to Q.11 from Q.09 and we are experiencing a problem with loading an app that worked with fine with version 9. It use to take a few minutes to save the reload of data, now its taking 6 hrs to reload.  Any ideas where to start!... I have error logs included here...

        • Re: Error Saving - Application Hang with Qv.exe
          Brian Maynard

          Additional Information:  It appears that when we limit the query to just pull a sub set of the data it works fine and there is not errors generated.  When we include the entire data pull is when we get the application hang. It will not let us save the qvw file from either the developer tool on the server or through publisher.

           

          Operating System:  Windows 2008 R2

          Memory:                    32 gb

          Hardware:               HP 64-bit CPU E5-2640 @2.50 GHZ (2 processors)

          • Re: Error Saving - Application Hang with Qv.exe
            Brian Maynard

            Please Note the Time between "Start Saving Document" and "Check in Document"

             

            5/20/2013 08:27:10.5377119 Information Starting task 'Reload and Distribute of BDM_Data.qvw'. Id:8a7e32fb-79c4-4501-aa52-98c8e14667d7. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

            5/20/2013 08:27:10.5377119 Information Entering Task Execution.

            5/20/2013 08:27:10.5377119 Information ClusterID=1

            5/20/2013 08:27:10.5377119 Information QDSID=d21e6a5c-7b15-e9c5-f4d9-7f3036b6ab3a

            5/20/2013 08:27:10.5377119 Information TaskID=8a7e32fb-79c4-4501-aa52-98c8e14667d7

            5/20/2013 08:27:10.5377119 Information MaxRunTime=1.00:00:00

            5/20/2013 08:27:10.5377119 Information MachineName=QLIKVIEW11

            5/20/2013 08:27:10.5377119 Information Max attempts:1

            5/20/2013 08:27:10.5377119 Information Current Attempt=0

            5/20/2013 08:27:10.5377119 Information Task Dependencies are OK

            5/20/2013 08:27:10.5533123 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

            5/20/2013 08:27:10.5533123 Information Opening "C:\Brazos\Staging\BDM_Data.qvw"

            5/20/2013 08:27:10.5533123 Information Allocating new QlikView Engine. Current usage count=0 of 10 (of type non-reader).

            5/20/2013 08:27:10.5533123 Information Max retries:5

            5/20/2013 08:27:10.5533123 Information Attempt:01

            5/20/2013 08:27:11.6297399 Information Allocated QlikView Engine successfully. Current usage count=1 of 10 (of type non-reader). Ticket number=138.

            5/20/2013 08:27:11.6297399 Information Loading document "C:\Brazos\Staging\BDM_Data.qvw" (116.21 Mb)

            5/20/2013 08:27:12.6437659 Information Loading. LoadTime=00:00:01.0140260

            5/20/2013 08:27:14.5782155 Information Physical FileSize=116.21 Mb. Memory Allocation Delta for this file=402.30 Mb. Available Physical Memory Before Open=21793.32 Mb. Available Physical Memory After Open=21386.09 Mb. Total Physical Memory=32733.38 Mb.

            5/20/2013 08:27:14.5782155 Information Attempted to load the document without data.

            5/20/2013 08:27:14.5782155 Information The document was loaded successfully.

            5/20/2013 08:27:14.5782155 Information Document was opened successfully

            5/20/2013 08:27:14.5782155 Information Starting reload

            5/20/2013 08:27:14.6250167 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

            5/20/2013 08:27:14.6250167 Information The Source Document is being reloaded. DocumentPath=C:\Brazos\Staging\BDM_Data.qvw

            5/20/2013 08:27:15.5922415 Information Reloading.

            5/20/2013 08:27:16.6062675 Information Reloading..

            5/20/2013 08:27:17.6209942 Information Reloading...

            5/20/2013 08:27:18.6350202 Information Reloading....

            5/20/2013 08:27:19.6422466 Information Reloading.....

            5/20/2013 08:27:20.6562726 Information Reloading......

            5/20/2013 08:27:21.6621985 Information Reloading.......

            5/20/2013 08:27:22.6762245 Information Reloading........

            5/20/2013 08:27:23.6902505 Information Reloading.........

            5/20/2013 08:27:24.7042765 Information Reloading..........

            5/20/2013 08:27:25.7183025 Information Slow down logging. Log every <2> seconds.

            5/20/2013 08:27:25.7183025 Information Reloading

            5/20/2013 08:27:27.7357543 Information Reloading.

            5/20/2013 08:27:29.7638063 Information Reloading..

            5/20/2013 08:27:31.7912585 Information Reloading...

            5/20/2013 08:27:33.8193105 Information Reloading....

            5/20/2013 08:27:35.4729529 Information The Source Document reload complete. DocumentPath=C:\Brazos\Staging\BDM_Data.qvw

            5/20/2013 08:27:35.4729529 Information Memory Allocation Delta for this file=1323.66 Mb. Available Physical Memory Before Reload=21386.08 Mb. Available Physical Memory After Reload=20088.39 Mb. Total Physical Memory=20088.39 Mb.

            5/20/2013 08:27:35.6913585 Information The Source Document was reloaded successfully.

            5/20/2013 08:27:35.6913585 Information Reload finished successfully

            5/20/2013 08:27:35.6913585 Information Start saving document

            5/20/2013 15:36:49.4428682 Information Check in document: C:\Brazos\Staging\BDM_Data.qvw

            5/20/2013 15:36:49.4740690 Information Closing the document.

            5/20/2013 15:36:50.4880950 Information Closed the QlikView Engine successfully. ProcessID=5732

            5/20/2013 15:36:50.4880950 Information Start document distribution.

            5/20/2013 15:36:50.4880950 Information Opening source document

            5/20/2013 15:36:50.4880950 Information Opening document: "BDM_Data.qvw"

            5/20/2013 15:36:50.4880950 Information Allocating new QlikView Engine. Current usage count=0 of 10 (of type non-reader).

            5/20/2013 15:36:50.4880950 Information Max retries:5

            5/20/2013 15:36:50.4880950 Information Attempt:01

            5/20/2013 15:36:51.4709202 Information Allocated QlikView Engine successfully. Current usage count=1 of 10 (of type non-reader). Ticket number=175.

            5/20/2013 15:36:51.4865206 Information Loading document "C:\Brazos\Staging\BDM_Data.qvw" (116.21 Mb)

            5/20/2013 15:36:52.4849462 Information Loading. LoadTime=00:00:01.0140260

            5/20/2013 15:36:54.5098983 Information Loading. LoadTime=00:00:03.0389781

            5/20/2013 15:36:58.5579022 Information Loading. LoadTime=00:00:07.0869820

            5/20/2013 15:37:01.1319682 Information Physical FileSize=116.21 Mb. Memory Allocation Delta for this file=760.58 Mb. Available Physical Memory Before Open=18268.89 Mb. Available Physical Memory After Open=18601.50 Mb. Total Physical Memory=32733.38 Mb.

            5/20/2013 15:37:01.1475686 Information Attempted to load the document with data.

            5/20/2013 15:37:01.1475686 Information The document was loaded successfully.

            5/20/2013 15:37:01.6467814 Information Reduce skipped, nothing is selected.

            5/20/2013 15:37:01.6467814 Information Document was opened successfully

            5/20/2013 15:37:01.6467814 Information Determined 1 static recipients spread over 1 Distribution Resources.

            5/20/2013 15:37:01.6467814 Information Number of rule combinations was calculated successfully. Rounds=1

            5/20/2013 15:37:01.6467814 Information Empty rules

            5/20/2013 15:37:01.6467814 Information Rules resulted in distribution.

            5/20/2013 15:37:01.6467814 Information ROUND: 0 of 1. WarningCount=0

            5/20/2013 15:37:01.6467814 Information Building filename

            5/20/2013 15:37:01.6467814 Information Destination name: BDM_Data.qvw

            5/20/2013 15:37:01.6467814 Information Set script

            5/20/2013 15:37:01.6779822 Information Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear

            5/20/2013 15:37:01.6779822 Information Offer resources

            5/20/2013 15:37:01.8183858 Information Commencing ReduceData

            5/20/2013 22:55:14.0665279 Information Completed ReduceData

            5/20/2013 22:55:14.0665279 Information Memory Allocation Delta for this file=14.52 Mb. Available Physical Memory Before Reduce=18601.34 Mb. Available Physical Memory After Reduce=18133.40 Mb. Total Physical Memory=18133.40 Mb.

            5/20/2013 22:55:14.0665279 Information Distributing

            5/20/2013 22:55:14.0821283 Information Distributing using resource "Reload and Distribute of BDM_Data.qvw_Folder_1".

            5/20/2013 22:55:14.1289295 Information Creating/Updating file: C:\Brazos\Production\BDM_Data.qvw

            5/20/2013 22:55:14.2693331 Information 100% - C:\Brazos\Production\BDM_Data.qvw

            5/20/2013 22:55:14.3005339 Information Performance data (CopyFile): FileSystemAccessRules=3 (16), Creating temporary file: C:\Brazos\Production\BDM_Data.tmp (16), Temporary file written successfully. (156), Deleting old destination file. (156), Renaming temporary file to destination file. (187), Write complete. (187)

            5/20/2013 22:55:14.3005339 Information Distribution finished successfully.

            5/20/2013 22:55:14.3005339 Information Deleting temporary files.

            5/20/2013 22:55:14.3473351 Information Closing the document.

            5/20/2013 22:55:15.3145599 Information Closed the QlikView Engine successfully. ProcessID=8068

            5/20/2013 22:55:15.3145599 Information Document distribution done.

            5/20/2013 22:55:15.3145599 Information Task Execute Duration=14:28:04.7768480

            5/20/2013 22:55:15.3145599 Information The task "Reload and Distribute of BDM_Data.qvw" finished successfully

            5/20/2013 22:55:15.3145599 Information TaskResult.status=Finished

            5/20/2013 22:55:15.3145599 Information Notifying all triggers of new state:Finished

            5/20/2013 22:55:15.3145599 Information Notifying all triggers of new state:Finished - completed

            5/20/2013 22:55:15.3145599 Information Saving Task Result

            • Re: Error Saving - Application Hang with Qv.exe
              Sandip Patel

              Hi Brian,

               

              Did you find any solution for your problem?

               

              As I am also facing something similar here.

               

              Please,let me know if you have found any solution to your problem or any ideas. Will appreciate it.

               

              Thanks,

              Sandip.