Qlikview SR1 Server Automatically Reload keeps on failing - Urgent (Help)

[Anonymous]

Hi,

After grading, we cannot reload our document automatically from the server,

This is what show up in the Log:

(2012-05-30 14:31:06) Information: Starting task 'Decalog.qvw'. Id:5e15e81a-3686-4808-b12b-be91b8bf2abe. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2012-05-30 14:31:06) Information: Entering Task Execution.

(2012-05-30 14:31:06) Information: ClusterID=1

(2012-05-30 14:31:06) Information: QDSID=8c939d7c-3f8d-a0c1-7c0a-d1dd37b198c5

(2012-05-30 14:31:06) Information: TaskID=5e15e81a-3686-4808-b12b-be91b8bf2abe

(2012-05-30 14:31:06) Information: MaxRunTime=06:00:00

(2012-05-30 14:31:06) Information: MachineName=ZAWCAPP09

(2012-05-30 14:31:06) Information: Max attempts:1

(2012-05-30 14:31:06) Information: Current Attempt=0

(2012-05-30 14:31:06) Information: Task Dependencies are OK

(2012-05-30 14:31:06) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2012-05-30 14:31:06) Information: Opening "C:\ProgramData\QlikTech\QVD\LiveModels\Decalog.qvw"

(2012-05-30 14:31:06) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

(2012-05-30 14:31:06) Information: Max retries:5

(2012-05-30 14:31:06) Information: Attempt:01

(2012-05-30 14:31:06) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=14

(2012-05-30 14:31:06) Information: Loading document "C:\ProgramData\QlikTech\QVD\LiveModels\Decalog.qvw" (1.19 Mb)

(2012-05-30 14:31:06) Information: Physical FileSize=1.19 Mb. Memory Allocation Delta for this file=4.55 Mb. Available Physical Memory Before Open=50122.03 Mb. Available Physical Memory After Open=50114.90 Mb. Total Physical Memory=65274.64 Mb.

(2012-05-30 14:31:06) Information: Attempted to load the document without data.

(2012-05-30 14:31:06) Information: The document was loaded successfully.

(2012-05-30 14:31:06) Information: Document was opened successfully

(2012-05-30 14:31:06) Information: Starting reload

(2012-05-30 14:31:06) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2012-05-30 14:31:06) Information: The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\QVD\LiveModels\Decalog.qvw

(2012-05-30 14:31:07) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\QVD\LiveModels\Decalog.qvw

(2012-05-30 14:31:07) Information: Memory Allocation Delta for this file=1.09 Mb. Available Physical Memory Before Reload=50114.88 Mb. Available Physical Memory After Reload=50110.25 Mb. Total Physical Memory=50110.25 Mb.

(2012-05-30 14:31:07) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\QVD\LiveModels\Decalog.qvw.

(2012-05-30 14:31:07) Information: Closing the document.

(2012-05-30 14:31:07) Information: Closed the QlikView Engine successfully. ProcessID=1944

(2012-05-30 14:31:07) Error: The task "Decalog.qvw" failed. Exception:

(2012-05-30 14:31:07) 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:\ProgramData\QlikTech\QVD\LiveModels\Decalog.qvw.

(2012-05-30 14:31:07) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2012-05-30 14:31:07) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2012-05-30 14:31:07) Error:    --- End of inner exception stack trace ---

(2012-05-30 14:31:07) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2012-05-30 14:31:07) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-05-30 14:31:07) Error:    --- End of inner exception stack trace ---

(2012-05-30 14:31:07) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-05-30 14:31:07) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2012-05-30 14:31:07) Information: Task Execute Duration=00:00:01.8281016

(2012-05-30 14:31:07) Information: TaskResult.status=Finished

(2012-05-30 14:31:08) Information: Notifying all triggers of new state:FinishedWithErrors

(2012-05-30 14:31:08) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2012-05-30 14:31:08) Information: Saving Task Result

Can anyone help with this......

Kind Regards

Razak

[#2]

Have you tried to delete the reload task and creating a new?

Something similar happened to me and I had to remove all reload task and re-create.

A greeting.

[Miguel_Angel_Baeyens]

Hi Razak,

Does the reload work fine when you do it using the Desktop? Are the ODBC configured for the user that is running the QlikView services? Is this user member of the local Administrators and QlikView Administrators group?

Hope that helps.

Miguel

[Anonymous]

Hi,

I just generated a log file, this is the message I am receiving,

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed for user 'USER'.

When I reload from Qlikview i.e. Ctrl + R, It works but I always have to type in the password, this is the

script I am using to connect to database:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=USER;Initial Catalog=InfoStore;Data Source=Server1;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=AAAAAAA;Use Encryption for Data=False;Tag with column collation when possible=False];

Kind Regards

Razak

[Miguel_Angel_Baeyens · Accepted solution]

Hi Razak,

When you create the OLEDB connection, you will need to add the password into the DSN or the OLEDB connection (check the "Allow saving password" mark).

Hope that helps.

Miguel

[Anonymous]

Hi Miguel,

Thanks I have added the password in the connection and it seems to be working,

Kind Regards

Razak