topic Re: Distribution Failed in QlikView

Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 07:23:13 GMT

Hi All,

I have scheduled a task based on 'another event'.

I have two files: file1.qvw and file2.qvw

file1.qvw is schedule on EDX, that's running fine.

After completion of file1.qvw, file2.qvw is also running file.

But I wanted to distribute this file2.qvw in a shared folder. Till today it was running fine.

File2.qvw is reloaded and closed, just it's not distributed on shared path.

Any ideaes are well welcomed. . .

-Brijesh

Re: Distribution Failed

Anonymous — Thu, 09 Jan 2014 07:45:41 GMT

Hi,

Are you using publisher?

Re: Distribution Failed

fabrice_lawson — Thu, 09 Jan 2014 07:48:49 GMT

since this is a distribution to a shared folder, probably he is using publisher,

does the document appears in the folder on disk and not on the accesspoint?

Re: Distribution Failed

Anonymous — Thu, 09 Jan 2014 07:54:36 GMT

Hi,

He wants to distribute to a shared folder, not the same as being able to...

Re: Distribution Failed

fabrice_lawson — Thu, 09 Jan 2014 07:59:17 GMT

"But I wanted to distribute this file2.qvw in a shared folder. Till today it was running fine."

Re: Distribution Failed

dmohanty — Thu, 09 Jan 2014 08:11:44 GMT

Hi Brijesh,

If you are using a Publisher (QMC), go to System tab>> Set up tab>>Select QV Server (from left pane)>>Documents tab, make sure that the option "Allow document upload" is enabled (Tick Mark).

If it is not enabled, it might be failing for that reason.

Regards!!

Re: Distribution Failed

Anonymous — Thu, 09 Jan 2014 08:15:17 GMT

Yes, I agree most likely they are using publisher. It is a control question just to make sure because sometimes we don't use the correct terms.

As Brijesh is not getting any warnings I assume it is not a problem with access rights to the shared folder, however if the document is not visible from accesspoint but is present in the folder you might just still want to check the access rights on folder and file to make sure the users have read permissions.

I would also start looking at the actual task and check the distribution tab to check to see if any changes have been made there and also make sure the folder is browsable (System --> setup --> QlikView Servers --> Folders).

Re: Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 09:13:26 GMT

Yes.. Documents is reloaded by publisher and also it is saving the QVW in my E drive.

After that I am distributing it in a shared folder between two servers which is not happening...

Re: Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 09:14:25 GMT

Yes.. I am using publisher

Re: Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 09:16:14 GMT

Thanks nill...

I have 25 dashboard, out of them 23 are well distributed to shared path, just 2 are not distributed. . .

Re: Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 09:17:07 GMT

Hi DMohanty,

This option is enabled

Re: Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 09:18:08 GMT

Hi Fabric,

You are right. The document is there in disk, but it's not there on shared path which is my access point path

Re: Distribution Failed

fabrice_lawson — Thu, 09 Jan 2014 09:27:37 GMT

thanks for the reply, have you taken a look at the tasklog?

Since the other 23 applications are working and get distributed accordingly, the logfile should tell us something.

on the QMC, do you get the message that the task has failed?

Re: Distribution Failed

dmohanty — Thu, 09 Jan 2014 09:41:22 GMT

Is the Distribute location properly mounted/mentioned in the Dsitribute tab for the particular task?

Could you please share the task logs for the failed task?

Re: Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 09:42:57 GMT

Hi Febrice,

Thanks for your input. you are right.

Till 3rd JAN, tasklog.txt for this file was generated, but after that this tasklog.txt is not generated.

Below is the tasklog.txt generated on 3rd JAN.

1/3/2014 08:05:56.3442892 Information Starting task 'Reload of Sales Dashboard.qvw'. Id:08ef59a7-fe8c-480b-8650-37e3b4c670a9. Triggered by 'TaskCompletedTrigger'. Id:42aeab66-0306-4e93-a682-7f9f10321797

1/3/2014 08:05:56.3442892 Information Entering Task Execution.

1/3/2014 08:05:56.3442892 Information ClusterID=1

1/3/2014 08:05:56.3442892 Information QDSID=8351097d-7555-75a8-50c0-acb3d92408c6

1/3/2014 08:05:56.3442892 Information TaskID=08ef59a7-fe8c-480b-8650-37e3b4c670a9

1/3/2014 08:05:56.3442892 Information MaxRunTime=1.00:00:00

1/3/2014 08:05:56.3442892 Information Max attempts:1

1/3/2014 08:05:56.3442892 Information Current Attempt=0

1/3/2014 08:05:56.3442892 Information Task Dependencies are OK

1/3/2014 08:05:56.3598893 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

1/3/2014 08:05:56.3598893 Information Opening "E:\QV Sales App\Applications\Sales Dashboard.qvw"

