Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
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.