Email attachment - corrupt random pdfs

(0) Share

Report

Posted on by ShanAbeywicrema

948

Hi All,

I am sending invoices as Pdf. I am using following code. It is sending selected invoices. But if I send 10 invoices 2 or 3 invoices get corrupted. But corrupted pdf can open from FoxitReader, not from Acrobat.

But if I send only identified corrupted pdf , it works fine.

Is there any problem with this code?

 if SalesInvoiceHdr.FindFirst() then
  repeat
    clear(outStreamReport);
    clear(inStreamReport);
    clear(RecRef);
    clear(emailMsg);
    SalesInvHdr.Reset();
    SalesInvHdr.SetRange("No.", SalesInvoiceHdr."No.");
    if SalesInvHdr.FindFirst() then
        RecRef.GetTable(SalesInvHdr);
    TempBlob.CreateOutStream(outStreamReport);
    TempBlob.CreateInStream(inStreamReport);
    body := '';
    emailMsg.Create(SalesInvoiceHdr."Sell-to E-Mail", 'Your invoice '   SalesInvHdr."No."   ' has been processed', body, true);
    Report.SaveAs(Report::"Posted Proforma Invoice", '', format::Pdf, outStreamReport, recRef);

    //txtB64 := cnv64.ToBase64(inStreamReport);
    emailMsg.AddAttachment('Sales Invoice '   SalesInvHdr."No."   '.pdf', 'pdf', inStreamReport);
    email.Send(emailMsg);

  until SalesInvoiceHdr.Next() = 0;

Thank you,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

Try to use below link for attachment

emailMsg.AddAttachment('Sales Invoice ' + SalesInvHdr."No." + '.pdf', 'application/pdf', inStreamReport);

Was this reply helpful? Yes No
ShanAbeywicrema 948 on at

Like (0)

Report

Hello Nitin,

Thank you. I was using this. It does not solved the problem. I then I moved to this method. Problem is when I resend same invoice individual it is working. when send selected list, this happens. Again it is only for acrobat reader, it works for other readers.

When I try pdf repair tool. I got following errors

rrors:

3-Heights(TM) PDF repair tool, evaluation license valid until unbounded

Open file.

Analyze Objects.

0x80410301 - E - The object number is missing.

- Object No.: 3

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 4

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 5

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 6

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 7

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 8

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 9

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 10

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 11

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 12

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 13

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410301 - E - The object number is missing.

- Object No.: 14

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

0x80410302 - E - The generation number is missing.

- Object No.: 15

- File: Sales Invoice INV100552.pdf

0x00418309 - W - The offset in the xref table is not correct.

- File: Sales Invoice INV100552.pdf

Analyze Outlines.

Analyze Pages.

0x80410402 - E - The page or page tree node has a missing or invalid "Type" key.

- Object No.: 8

- File: Sales Invoice INV100552.pdf

0x80410113 - E - The file is corrupt and cannot be repaired. Some of the contents can possibly be recovered.

- File: Sales Invoice INV100552.pdf

Close file.

Was this reply helpful? Yes No
G_ABC 2 on at

Like (0)

Report

Hi,

Have you been able to resolve this issue? I am facing the exact same issue.

KR

Was this reply helpful? Yes No
Community member 6 on at

Like (0)

Report

Also having this issue. I am exporting 1-20 invoices as .pdf into a zip file. Some open, some get error 109 but are able to be opened without issue in other reader applications. Any resolution?

Thank you.

Was this reply helpful? Yes No
Jaakko Y. 4 on at

Like (0)

Report

Hi,

I would also be interested in hearing about the resolution as we are also facing the same issue. :)

Br, Jaakko

Was this reply helpful? Yes No
Suggested answer

Kamal Khakhkhar 1,274 on at

Like (0)

Report

Hii There,

as per your requirement you can go through as per below Video. Follow the steps as per mentioned.

https://youtu.be/niZrNBggpDs?si=ZRjPuqtqEbkUkAG0

IF you found helpfull , Mark it Answered.

Thank You,

Kamal Khakhkhar

Was this reply helpful? Yes No
Suggested answer

Jaakko Y. 4 on at

Like (0)

Report
Hi,

In our case, the problem was solved by moving the sending of the emails into a separate function.

For example, in the original problem, move the below code into a separate function:

TempBlob.CreateOutStream(outStreamReport); TempBlob.CreateInStream(inStreamReport); body := ''; emailMsg.Create(SalesInvoiceHdr."Sell-to E-Mail", 'Your invoice ' SalesInvHdr."No." ' has been processed', body, true); Report.SaveAs(Report::"Posted Proforma Invoice", '', format::Pdf, outStreamReport, recRef); //txtB64 := cnv64.ToBase64(inStreamReport); emailMsg.AddAttachment('Sales Invoice ' SalesInvHdr."No." '.pdf', 'pdf', inStreamReport); email.Send(emailMsg);

-Jaakko

Was this reply helpful? Yes No

Join the conversation

Community site session details

Email attachment - corrupt random pdfs

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Email attachment - corrupt random pdfs

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates