Hi Team,
We have a Job : MER_EML_GENERIC that is getting aborted very frequently with error :
ERROR at line 1:
ORA-20105: error executing send_email proc.
ORA-06512: at line 40
no output from MER_EML_GENERIC
exiting sqlp Fri May 17 12:27:17 CDT 2019
*****************************
* Finished on Fri May 17 12:27:17 CDT 2019 with status ABORTD (ABORTD)
The Log file of MER_EML_GENERIC job will be as:
$ more o45685122.00
Body Started at Fri May 17 12:27:15 CDT 2019
FILEID:52594153
Process Id is 19577 on Fri May 17 12:27:15 CDT 2019
===== JOB INFORMATION ==============================================
Operator/Agent DALX73P
Queue MERCURY
batch_home /home/appwrx1p
jobid 45685122.00
output /home/appwrx1p/out
file b.45685122.00
max run time 2400
min run time 0
===== GENERAL INFORMATION ==========================================
module MER_EML_GENERIC
job_number 4169
chain_id
application MERCURY
source AWSQLP
app_path /home/appwrx1p
command_dir /sql
program /home/appwrx1p/sql/mer_eml
===== OUTPUT INFORMATION ===========================================
user appwrx1p
printer TEST
copies 1
function STORE
output req N
log run Y
===== LOGIN INFORMATION ============================================
dbtype ORACLE
login mercury
netconnect @ccprod
dbtype2 ORACLE
db_login2
net_connect2
sid
End of parameter file
job pid 19577
starting sqlp Fri May 17 12:27:15 CDT 2019
sqlplus -s @/home/appwrx1p/sql/mer_eml A63366602.lis
Testing DB connect
Declare
*
ERROR at line 1:
ORA-20105: error executing send_email proc.
ORA-06512: at line 40
no output from MER_EML_GENERIC
exiting sqlp Fri May 17 12:27:17 CDT 2019
*****************************
* Finished on Fri May 17 12:27:17 CDT 2019 with status ABORTD (ABORTD)
*****************************
Results from command:PRINTSIZE -j 45685122.00 -n /home/appwrx1p/out/o45685122.00
-d /home/appwrx1p/out
Fri May 17 12:27:17 CDT 2019 Done with BODY
Kindly assist in getting this issue resolved on priority.
Regards,
Mohd Zain Akbar