Failed Reload Via Management Console

Wed, 29 Jan 2014 18:39:11 GMT

Hi my reload via the management console fails. Any help would be nice. Here are the characteristics:

Reload of DM_PROJECT\abs.qvw

Reload the whole document
To the following recipients:

None

The task has the following triggers:

Once every 5 minutes every Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday starting at 1/28/2014 2:52:33 PM

Name:	Reload of DM_PROJECT\abs.qvw
Category:	Default
Distribution Service:	QVDS@bosappdevqkv002
Type:	Document Task
Document:	DM_PROJECT\abs.qvw
Status:	Failed
Last execution:	1/29/2014 1:20:01 PM
Started/scheduled:	1/29/2014 1:22:33 PM
Average duration of successful executions:	-

And here's the log that I obtain:

(2014-01-29 13:20:01) Information: Starting task 'Reload of DM_PROJECT\abs.qvw'. Id:25acc036-84a4-463a-b88b-93bea912b556. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2014-01-29 13:20:01) Information: Entering Task Execution.

(2014-01-29 13:20:01) Information: ClusterID=1

(2014-01-29 13:20:01) Information: QDSID=c4e987e2-47db-95d5-9a2c-ef8685555d2c

(2014-01-29 13:20:01) Information: TaskID=25acc036-84a4-463a-b88b-93bea912b556

(2014-01-29 13:20:01) Information: MaxRunTime=1.00:00:00

(2014-01-29 13:20:01) Information: MachineName=BOSAPPDEVQKV002

(2014-01-29 13:20:01) Information: Max attempts:1

(2014-01-29 13:20:01) Information: Current Attempt=0

(2014-01-29 13:20:01) Information: Task Dependencies are OK

(2014-01-29 13:20:01) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2014-01-29 13:20:01) Information: Opening "\\BOSAPPDEVQKV002\D$\Qlikview\SourceDocuments\DM_PROJECT\abs.qvw"

(2014-01-29 13:20:01) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

(2014-01-29 13:20:01) Information: Max retries:5

(2014-01-29 13:20:01) Information: Attempt:01

(2014-01-29 13:20:01) Information: Opened the QlikView Engine successfully. ProcessID=5664

(2014-01-29 13:20:01) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=671.

(2014-01-29 13:20:01) Information: Loading document "\\BOSAPPDEVQKV002\D$\Qlikview\SourceDocuments\DM_PROJECT\abs.qvw" (0.48 Mb)

(2014-01-29 13:20:02) Information: Physical FileSize=0.48 Mb. Memory Allocation Delta for this file=9.37 Mb. Available Physical Memory Before Open=2254.07 Mb. Available Physical Memory After Open=2241.18 Mb. Total Physical Memory=4095.49 Mb.

(2014-01-29 13:20:02) Information: Attempted to load the document without data.

(2014-01-29 13:20:02) Information: The document was loaded successfully.

(2014-01-29 13:20:02) Information: Document was opened successfully

(2014-01-29 13:20:02) Information: Starting reload

(2014-01-29 13:20:02) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2014-01-29 13:20:02) Information: The Source Document is being reloaded. DocumentPath=\\BOSAPPDEVQKV002\D$\Qlikview\SourceDocuments\DM_PROJECT\abs.qvw

(2014-01-29 13:20:02) Information: The Source Document reload complete. DocumentPath=\\BOSAPPDEVQKV002\D$\Qlikview\SourceDocuments\DM_PROJECT\abs.qvw

(2014-01-29 13:20:02) Information: Memory Allocation Delta for this file=1.04 Mb. Available Physical Memory Before Reload=2241.14 Mb. Available Physical Memory After Reload=2236.98 Mb. Total Physical Memory=2236.98 Mb.

(2014-01-29 13:20:02) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\BOSAPPDEVQKV002\D$\Qlikview\SourceDocuments\DM_PROJECT\abs.qvw.

(2014-01-29 13:20:02) Information: Closing the document.

(2014-01-29 13:20:03) Information: Closed the QlikView Engine successfully. ProcessID=5664

(2014-01-29 13:20:03) Error: The task "Reload of DM_PROJECT\abs.qvw" failed. Exception:

(2014-01-29 13:20:03) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=\\BOSAPPDEVQKV002\D$\Qlikview\SourceDocuments\DM_PROJECT\abs.qvw.

(2014-01-29 13:20:03) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2014-01-29 13:20:03) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-01-29 13:20:03) Error: --- End of inner exception stack trace ---

(2014-01-29 13:20:03) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-01-29 13:20:03) Error: --- End of inner exception stack trace ---

(2014-01-29 13:20:03) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-01-29 13:20:03) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-01-29 13:20:03) Information: Task Execute Duration=00:00:01.9032801

(2014-01-29 13:20:03) Information: TaskResult.status=Finished

(2014-01-29 13:20:03) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-01-29 13:20:03) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-01-29 13:20:03) Information: Saving Task Result

Re: Failed Reload Via Management Console

dseelam — Wed, 29 Jan 2014 18:43:10 GMT

Hello Nikhil,

the below document path you provided should be wrong once check the document path in QMC

(2014-01-29 13:20:02) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\BOSAPPDEVQKV002\D$\Qlikview\SourceDocuments\DM_PROJECT\abs.qvw.

Re: Failed Reload Via Management Console

Wed, 29 Jan 2014 18:48:49 GMT

Hey Dinesh, I checked the document path in QMC, and it indeed matches the document path displayed in the error message.

Re: Failed Reload Via Management Console

Peter_Cammaert — Wed, 29 Jan 2014 20:05:46 GMT

From this information you cannot deduce whether your load script is at fault, or something else in the QDS Task.

Generate a document log (in QV Desktop, enable Settings->Document Properties->General->Generate Logfile) and check that for script errors.

Peter

Re: Failed Reload Via Management Console

Peter_Cammaert — Wed, 29 Jan 2014 20:07:10 GMT

Oh and by the way, the Log file will be called DocumentLog.txt and will reside in the same subdirectory as the TaskLog.txt

Peter

Re: Failed Reload Via Management Console

Wed, 29 Jan 2014 20:30:07 GMT

When I access the Qlikview document from the desktop (it's located on a server), the Document Properties option under the Settings tab is not selectable. Is there anything else I can do?

Re: Failed Reload Via Management Console

Peter_Cammaert — Wed, 29 Jan 2014 20:39:30 GMT

That's because Section Access is active in this document, and your account is assigned role = USER when you open it. People with Role = ADMIN (usually the developer) are able to restore the Document Properties setting (and everything else).

Note that we're talking about the Source Document, in case your set-up includes a publisher. User documents are useless because they are overwritten. Do you have a document copy available from the developer? Or can you ask your developer to set the "Generate Logfile" checkbox? That's about the only way to generate a load script log.

Best,

Peter

topic Re: Failed Reload Via Management Console in QlikView

Failed Reload Via Management Console

Re: Failed Reload Via Management Console

Re: Failed Reload Via Management Console

Re: Failed Reload Via Management Console

Re: Failed Reload Via Management Console

Re: Failed Reload Via Management Console

Re: Failed Reload Via Management Console