Periodic Alert Completed With Error: ORA-01460 (Doc ID 1378726.1)

Last updated on JUNE 30, 2017

Applies to:

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

Symptoms

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;

Cause

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