Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

brijesh1991
Contributor III

Document Report Distribution through Email


Hi all,

I am distributing a document report through publisher.

Problem is: User are getting the email, but attachment is missing from mail.

Kindly input your ideas. . .

Thanks,

Brijesh

1 Solution

Accepted Solutions
Employee
Employee

Re: Document Report Distribution through Email

Hi,

See if this will help.

Bill

12 Replies
Not applicable

Re: Document Report Distribution through Email

Hi Brijesh,

See this vedio,.. Creating a Report and Using PDF Distribution - YouTube

You will get good understanding of Report distribution through Mail.

Hope it helps,

Regards,

Koti

timsaddler
Contributor II

Re: Document Report Distribution through Email

Hello

One thing you can do is check whether you are creating the pdf's by saving them in a folder whilst running the job.

See second screenshot

QMC1.png

QMC2.png

Employee
Employee

Re: Document Report Distribution through Email

Hi,

See if the attached document will help.

Bill

brijesh1991
Contributor III

Re: Document Report Distribution through Email

Hi Bill,

Thanks. . .

I follow the exact process that you mentioned in document; I am getting mail, but the attached pdf report is missing from mail (Mail contains just plain text; no attachment)

-Brijesh

brijesh1991
Contributor III

Re: Document Report Distribution through Email

Hi Tim,

Thanks. . .

I follow the exact process that you captured in above snapshots; I am getting mail, but mail contains just plain text, pdf report is missing in mail.

-Brijesh

Employee
Employee

Re: Document Report Distribution through Email

Can you post the distribution log for the task?

Bill

brijesh1991
Contributor III

Re: Document Report Distribution through Email

Yeah Thanks Bill. . .

[Server RAM: 256 GB]

Here you go with Log details. . .

(2014-03-12 19:07:58) Information: Starting task 'Reload and Distribute of Printing test.qvw'. Id:86aa36d3-350f-4f0a-8ce9-3280e01707a7. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2014-03-12 19:07:58) Information: Entering Task Execution.

(2014-03-12 19:07:58) Information: ClusterID=1

(2014-03-12 19:07:58) Information: QDSID=5a02d6bd-e32c-b1e9-c3a4-d5f81c27cca7

(2014-03-12 19:07:58) Information: TaskID=86aa36d3-350f-4f0a-8ce9-3280e01707a7

(2014-03-12 19:07:58) Information: MaxRunTime=1.00:00:00

(2014-03-12 19:07:58) Information: Max attempts:1

(2014-03-12 19:07:58) Information: Current Attempt=0

(2014-03-12 19:07:58) Information: Task Dependencies are OK

(2014-03-12 19:07:58) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2014-03-12 19:07:58) Information: Opening "E:\QV Sales App\Applications\Printing test.qvw"

(2014-03-12 19:07:58) Information: Allocating new QlikView Engine. Current usagecount=1 of 10

(2014-03-12 19:07:58) Information: Max retries:5

(2014-03-12 19:07:58) Information: Attempt:01

(2014-03-12 19:07:59) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 10, Ticket=43

(2014-03-12 19:07:59) Information: Loading document "E:\QV Sales App\Applications\Printing test.qvw" (0.21 Mb)

(2014-03-12 19:08:00) Information: Physical FileSize=0.21 Mb. Memory Allocation Delta for this file=4.08 Mb. Available Physical Memory Before Open=241729.02 Mb. Available Physical Memory After Open=241723.86 Mb. Total Physical Memory=262079.77 Mb.

(2014-03-12 19:08:00) Information: Attempted to load the document without data.

(2014-03-12 19:08:00) Information: The document was loaded successfully.

(2014-03-12 19:08:00) Information: Document was opened successfully

(2014-03-12 19:08:00) Information: Starting reload

(2014-03-12 19:08:00) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2014-03-12 19:08:00) Information: The Source Document is being reloaded. DocumentPath=E:\QV Sales App\Applications\Printing test.qvw

(2014-03-12 19:08:00) Information: The Source Document reload complete. DocumentPath=E:\QV Sales App\Applications\Printing test.qvw

(2014-03-12 19:08:00) Information: Memory Allocation Delta for this file=7.46 Mb. Available Physical Memory Before Reload=241723.85 Mb. Available Physical Memory After Reload=241723.73 Mb. Total Physical Memory=241723.73 Mb.

(2014-03-12 19:08:00) Information: The Source Document was reloaded successfully.

(2014-03-12 19:08:00) Information: Reload finished successfully

(2014-03-12 19:08:00) Information: Start saving document

(2014-03-12 19:08:00) Information: Check in document: E:\QV Sales App\Applications\Printing test.qvw

(2014-03-12 19:08:00) Information: Closing the document.

(2014-03-12 19:08:01) Information: Closed the QlikView Engine successfully. ProcessID=2428

(2014-03-12 19:08:01) Information: Start document distribution.

(2014-03-12 19:08:01) Information: Opening source document

(2014-03-12 19:08:01) Information: Opening document: "Printing test.qvw"

(2014-03-12 19:08:01) Information: Allocating new QlikView Engine. Current usagecount=1 of 10

(2014-03-12 19:08:01) Information: Max retries:5

(2014-03-12 19:08:01) Information: Attempt:01

(2014-03-12 19:08:02) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 10, Ticket=44

(2014-03-12 19:08:02) Information: Loading document "E:\QV Sales App\Applications\Printing test.qvw" (0.21 Mb)

