Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

4 Replies
Not applicable
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I see several of these:

The sourcedocument failed to save.. Exception=System.UnauthorizedAccessException: Access to the path is denied.

At first glance it looks like permissions issue. The userid running the QV Services needs write access to the document directory.

-ROb

Not applicable
Author

Rob, Thank for the quick response.  I have the correct permission to write access to the document directory.  The script run perfect but qlikview server say it failed.  I dont know if this is a bug or what

MichaelTerenzi
Partner Ambassador
Partner Ambassador

Albert Marrero wrote:

Rob, Thank for the quick response.  I have the correct permission to write access to the document directory.  The script run perfect but qlikview server say it failed.  I dont know if this is a bug or what

It looks like the problem is the writing of the temp file. There are some known issues with the logging not matching up to the task result. I suggest opening a ticket with Support to get to the bottom of it.