Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brijesh1991
Partner - Specialist
Partner - Specialist

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
Bill_Britt
Former Employee
Former Employee

Hi,

See if this will help.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

12 Replies
Not applicable

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
Creator III
Creator III

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

Bill_Britt
Former Employee
Former Employee

Hi,

See if the attached document will help.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
brijesh1991
Partner - Specialist
Partner - Specialist
Author

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
Partner - Specialist
Partner - Specialist
Author

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

Bill_Britt
Former Employee
Former Employee

Can you post the distribution log for the task?

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
brijesh1991
Partner - Specialist
Partner - Specialist
Author

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

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
Creator III
Creator III

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