1/3/2014 08:05:57.5454969 Information Failed to allocate new QlikView Engine. Retrying (2)! Current usagecount=4 of 4

1/3/2014 08:06:34.0497309 Information Allocating new QlikView Engine. Current usagecount=4 of 4

1/3/2014 08:06:34.0497309 Information Max retries:5

1/3/2014 08:06:34.0497309 Information Attempt:01

1/3/2014 08:06:34.8765362 Information Allocated QlikView Engine successfully. Current usagecount=4 of 4, Ticket=66

1/3/2014 08:06:34.8765362 Information Loading document "E:\QV Sales App\Applications\Sales Dashboard.qvw" (1558.51 Mb)

1/3/2014 08:06:35.8905427 Information Loading. LoadTime=00:00:01.0140065

1/3/2014 08:06:37.9185557 Information Loading. LoadTime=00:00:03.0420195

1/3/2014 08:06:41.9745817 Information Loading. LoadTime=00:00:07.0980455

1/3/2014 08:06:42.8481873 Information Physical FileSize=1558.51 Mb. Memory Allocation Delta for this file=576.67 Mb. Available Physical Memory Before Open=219198.20 Mb. Available Physical Memory After Open=222297.79 Mb. Total Physical Memory=262079.72 Mb.

1/3/2014 08:06:42.8793875 Information Attempted to load the document without data.

1/3/2014 08:06:42.8793875 Information The document was loaded successfully.

1/3/2014 08:06:42.8793875 Information Document was opened successfully

1/3/2014 08:06:42.8793875 Information Starting reload

1/3/2014 08:06:42.8949876 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

1/3/2014 08:06:42.8949876 Information The Source Document is being reloaded. DocumentPath=E:\QV Sales App\Applications\Sales Dashboard.qvw

1/3/2014 08:06:43.8933940 Information Reloading.

1/3/2014 08:06:44.9074005 Information Reloading..

1/3/2014 08:06:45.9214070 Information Reloading...

1/3/2014 08:06:46.9354135 Information Reloading....

1/3/2014 08:06:47.9494200 Information Reloading.....

1/3/2014 08:06:48.9634265 Information Reloading......

1/3/2014 08:06:49.9774330 Information Reloading.......

1/3/2014 08:06:50.9914395 Information Reloading........

1/3/2014 08:06:52.0054460 Information Reloading.........

1/3/2014 08:06:53.0194525 Information Reloading..........

1/3/2014 08:06:54.0334590 Information Slow down logging. Log every <2> seconds.

1/3/2014 08:06:54.0334590 Information Reloading

1/3/2014 08:06:56.0614720 Information Reloading.

1/3/2014 08:06:58.0894850 Information Reloading..

1/3/2014 08:07:00.1174980 Information Reloading...

1/3/2014 08:07:02.1455110 Information Reloading....

1/3/2014 08:07:04.1735240 Information Reloading.....

1/3/2014 08:07:06.2015370 Information Reloading......

1/3/2014 08:07:08.2295500 Information Reloading.......

1/3/2014 08:07:10.2575630 Information Reloading........

1/3/2014 08:07:12.2855760 Information Reloading.........

1/3/2014 08:07:14.3135890 Information Reloading..........

1/3/2014 08:07:16.3416020 Information Slow down logging. Log every <10> seconds.

1/3/2014 08:07:16.3416020 Information Reloading

1/3/2014 08:07:26.4816670 Information Reloading.

1/3/2014 08:07:35.5609252 Information The Source Document reload complete. DocumentPath=E:\QV Sales App\Applications\Sales Dashboard.qvw

1/3/2014 08:07:35.5609252 Information Memory Allocation Delta for this file=4944.62 Mb. Available Physical Memory Before Reload=222296.67 Mb. Available Physical Memory After Reload=219149.41 Mb. Total Physical Memory=219149.41 Mb.

1/3/2014 08:07:36.6217320 Information Reloading..

1/3/2014 08:07:37.3861369 Information The Source Document was reloaded successfully.

1/3/2014 08:07:37.3861369 Information Reload finished successfully

1/3/2014 08:07:37.3861369 Information Start saving document

1/3/2014 08:11:01.9034479 Information Check in document: E:\QV Sales App\Applications\Sales Dashboard.qvw

1/3/2014 08:11:01.9346481 Information Closing the document.

1/3/2014 08:11:03.3386571 Information Closed the QlikView Engine successfully. ProcessID=16688

1/3/2014 08:11:03.3386571 Information Start document distribution.

1/3/2014 08:11:03.3386571 Information Opening source document

1/3/2014 08:11:03.3386571 Information Opening document: "Sales Dashboard.qvw"

1/3/2014 08:11:03.3386571 Information Allocating new QlikView Engine. Current usagecount=4 of 4

1/3/2014 08:11:03.3386571 Information Max retries:5

1/3/2014 08:11:03.3386571 Information Attempt:01

