1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Emsg:was terminated by signal 11

Discussion in 'Oracle Forms and Reports' started by samsoft, Jul 8, 2017.

  1. samsoft

    samsoft Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    75
    when i am running oracle report which is associate with XMl output, getting below error. Please help on this this once is challenging error.

    Custom AFP Applications: Version : UNKNOWN



    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.



    XXAFPEEPWSHBOL module: XXAFP EEP BILL OF LADING

    +---------------------------------------------------------------------------


    Current system time is 26-AUG-2013 15:13:46



    +---------------------------------------------------------------------------+

    +-----------------------------

    | Starting concurrent program execution...

    +-----------------------------

    Arguments

    ------------

    P_TRIP_FROM='2880860'

    P_TRIP_TO='2880860'

    P_ITEM_DISPLAY='D'

    P_ITEM_FLEX_CODE='MSTK'

    ------------
    -- Start of Reports Command --

    ar60runb

    P_CONC_REQUEST_ID=54258105

    P_TRIP_FROM='2880860'

    P_TRIP_TO='2880860'

    P_ITEM_DISPLAY='D'

    P_ITEM_FLEX_CODE='MSTK'

    report=/lpar2_app/devl/devlappl/xxafp/11.5.0/reports/US/XXAFPEEPWSHBOL.rdf

    batch=yes

    destype=file

    desname=/lpar2_app/devl/devlcomn/admin/out/DEVL_lin60app2/o54258105.out

    desformat=XML

    -- End of Reports Command --
    Request language is :

    AMERICAN

    Request territory is :

    AMERICA

    XML_REPORTS_XENVIRONMENT is set to:

    /lpar2_app/devl/devlora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    Enabling XML_REPORTS_ENVIRONMENT based environment switching

    The Character-Set of the System is:

    US7ASCII

    Environment will now switch to UTF-8 code-set.

    Parts of this log file may not display correctly

    as a result. This is an expected behavior.

    Converting parameters to UTF-8
    -- Start of Reports Command Converted to UTF-8 --

    ar60runb

    P_CONC_REQUEST_ID=54258105

    P_TRIP_FROM='2880860'

    P_TRIP_TO='2880860'

    P_ITEM_DISPLAY='D'

    P_ITEM_FLEX_CODE='MSTK'

    report=/lpar2_app/devl/devlappl/xxafp/11.5.0/reports/US/XXAFPEEPWSHBOL.rdf

    batch=yes

    destype=file

    desname=/lpar2_app/devl/devlcomn/admin/out/DEVL_lin60app2/o54258105.out

    desformat=XML

    -- End of Reports Command --

    XML_REPORTS_XENVIRONMENT is :

    /lpar2_app/devl/devlora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    XENVIRONMENT is set to /lpar2_app/devl/devlora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    Previous NLS_LANG Environment Variable was :

    American_America.US7ASCII
    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

    American_America.UTF8
    '.,'

    stat_low = B

    stat_high = 0

    emsg:was terminated by signal 11
    Reset original NLS_LANG in environment as :

    American_America.US7ASCII

    Program was terminated by signal 11

    Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 54258105.



    Review your concurrent request log and/or report output file for more detailed information.

    +---------------------------------------------------------------------------+

    Executing request completion options...

    +------------- 1) PUBLISH -------------+

    Beginning post-processing of request 54258105 on node LIN60APP2 at 7-JUL-2017 15:13:54

    Post-processing of request 54258105 failed at 7-JUL-2017 15:13:54 with the error message:

    One or more post-processing actions failed. Consult the OPP service log for details.

    +--------------------------------------+


    Finished executing request completion options.

    +---------------------------------------------------------------------------+

    Concurrent request completed

    Current system time is 7-JUL-2017 15:13:54

    +---------------------------------------------------------------------------
     
  2. naveen.lazaus

    naveen.lazaus Active Member

    Messages:
    6
    Likes Received:
    2
    Trophy Points:
    85
    Please verify All formula columns are properly defined i means all return types according to definitions

    And

    Place exception Blocks in Formula columns.

    You have written a custom code within some trigger in the report. If this
    piece of code throws an exception and if it is not handled properly, we
    would get this Signal 11 error
     
  3. samsoft

    samsoft Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    75
    HI Naveen,
    thanks for the look into this. We have checked formula column its defined properly.
    program was working fine till the 30-june after that we are facing this issue and there were no changes.
     
  4. naveen.lazaus

    naveen.lazaus Active Member

    Messages:
    6
    Likes Received:
    2
    Trophy Points:
    85
    Yes, I will get same issues some times; i believe its only for the cause of exception. Can u check once again data flow is with out exception in all formual cols. check with debug mesaages