Publication Failing w/ %SI_EMAIL_ADDRESS%

I have a publication that is using Crystal Reports as Dynamic Recipients.
When testing I used my email address as the destination the report was split out properly and my email was sent multiple reports split out by Care Manager and Members.

When I replace my email in destination to %SI_EMAIL_ADDRESS%

I get the following Errors:

BusinessObjects_PublicationAdminErrorLog_Instance_716522 - [Publication ID # 716522] - An exception was caught while fetching dynamic recipients data. Did you properly configure your publication? (FBE60311)
2016-05-04 10:27:29,690 ERROR [PublishingService:RunInstancePool-61] BusinessObjects_PublicationAdminErrorLog_Instance_716522 - [Publication ID # 716522] - An exception was caught while fetching dynamic recipients data. Did you properly configure your publication? (FBE60311)
2016-05-04 10:27:29,690 ERROR [PublishingService:RunInstancePool-61] BusinessObjects_PublicationAdminErrorLog_Instance_716522 - [Publication ID # 716522] - An exception was caught while scheduling the publication. (FBE60203)


p_b_bradley :ireland: (BOB member since 2006-03-15)

I figured this out - in my report I map emails based on a field in the report.
I build a function in Crystal that states
if field.signature = ’ p_b_bradley’ then ‘email_address@email.email’

the error comes when there is a signature that is populated in the result set but is not accounted for in the function. so when running the publication it has no destination for that signature.


p_b_bradley :ireland: (BOB member since 2006-03-15)