Send Report PDF as Email Attachment

(0) Share

Report

Posted on by mark wilson

100

Send Report as pdf attachment

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Martin Dráb 239,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you saying that you want to send twenty thousand emails with small files, or that you want to create a huge PDF with twenty thousand records and send this file via email?

Please give us more details about the problem. Where does it get stuck? Where does locking occur and which resource is locked? We can't help you if you don't give us enough information...

Was this reply helpful? Yes No
mark wilson 100 on at

Like (0)

Report
Copy link

Link copied!

Yes , I have 20000 customer , So 20000 emails will be sent , single pdf for each customer .

It stucks on insert_recordset query , when I check session I see lck_m_sch_s this wait type , and session type suspended..

Previously I was using local buffer of temp db table , The query was sticking there when running report for pdf , I commented it out , Now it stucks at other query .

But when I run the SSRS report , it runs perfect ..

Was this reply helpful? Yes No
Martin Dráb 239,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you have a problem with your insert_recordset query, we can ignore PDF files and e-mails, because that's not related to your actual problem.

Please extract the problematic code a runnable class - removing the dependency on the report etc. will make your testing easier, and it'll allow you to share code with us.

If I understand it correctly, lck_m_sch_s is related to schema changes. Don't you have DB synchronization or index rebuild running at the same time?

Was this reply helpful? Yes No
mark wilson 100 on at

Like (0)

Report
Copy link

Link copied!

Martin , I think my insert_recordset is perfectly fine , Because when running SSRS report , It's working perfect , correct data is showing up .

If my query had issues , It would not have sent reports to 20-30 customers ..

But when I am looping through each customer , it's working fine for 20-30 customers , After that the query or connection is stucked with the details above..

Previously I was using setConnection(this.parmUserConnection) , when I was using local buffer of temp table , Now I removed the local buffer code and setConnection , It's working for only 20-30 customers , After that it gets stucked ..

And I didn't understand your statement " DB sync and index rebuild at same time " ?

I don't have indexes on tempdb table .

Was this reply helpful? Yes No
Martin Dráb 239,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You said that "It stucks on insert_recordset query". If you're now saying that your problem lies somewhere else, please give us more information about the actual problem.

Was this reply helpful? Yes No