Event Alerts Fail With APP-ALR-04110: Oracle Alert Found An Invalid Number Of Bind Variables In The SQL Statement
Last updated on JUNE 08, 2017
Applies to:Oracle Alert - Version 22.214.171.124 to 126.96.36.199 [Release 11.5]
Information in this document applies to any platform.
Periodic alerts are woking fine. After Oracle Alerts are configured using sendmail feature, but none of the event alerts seem to work.
When an event alert is triggered, no Email is send to the user. There is no entry in the /var/log/maillog file. No concurrent request being submitted too.
Tried to test the setup with, Diagnostics #3 - Event Alert. The concurrent request completes normally but no e-mail was sent.
After adding the ORG ID in the installations tab of Alert Details, the program ALR_DISTRIBUTION_LISTS (Check Event Alert) errors with:
select ... from ALR_DISTRIBUTION_LISTS where rowid=':0'
APP-ALR-04106: Please correct the user-defined SQL statement for this alert.
Steps To Reproduce:
Trigger any event alert.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms