Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error while running reload task

Dear users,

Since a couple of days I encountered errors while reloading. It is a reload task which needs to run every 5 minutes.

The reload task was working a couple of days ago, but when a colleague of mine replaced the dashboad, the reloading tasks fails.

I tried the following things:

  • restarted all the services
  • removed the task and created a new task
  • removed the dashboard and then put it in place again, and then created a new task.
  • restarted the complete server

This is th eerror i get:

(2013-07-09 15:28:36) Information: Starting task 'SMV/SMV Qlikview.qvw'. Id:2bc0988f-509b-4c53-b255-6e176bde710b. Triggered by 'ScheduleTrigger'. Id:5e22fc51-4c7c-4cc3-8679-8a517c611ab3

(2013-07-09 15:28:36) Information: Entering Task Execution.

(2013-07-09 15:28:36) Information: ClusterID=1

(2013-07-09 15:28:36) Information: QDSID=f41df3ac-da9c-8ea2-1401-6b0f48c68800

(2013-07-09 15:28:36) Information: TaskID=2bc0988f-509b-4c53-b255-6e176bde710b

(2013-07-09 15:28:36) Information: MaxRunTime=06:00:00

(2013-07-09 15:28:36) Information: MachineName=QVS

(2013-07-09 15:28:36) Information: Max attempts:1

(2013-07-09 15:28:36) Information: Current Attempt=0

(2013-07-09 15:28:36) Information: Task Dependencies are OK

(2013-07-09 15:28:43) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2013-07-09 15:28:43) Information: Opening "C:\Qlikview Documents\SMV\SMV Qlikview.qvw"

(2013-07-09 15:28:43) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

(2013-07-09 15:28:43) Information: Max retries:5

(2013-07-09 15:28:43) Information: Attempt:01

(2013-07-09 15:28:44) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=4.

(2013-07-09 15:28:44) Information: Loading document "C:\Qlikview Documents\SMV\SMV Qlikview.qvw" (16.58 Mb)

(2013-07-09 15:28:45) Information: Loading. LoadTime=00:00:01.0140017

(2013-07-09 15:28:45) Information: Physical FileSize=16.58 Mb. Memory Allocation Delta for this file=94.40 Mb. Available Physical Memory Before Open=60373.65 Mb. Available Physical Memory After Open=60263.31 Mb. Total Physical Memory=65526.21 Mb.

(2013-07-09 15:28:45) Information: Attempted to load the document without data.

(2013-07-09 15:28:45) Information: The document was loaded successfully.

(2013-07-09 15:28:45) Information: Document was opened successfully

(2013-07-09 15:28:45) Information: Starting reload

(2013-07-09 15:28:45) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2013-07-09 15:28:45) Information: The Source Document is being reloaded. DocumentPath=C:\Qlikview Documents\SMV\SMV Qlikview.qvw

(2013-07-09 15:28:46) Information: Reloading.

(2013-07-09 15:28:47) Information: Reloading..

(2013-07-09 15:28:49) Information: Reloading...

(2013-07-09 15:28:50) Information: Reloading....

(2013-07-09 15:28:51) Information: Reloading.....

(2013-07-09 15:28:52) Information: Reloading......

(2013-07-09 15:28:53) Information: Reloading.......

(2013-07-09 15:28:54) Information: Reloading........

(2013-07-09 15:28:55) Information: Reloading.........

(2013-07-09 15:28:56) Information: Reloading..........

(2013-07-09 15:28:57) Information: Slow down logging. Log every <2> seconds.

(2013-07-09 15:28:57) Information: Reloading

(2013-07-09 15:28:59) Information: Reloading.

(2013-07-09 15:29:01) Information: Reloading..

(2013-07-09 15:29:03) Information: Reloading...

(2013-07-09 15:29:05) Information: Reloading....

(2013-07-09 15:29:07) Information: Reloading.....

(2013-07-09 15:29:09) Information: Reloading......

(2013-07-09 15:29:11) Information: Reloading.......

(2013-07-09 15:29:13) Information: Reloading........

(2013-07-09 15:29:15) Information: Reloading.........

(2013-07-09 15:29:17) Information: Reloading..........

(2013-07-09 15:29:19) Information: Slow down logging. Log every <10> seconds.

(2013-07-09 15:29:19) Information: Reloading

(2013-07-09 15:29:29) Information: Reloading.

(2013-07-09 15:29:39) Information: Reloading..

(2013-07-09 15:29:49) Information: Reloading...

(2013-07-09 15:29:59) Information: Reloading....

(2013-07-09 15:30:10) Information: Reloading.....

(2013-07-09 15:30:12) Information: The Source Document reload complete. DocumentPath=C:\Qlikview Documents\SMV\SMV Qlikview.qvw

(2013-07-09 15:30:12) Information: Memory Allocation Delta for this file=20.83 Mb. Available Physical Memory Before Reload=60263.27 Mb. Available Physical Memory After Reload=60261.13 Mb. Total Physical Memory=60261.13 Mb.

(2013-07-09 15:30:12) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\Qlikview Documents\SMV\SMV Qlikview.qvw.

(2013-07-09 15:30:12) Information: Closing the document.

(2013-07-09 15:30:13) Information: Closed the QlikView Engine successfully. ProcessID=3032

(2013-07-09 15:30:13) Error: The task "SMV/SMV Qlikview.qvw" failed. Exception:

(2013-07-09 15:30:13) 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=C:\Qlikview Documents\SMV\SMV Qlikview.qvw.

(2013-07-09 15:30:13) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2013-07-09 15:30:13) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-07-09 15:30:13) Error:    --- End of inner exception stack trace ---

(2013-07-09 15:30:13) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-07-09 15:30:13) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-07-09 15:30:13) Error:    --- End of inner exception stack trace ---

(2013-07-09 15:30:13) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-07-09 15:30:13) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2013-07-09 15:30:13) Information: Task Execute Duration=00:01:37.1413693

(2013-07-09 15:30:13) Information: TaskResult.status=Finished

(2013-07-09 15:30:13) Information: Notifying all triggers of new state:FinishedWithErrors

(2013-07-09 15:30:13) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2013-07-09 15:30:13) Information: Saving Task Result

Qlikview server:

Product Information


Product nameQMS Backend Core x64


Client Build Number11.20.11718.0


Target Platformx64


Publisher License KeyNo License


Service authenticationAD groups

Machine Information


Computer NameQVS


Operating System VersionWin32_OperatingSystem=@ X64 (Microsoft Windows NT 6.1.7601 Service Pack 1)


.NET Version4.0.30319.296


Physical Memory65526Mb


Available Memory60257Mb

Reload Engine:


Product Information


Product nameQlikView Distribution Service x64


Client Build Number11.20.11718.0


Target Platformx64

Machine Information


Computer NameQVS


Operating System VersionWin32_OperatingSystem=@ X64 (Microsoft Windows NT 6.1.7601 Service Pack 1)


.NET Version4.0.30319.296


Physical Memory65526Mb


Available Memory60257Mb
16 Replies
Employee
Employee

Re: Error while running reload task

Hi,

What is showing in the document log? Can you post that here?

Did any of the file path change?

Did any ODBC connections properties change?

Bill

Not applicable

Re: Error while running reload task

Hi,

Where can i find the document log?

The filepath did not change. it is in the same location. The only thing my colleague did, was the following:

in C:\Qlikview Documents\ (the root folder for the documents) the document SMV.qvw is replaced by a new SMV.qvw.

Also, no ODBC connections proprties changed.

Re: Error while running reload task

The document log is in the same folder as the qvw. It is named the same as the qvw with a ".log" extension.

If the document log is not present, it needs to be set on in the Settings->Document Properties->General, Generate Logfile.

-Rob

Not applicable

Re: Error while running reload task

I don't have the logfile.

I searched for the option you supplied, but the only thing I could find is displayed as in the screenshot below. An option "enable audit logging" is enabled.

Untitled.png

Re: Error while running reload task

Hi,

     One of the reason could be that the user who reloads the application (May be the Admin) doesnt have the right to write the document.

     Make sure that the user which is allowed to run the qlikview server services has the full access to the SMV.qvw

Regards,

Kaushik Solanki

Not applicable

Re: Error while running reload task

Hi,

The user does not reload the document by itself. The Qlikview Server has a timer which reloads the document every 5 minutes. Every user is in the default qlikview user account group named "Qlikview Users".

Not applicable

Re: Error while running reload task

In your application..click Settings->Document Properties->General > Generate Logfile

Not applicable

Re: Error while running reload task

Hi Bika,

I am not able to post new messages in qlikcommunity it is showing "will need to be approved by a moderator before it will be viewable by others".please can you help me in this?

Thanks,

Amelia2000

Re: Error while running reload task

Dear Nazeem,

     I understand that the QlikView does the sceduling but the thing i wanted say about user is the user which is allowed to run the qlikview services should have the full access on the file.

     The user which is passed when installing the server.

Regards,

Kaushik Solanki

Community Browser