12 Replies Latest reply: Jul 11, 2014 1:53 AM by BRIJESH GADHESARIYA RSS

    Document Report Distribution through Email

    BRIJESH GADHESARIYA


      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

        • 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

          • Re: Document Report Distribution through Email
            Tim Saddler

            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

            • Re: Document Report Distribution through Email
              Bill Britt

              Hi,

               

              See if the attached document will help.

               

              Bill

                • Re: Document Report Distribution through Email
                  BRIJESH GADHESARIYA

                  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

                    • Re: Document Report Distribution through Email
                      Bill Britt

                      Can you post the distribution log for the task?

                       

                      Bill

                        • Re: Document Report Distribution through Email
                          BRIJESH GADHESARIYA

                          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

                    • Re: Document Report Distribution through Email
                      Robinson Selvaraj

                      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

                      • Re: Document Report Distribution through Email
                        Bill Britt

                        Hi,

                         

                        See if this will help.

                         

                        Bill