1/3/2014 08:11:04.1966626 Information Allocated QlikView Engine successfully. Current usagecount=4 of 4, Ticket=68

1/3/2014 08:11:04.1966626 Information Loading document "E:\QV Sales App\Applications\Sales Dashboard.qvw" (1560.85 Mb)

1/3/2014 08:11:05.2106691 Information Loading. LoadTime=00:00:01.0140065

1/3/2014 08:11:07.2386821 Information Loading. LoadTime=00:00:03.0420195

1/3/2014 08:11:11.2947081 Information Loading. LoadTime=00:00:07.0980455

1/3/2014 08:11:19.4067601 Information Loading. LoadTime=00:00:15.2100975

1/3/2014 08:11:35.6308641 Information Loading. LoadTime=00:00:31.4342015

1/3/2014 08:12:08.0790721 Information Loading. LoadTime=00:01:03.8824095

1/3/2014 08:13:08.9194621 Information Loading. LoadTime=00:02:04.7227995

1/3/2014 08:14:04.5338186 Information Physical FileSize=1560.85 Mb. Memory Allocation Delta for this file=5496.43 Mb. Available Physical Memory Before Open=217333.78 Mb. Available Physical Memory After Open=214285.48 Mb. Total Physical Memory=262079.72 Mb.

1/3/2014 08:14:04.5962190 Information Attempted to load the document with data.

1/3/2014 08:14:04.5962190 Information The document was loaded successfully.

1/3/2014 08:14:16.4834952 Information Reduce skipped, nothing is selected.

1/3/2014 08:14:16.4834952 Information Document was opened successfully

1/3/2014 08:14:16.4834952 Information Determined 1 static recipients spread over 1 Distribution Resources.

1/3/2014 08:14:16.4834952 Information Number of rule combinations was calculated successfully. Rounds=1

1/3/2014 08:14:16.4834952 Information Empty rules

1/3/2014 08:14:16.4834952 Information Rules resulted in distribution.

1/3/2014 08:14:16.4834952 Information ROUND: 0 of 1. WarningCount=0

1/3/2014 08:14:16.4834952 Information Building filename

1/3/2014 08:14:16.4834952 Information Destination name: Sales Dashboard.qvw

1/3/2014 08:14:16.4834952 Information Set script

1/3/2014 08:14:16.5146954 Information Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear

1/3/2014 08:14:16.5146954 Information Offer resources

1/3/2014 08:14:17.8251038 Information Commencing ReduceData

1/3/2014 08:16:46.4472565 Information Completed ReduceData

1/3/2014 08:16:46.4472565 Information Memory Allocation Delta for this file=30.93 Mb. Available Physical Memory Before Reduce=214253.85 Mb. Available Physical Memory After Reduce=222505.60 Mb. Total Physical Memory=222505.60 Mb.

1/3/2014 08:16:46.4472565 Information Distributing

1/3/2014 08:16:46.4472565 Information Distributing using resource "Reload of Sales Dashboard.qvw_Folder_1".

1/3/2014 08:16:46.4472565 Information Creating/Updating file: \\HYDIPRUQLKCLSFS\Qlikview_Share\Sales Dashboard.qvw

1/3/2014 08:16:48.0696669 Information 100% - \\HYDIPRUQLKCLSFS\Qlikview_Share\Sales Dashboard.qvw

1/3/2014 08:16:48.3036684 Information Performance data (CopyFile): FileSystemAccessRules=3 (0), Creating temporary file: \\HYDIPRUQLKCLSFS\Qlikview_Share\Sales Dashboard.tmp (0), Temporary file written successfully. (1623), Deleting old destination file. (1623), Renaming temporary file to destination file. (1857), Write complete. (1857)

1/3/2014 08:16:48.3036684 Information Distribution finished successfully.

1/3/2014 08:16:48.3036684 Information Deleting temporary files.

1/3/2014 08:16:49.2396744 Information Closing the document.

1/3/2014 08:16:50.5032825 Information Closed the QlikView Engine successfully. ProcessID=14128

1/3/2014 08:16:50.5032825 Information Document distribution done.

1/3/2014 08:16:50.5032825 Information Task Execute Duration=00:10:54.1589933

1/3/2014 08:16:50.5032825 Information The task "Reload of Sales Dashboard.qvw" finished successfully

1/3/2014 08:16:50.5032825 Information TaskResult.status=Finished

1/3/2014 08:16:50.5032825 Information Notifying all triggers of new state:Finished

1/3/2014 08:16:50.7372840 Information Notifying all triggers of new state:Finished - completed

1/3/2014 08:16:50.7372840 Information Saving Task Result

Re: Distribution Failed

brijesh1991 — Thu, 09 Jan 2014 09:48:16 GMT

Thanks DMohanty,

Last time this tasklog.txt was generated on 3rd Jan, after that this log has stopped to generate even..