(2014-03-12 19:08:02) Information: Physical FileSize=0.21 Mb. Memory Allocation Delta for this file=4.29 Mb. Available Physical Memory Before Open=241712.74 Mb. Available Physical Memory After Open=241708.58 Mb. Total Physical Memory=262079.77 Mb.

(2014-03-12 19:08:02) Information: Attempted to load the document with data.

(2014-03-12 19:08:02) Information: The document was loaded successfully.

(2014-03-12 19:08:02) Information: Reduce skipped, nothing is selected.

(2014-03-12 19:08:02) Information: Document was opened successfully

(2014-03-12 19:08:02) Information: Determined 1 static recipients spread over 2 Distribution Resources.

(2014-03-12 19:08:02) Information: Number of rule combinations was calculated successfully. Rounds=1

(2014-03-12 19:08:02) Information: Empty rules

(2014-03-12 19:08:02) Information: Rules resulted in distribution.

(2014-03-12 19:08:02) Information: ROUND: 0 of 1. WarningCount=0

(2014-03-12 19:08:02) Information: Building filename

(2014-03-12 19:08:02) Information: Destination name: Printing test.qvw

(2014-03-12 19:08:02) Information: Set script

(2014-03-12 19:08:02) Information: Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear

(2014-03-12 19:08:02) Information: Applying DDD recipients

(2014-03-12 19:08:02) Information: Dynamic Distribution for field Email returned 2possible recipients

(2014-03-12 19:08:02) Information: No validation of email addresses requested. Using data directly from source document.

(2014-03-12 19:08:02) Information: Searching using "EmailAddress" using parameter "Email" returned 2 results.

(2014-03-12 19:08:02) Information: Offer resources

(2014-03-12 19:08:02) Information: Commencing ReduceData

(2014-03-12 19:08:02) Information: Allocating new QlikView Engine. Current usagecount=2 of 10

(2014-03-12 19:08:02) Information: Max retries:5

(2014-03-12 19:08:02) Information: Attempt:01

(2014-03-12 19:08:03) Information: Allocated QlikView Engine successfully. Current usagecount=2 of 10, Ticket=45

(2014-03-12 19:08:03) Information: Loading document "C:\ProgramData\QlikTech\DistributionService\1\temp\2d3907a9-60ba-4462-a6ae-d09bed9f46ad\document.qvw" (0.21 Mb)

(2014-03-12 19:08:04) Information: Physical FileSize=0.21 Mb. Memory Allocation Delta for this file=4.16 Mb. Available Physical Memory Before Open=241713.38 Mb. Available Physical Memory After Open=241708.66 Mb. Total Physical Memory=262079.77 Mb.

(2014-03-12 19:08:04) Information: Attempted to load the document with data.

(2014-03-12 19:08:04) Information: The document was loaded successfully.

(2014-03-12 19:08:04) Information: Document was opened successfully

(2014-03-12 19:08:04) Information: Completed ReduceData

(2014-03-12 19:08:04) Information: Memory Allocation Delta for this file=0.77 Mb. Available Physical Memory Before Reduce=241708.53 Mb. Available Physical Memory After Reduce=241708.66 Mb. Total Physical Memory=241708.66 Mb.

(2014-03-12 19:08:04) Information: Closing the document.

(2014-03-12 19:08:05) Information: Closed the QlikView Engine successfully. ProcessID=13008

(2014-03-12 19:08:05) Information: Distributing

(2014-03-12 19:08:05) Information: Distributing using resource "Reload and Distribute of Printing test.qvw_Folder_1".

(2014-03-12 19:08:05) Information: Creating/Updating file: \\HYDIPRUQLKCLSFS\Qlikview_Share\Printing test.pdf

(2014-03-12 19:08:05) Information: 100% - \\HYDIPRUQLKCLSFS\Qlikview_Share\Printing test.pdf

(2014-03-12 19:08:05) Information: Performance data (CopyFile): FileSystemAccessRules=3 (0), Creating temporary file: \\HYDIPRUQLKCLSFS\Qlikview_Share\Printing test.tmp (0), Temporary file written successfully. (46), Deleting old destination file. (46), Renaming temporary file to destination file. (46), Write complete. (46)

(2014-03-12 19:08:05) Information: Distributing using resource "Reload and Distribute of Printing test.qvw_MailAttachment_2".

(2014-03-12 19:08:05) Information: Distribution finished successfully.

(2014-03-12 19:08:05) Information: Deleting temporary files.

(2014-03-12 19:08:05) Information: Closing the document.

(2014-03-12 19:08:05) Information: Closed the QlikView Engine successfully. ProcessID=13392

(2014-03-12 19:08:05) Information: Document distribution done.

(2014-03-12 19:08:05) Information: Task Execute Duration=00:00:06.9905396

(2014-03-12 19:08:05) Information: The task "Reload and Distribute of Printing test.qvw" finished successfully

(2014-03-12 19:08:05) Information: TaskResult.status=Finished

(2014-03-12 19:08:05) Information: Notifying all triggers of new state:Finished

(2014-03-12 19:08:06) Information: Notifying all triggers of new state:Finished - completed

Not applicable

Re: Document Report Distribution through Email

Hello Guys,

Any ideas on this please? I am also trying something similar, only difference is that instead of sending the document via email I am trying to distribute the splitted qvw files(based on a field/field value), to the distribution path, which is my publish folder (from where access point picks up the qvws). But I cannot see any distributed copies under the publish folder, even though the QV Scheduler Log says that the 'Document Distribution Done'.

Thanks in Advance,

Robinson

timsaddler
Contributor II

Re: Document Report Distribution through Email

Create a child folder under your publish path and point the distribution to that desination

Community Browser