Periodic Alert Completed With Error: ORA-01460

(Doc ID 1378726.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Alert - Version to [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 25-Apr-2013***


Periodic alert errors out. Error message is:

ALECDC module: Check Periodic Alert
APP-ALR-04102: Internal SQL error occurred. (ROUTINE=alssmn_wf_jmailer) (FILE=alr/lib/alssmn.c) (LINE=1415)
APP-ALR-04131: Cannot send mail (system failed) (ROUTINE=alssmn_wf_jmailer) (FILE=alr/lib/alssmn.c) (LINE=1429)
APP-ALR-04124: Oracle Alert was unable to deliver your message (ROUTINE=alssmn_email) (FILE=alr/lib/alssmn.c) (LINE=428)

but the actual error is:

SQL error ORA-01460: unimplemented or unreasonable conversion requested occurred while performing the following: ALR/WF - Call our send routine (STMT=begin ALR_MLR_PACKAGE.SEND2(:0, :1, :2, :3, :4, :5); end;


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