topic Re: Scheduled upload failing in QlikView

Scheduled upload failing

Fri, 16 Nov 2012 08:40:08 GMT

Hi,

After creating all my qvw's I'm trying to publish them on the QlikView Server with a scheduled reload overnight. I've set everything up and it appears to be failing for some reason. here is an extract from the log which unfortunately means little to my non-tech mind -

2012-11-16 07:00:01) Information: Starting task 'QlikViewDocs/Central Billing Reporting v4.qvw'. Id:121b5d0f-e207-4154-9da1-02125bc43ae1. Triggered by 'ScheduleTrigger'. Id:0eb36e6c-920a-4be5-a59f-b91cae1d2412

(2012-11-16 07:00:01) Information: Entering Task Execution.

(2012-11-16 07:00:01) Information: ClusterID=1

(2012-11-16 07:00:01) Information: QDSID=d44e95de-aacb-a4a8-96b5-fcc3d83b5966

(2012-11-16 07:00:01) Information: TaskID=121b5d0f-e207-4154-9da1-02125bc43ae1

(2012-11-16 07:00:01) Information: MaxRunTime=06:00:00

(2012-11-16 07:00:01) Information: Max attempts:1

(2012-11-16 07:00:01) Information: Current Attempt=0

(2012-11-16 07:00:01) Information: Task Dependencies are OK

(2012-11-16 07:00:01) Error: The task "QlikViewDocs/Central Billing Reporting v4.qvw" failed. Exception:

(2012-11-16 07:00:01) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> System.ArgumentNullException: Value cannot be null.

(2012-11-16 07:00:01) Error: Parameter name: stringToUnescape

(2012-11-16 07:00:01) Error: at System.Uri.UnescapeDataString(String stringToUnescape)

(2012-11-16 07:00:01) Error: at QDSMain.DistributeTask.GetFileName(String path)

(2012-11-16 07:00:01) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-11-16 07:00:01) Error: --- End of inner exception stack trace ---

(2012-11-16 07:00:01) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-11-16 07:00:01) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2012-11-16 07:00:01) Information: Task Execute Duration=00:00:00.1562500

(2012-11-16 07:00:01) Information: TaskResult.status=Finished

(2012-11-16 07:00:01) Information: Notifying all triggers of new state:FinishedWithErrors

(2012-11-16 07:00:01) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2012-11-16 07:00:01) Information: Saving Task Result

When I do the upload manually it works without any issues and the logfile comes out clean. with the sceduled reload - nothing is uploading at all.

Can anyone help shed light on the problem or point me in the right direction please?

Many thanks in advance

Re: Scheduled upload failing

hallquist_nate — Fri, 16 Nov 2012 20:00:00 GMT

Does the app have Set Analysis? Are you using a service account to runQVS?

Re: Scheduled upload failing

Fri, 16 Nov 2012 20:49:42 GMT

Dear,

some days back i also had the same issue.

i found the solution.

goto-->QMC----->SystemTab--->SetUp---> expand the qlikview servers ---> QVS@server 1-----> Documents-->

enable the check box for

Allow Document Upload.

I hope this will help you.

Thanks,

Mukram.

Re: Scheduled upload failing

Mon, 19 Nov 2012 09:57:47 GMT

Hi Nate,

No set analysis; I've created the simplest document with no objects just simply a load of data.

Thx

Re: Scheduled upload failing

Mon, 19 Nov 2012 09:58:57 GMT

Hi qva_mukram,

I took a look at this and it is already ticked.

Fingers crossed QlikTech might be able to help.

Thx

Re: Scheduled upload failing

villafuerte — Wed, 21 Nov 2012 15:58:33 GMT

Hi,

Could you solve this problem? I'm having the same issue.

I created a simple QVW as well, only loading one table. When I reload it from QV Desktop it runs well, but it always fail in the server with the same error...

Any ideas?

Re: Scheduled upload failing

Tue, 27 Nov 2012 15:33:00 GMT

Well this is part of a semi-solution I got

"... QlikTech support and they have seen this happen when a change is made directly or indirectly affecting the QV Service Account. To check if this is the case (...) create a local user on the QlikView Server and put this local user into Local Administrators and QlikView Administrators groups. Set this user as the logon account for the QlikView Services and restart the services. Then try a reload via QMC of a document.

"If this works and none of your documents use source information on mapped drives then you could leave it as the replacement QV Service Account. Or you could try an alternative domain account (that should be added to Local Admins and QlikView Administrators groups)."

Now, I'm not too techie myself and my IT guy did this for me and seemed to help for one day but I'm now back to square one and getting QlikTech to help now once my IT guy is back of holiday - I wait with eagerness as we are meant to be in Test Phase now!

Hope it helps you.

Re: Scheduled upload failing

Wed, 06 Mar 2013 17:21:39 GMT

Hello

I practicly Had the same issue, I restarted the services and it worked fine.

Re: Scheduled upload failing

Wed, 10 Apr 2013 22:10:17 GMT

Thanks cchhatralia,

I had the same error. It was because the Qlikview Service account was disabled in my corp active directory. As soon as it is activated back, the ETL's worked perfect.