4 Replies Latest reply: Aug 10, 2012 4:59 PM by Michael Terenzi RSS

    Qlikview Server Failure...How can i figure out the issue

      I just inherited a qlikview which is version 9 and looking to upgrade to version 11 ASAP.  The current state of development is not working e.g. my scheduled reloads, reduce and etc are failing.  I would like to fix the issue before i upgrade to avoid a bigger issue when I upgrade.  I really don't know what the issues is and i need help figuring out the issue and implementing a solution.  I will try to post a log example when i get one.

        • Re: Qlikview Server Failure...How can i figure out the issue

          This is the error message that i am getting:

           

          (2012-08-10 10:08:22) Information: Executing ClusterID=1, QDSID=71bda942-e1b8-4280-1616-8dc9407a6f3eQDSMain.DistributeTask

          (2012-08-10 10:08:22) Information: Starting task "Load Contracts" (Attempt 1 of 1)

          (2012-08-10 10:08:22) Information: Max run time: 1.00:00:00

          (2012-08-10 10:08:22) Information: Document is marked for refresh; Initializing Reload.

          (2012-08-10 10:08:22) Information: Opening "\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw"

          (2012-08-10 10:08:22) Information: Allocating QlikView Engine

          (2012-08-10 10:08:22) Information: Allocating new QlikView Engine. Current usagecount=1 of 20

          (2012-08-10 10:08:22) Information: An instance of the QlikView Engine is being created

          (2012-08-10 10:08:22) Information: Starting QlikView Engine

          (2012-08-10 10:08:22) Information: The QlikView Engine was started successfully. Version=9.00.7320.7, ProcessID=54120

          (2012-08-10 10:08:22) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 20, Ticket=1

          (2012-08-10 10:08:22) Information: Loading document "\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw" (0.12 Mb)

          (2012-08-10 10:08:23) Information: Physical FileSize=0.12 Mb. Memory Allocation Delta for this file=4.05 Mb. Available Physical Memory Before Open=59740.68 Mb. Available Physical Memory After Open=59736.22 Mb. Total Physical Memory=64509.66 Mb.

          (2012-08-10 10:08:23) Information: The document was loaded successfully.

          (2012-08-10 10:08:23) Information: Initializing Checkout (0), Loading document (219), Initializing load (235), Checking read (235), Creating QlikView Engine (375), Checking Size (422), Load (422), Load Completed (594), Tables read (625), Opened successfully (672)

          (2012-08-10 10:08:23) Information: Document was opened successfully

          (2012-08-10 10:08:23) Information: Opened successfully (0)

          (2012-08-10 10:08:23) Information: Starting reload

          (2012-08-10 10:08:23) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

          (2012-08-10 10:08:23) Information: The Source Document is being reloaded. DocumentPath=\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw

          (2012-08-10 10:08:24) Information: Reloading.

          (2012-08-10 10:08:25) Information: Reloading..

          (2012-08-10 10:08:26) Information: Reloading...

          (2012-08-10 10:08:26) Information: The Source Document reload complete. DocumentPath=\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw

          (2012-08-10 10:08:26) Information: Waiting for the document log "\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw" to become available..

          (2012-08-10 10:08:26) Information: Memory Allocation Delta for this file=6.49 Mb. Available Physical Memory Before Reload=59735.61 Mb. Available Physical Memory After Reload=59733.39 Mb. Total Physical Memory=59733.39 Mb.

          (2012-08-10 10:08:26) Information: Found a document log. FileName=\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw.log

          (2012-08-10 10:08:26) Information: Writing documentLog to C:\Documents and Settings\All Users\Application Data\QlikTech\Publisher\Qlikview Distribution Service\1\Log\20120810\100821 - Load Contracts\DocumentLog.txt

          (2012-08-10 10:08:26) Information: The Source Document was reloaded successfully.

          (2012-08-10 10:08:26) Information: Initializing Reload (0), Finished (3266)

          (2012-08-10 10:08:26) Information: Reload finished successfully.

          (2012-08-10 10:08:26) Information: Saving document

          (2012-08-10 10:08:26) Error: The sourcedocument failed to save.. Exception=System.UnauthorizedAccessException: Access to the path is denied.

          (2012-08-10 10:08:26) Error:    at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

          (2012-08-10 10:08:26) Error:    at System.IO.File.Replace(String sourceFileName, String destinationFileName, String destinationBackupFileName, Boolean ignoreMetadataErrors)

          (2012-08-10 10:08:26) Error:    at QVBWrapper.Document.Save(ILogBucket i_LogBucket, String i_SaveAsFileName)

          (2012-08-10 10:08:26) Information: Initializing save (0), Copying permissions to new file (0), Saving \\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\af5a4066-7e7a-4db6-893c-551f858af3f4_Contract Load.qvw.tmp (31), Moving temp file to new file (312)

          (2012-08-10 10:08:26) Error: Save failed.

          (2012-08-10 10:08:26) Information: Closing the document.

          (2012-08-10 10:08:27) Information: Closed the QlikView Engine successfully. ProcessID=54120

          (2012-08-10 10:08:27) Information: Initializing (0), Finished (94)

          (2012-08-10 10:08:27) Error: Reload failed. Distribution skipped.

          (2012-08-10 10:08:27) Error: The task "Load Contracts" failed. ErrorCount=3

          (2012-08-10 10:08:22) Information: Executing ClusterID=1, QDSID=71bda942-e1b8-4280-1616-8dc9407a6f3eQDSMain.DistributeTask

          (2012-08-10 10:08:22) Information: Starting task "Load Contracts" (Attempt 1 of 1)

          (2012-08-10 10:08:22) Information: Max run time: 1.00:00:00

          (2012-08-10 10:08:22) Information: Document is marked for refresh; Initializing Reload.

          (2012-08-10 10:08:22) Information: Opening "\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw"

          (2012-08-10 10:08:22) Information: Allocating QlikView Engine

          (2012-08-10 10:08:22) Information: Allocating new QlikView Engine. Current usagecount=1 of 20

          (2012-08-10 10:08:22) Information: An instance of the QlikView Engine is being created

          (2012-08-10 10:08:22) Information: Starting QlikView Engine

          (2012-08-10 10:08:22) Information: The QlikView Engine was started successfully. Version=9.00.7320.7, ProcessID=54120

          (2012-08-10 10:08:22) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 20, Ticket=1

          (2012-08-10 10:08:22) Information: Loading document "\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw" (0.12 Mb)

          (2012-08-10 10:08:23) Information: Physical FileSize=0.12 Mb. Memory Allocation Delta for this file=4.05 Mb. Available Physical Memory Before Open=59740.68 Mb. Available Physical Memory After Open=59736.22 Mb. Total Physical Memory=64509.66 Mb.

          (2012-08-10 10:08:23) Information: The document was loaded successfully.

          (2012-08-10 10:08:23) Information: Initializing Checkout (0), Loading document (219), Initializing load (235), Checking read (235), Creating QlikView Engine (375), Checking Size (422), Load (422), Load Completed (594), Tables read (625), Opened successfully (672)

          (2012-08-10 10:08:23) Information: Document was opened successfully

          (2012-08-10 10:08:23) Information: Opened successfully (0)

          (2012-08-10 10:08:23) Information: Starting reload

          (2012-08-10 10:08:23) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

          (2012-08-10 10:08:23) Information: The Source Document is being reloaded. DocumentPath=\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw

          (2012-08-10 10:08:24) Information: Reloading.

          (2012-08-10 10:08:25) Information: Reloading..

          (2012-08-10 10:08:26) Information: Reloading...

          (2012-08-10 10:08:26) Information: The Source Document reload complete. DocumentPath=\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw

          (2012-08-10 10:08:26) Information: Waiting for the document log "\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw" to become available..

          (2012-08-10 10:08:26) Information: Memory Allocation Delta for this file=6.49 Mb. Available Physical Memory Before Reload=59735.61 Mb. Available Physical Memory After Reload=59733.39 Mb. Total Physical Memory=59733.39 Mb.

          (2012-08-10 10:08:26) Information: Found a document log. FileName=\\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\Contract Load.qvw.log

          (2012-08-10 10:08:26) Information: Writing documentLog to C:\Documents and Settings\All Users\Application Data\QlikTech\Publisher\Qlikview Distribution Service\1\Log\20120810\100821 - Load Contracts\DocumentLog.txt

          (2012-08-10 10:08:26) Information: The Source Document was reloaded successfully.

          (2012-08-10 10:08:26) Information: Initializing Reload (0), Finished (3266)

          (2012-08-10 10:08:26) Information: Reload finished successfully.

          (2012-08-10 10:08:26) Information: Saving document

          (2012-08-10 10:08:26) Error: The sourcedocument failed to save.. Exception=System.UnauthorizedAccessException: Access to the path is denied.

          (2012-08-10 10:08:26) Error:    at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

          (2012-08-10 10:08:26) Error:    at System.IO.File.Replace(String sourceFileName, String destinationFileName, String destinationBackupFileName, Boolean ignoreMetadataErrors)

          (2012-08-10 10:08:26) Error:    at QVBWrapper.Document.Save(ILogBucket i_LogBucket, String i_SaveAsFileName)

          (2012-08-10 10:08:26) Information: Initializing save (0), Copying permissions to new file (0), Saving \\dbg.ads.db.com\nyc-corpfin-g\financial_institutions_group\market_data\mdapp\qlikview\source\Worksheets\af5a4066-7e7a-4db6-893c-551f858af3f4_Contract Load.qvw.tmp (31), Moving temp file to new file (312)

          (2012-08-10 10:08:26) Error: Save failed.

          (2012-08-10 10:08:26) Information: Closing the document.

          (2012-08-10 10:08:27) Information: Closed the QlikView Engine successfully. ProcessID=54120

          (2012-08-10 10:08:27) Information: Initializing (0), Finished (94)

          (2012-08-10 10:08:27) Error: Reload failed. Distribution skipped.

          (2012-08-10 10:08:27) Error: The task "Load Contracts" failed. ErrorCount=3

           

          Any help would be greatly appericated