0015618: Create new alert rule and do the appropriate setup to send/receive email when alert is triggered but no email is sent/received

Description

Reported by TDS

I created a new alert rule and added the following sql:
select trigger_name as referencekey_id,
       null as record_id,
       '2701' as ad_role_id,
       '92161F56AA0F0877E040290A548868A7' as ad_user_id,
       'Constraint '||trigger_name||' on table '||table_name||' is not enabled' as description,
       'Y' as isActive,
        0 as ad_org_id,
        '1969' as ad_client_id,
        now() as created,
        0 as createdBy,
        now() as updated,
        0 as updatedBy
from user_triggers
where status!='ENABLED'

I added an alert recipient, selected a role and uwser, made it active and check send email.

On the user, I made sure the email address is correct. On the client I set up the mail host, request email, request user and request user password. The mail host is an smtp server working on port 25 and the email accounts are all authorized mail accounts on the server.

The alert rule sql returns the following:
OPENBRAVO@ipvdev10> select trigger_name as referencekey_id,
  2 null as record_id,
  3 '2701' as ad_role_id,
  4 '92161F56AA0F0877E040290A548868A7' as ad_user_id,
  5 'Constraint '||trigger_name||' on table '||table_name||' is not enabled' as description,
  6 'Y' as isActive,
  7 0 as ad_org_id,
  8 '1969' as ad_client_id,
  9 now() as created,
10 0 as createdBy,
11 now() as updated,
12 0 as updatedBy
13 from user_triggers
14 where status!='ENABLED'
15 /

REFERENCEKEY_ID R AD_R AD_USER_ID DESCRIPTION
------------------------------ - ---- -------------------------------- ----------------------------------------------------------------------------------
AD_ACCOUNTINGRPT_ELEMENT_TRG 2701 92161F56AA0F0877E040290A548868A7 Constraint AD_ACCOUNTINGRPT_ELEMENT_TRG on table

1 row selected.

Tags

No tags attached.

Attached Files

saicalertissue.docx [^] (579,722 bytes) 2011-01-11 18:31

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0033816) alostale (manager) 2011-01-24 08:55	Thank you for your proposal. As this alert only works in Oracle and not in PostgreSQL I would not include it in core product. On the other hand, as it is a useful alert, I propose you to package within a module so it can be installed in Oracle instances.

Issue History
Date Modified	Username	Field	Change
2011-01-11 18:31	sperreault	New Issue
2011-01-11 18:31	sperreault	Assigned To	=> alostale
2011-01-11 18:31	sperreault	File Added: saicalertissue.docx
2011-01-11 18:31	sperreault	Modules	=> Core
2011-01-24 08:53	alostale	Type	defect => feature request
2011-01-24 08:55	alostale	Note Added: 0033816
2011-01-24 08:55	alostale	Status	new => closed
2011-01-24 08:55	alostale	Resolution	open => no change required
2011-01-25 00:00	anonymous	sf_bug_id	0 => 3165013