Email is not going through bursting
We are trying to burst the report output to email from BI publisher, but it is not working. When I schedule to report that has the bursting query to send the output to email it does not send the email. However when I resend it from the report job output, I receive one email (I guess the other email is cached somewhere from the schedule job)
Please let me know if you came across anything like this.
SELECT DISTINCT paha.auction_header_id||'-'||pple.trading_partner_id as "KEY", (CASE WHEN pns.style_name = 'LTC Negotiation Style' THEN 'LTCTemplate' ELSE 'CommAndTransTemplate' END) TEMPLATE, 'RTF' TEMPLATE_FORMAT, 'en-US' LOCALE, 'HTML' OUTPUT_FORMAT, 'RFQ PDF Report' OUTPUT_NAME, 'EMAIL' DEL_CHANNEL, (CASE WHEN scv.email_address IS NOT NULL AND pbp.additional_contact_email IS NULL THEN scv.email_address WHEN scv.email_address IS NULL AND pbp.additional_contact_email IS NOT NULL THEN pbp.additional_contact_email WHEN scv.email_address IS NOT NULL AND pbp.additional_contact_email IS NOT NULL THEN scv.email_address||','||pbp.additional_contact_email END) PARAMETER1, pea.email_address PARAMETER2, 'Boeing Distribution