Automic Community

Expand all | Collapse all

A Job MER_EML_GENERIC is getting Aborted very frequently

  • 1.  A Job MER_EML_GENERIC is getting Aborted very frequently

    Posted 05-20-2019 05:55 PM

    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



  • 2.  Re: A Job MER_EML_GENERIC is getting Aborted very frequently

    Posted 05-21-2019 06:28 AM

    This ist an oracle error (ORA-...). Do you want to send an email out of Oracle?

    You shoult look into line 40 of you sql script.

    Regards, Nicole