OBIEE 10g: emails from Delivers not working reliably. Can't send an email to some users (Doc ID 747892.1)

APPLIES TO:

Business Intelligence Applications Consumer - Version: 7.9.5 [AA 1900] - Release: V7
Information in this document applies to any platform.

SYMPTOMS

When generating the recipient list from a conditional request, all emails are correctly sent. When manually selecting recipients from list of users, some don't work.

CAUSE

The SA_System has userids in uppercase but the ibot might be looking for lowercase userids and hence not finding any records to fetch the email address

SOLUTION

Adding,

<UpperCaseRecipientNames>true</UpperCaseRecipientNames>

to the <Alerts> </Alerts> section in the instanceconfig.xml file resolves the issue.

Ensure to restart presentation services after the above mentioned change before testing the ibots.