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 25

Discussion in 'Oracle Apps Technical' started by jagadekara, Aug 4, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    My report Completed error. The following error came in log file.

    stat_low = 19
    stat_high = 0
    emsg:was terminated by signal 25

    So What is the solution for this?
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks CJ,

    But i didn't find the solution.

    I don't have any parameters in my program. I need full output even though it has huge output.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    If the signal 25 is indeed referring to a limitation of the output size (2GB) then the huge output is the problem. Thus the full output desired is not an option under the current environment w/o rethinking the solution.

    One of the suggestions noted was to break the data into smaller pieces. Or, you might change the process from a report to a PL/SQL process that creates a file and streams to it...but again...the amount of data you're dealing with would seem to be the primary issue.
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Yes,

    My report has huge amount of data 1050000 records.
    But we need those data in single report which is in excel out put.
     
  6. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi,

    I wonder how we can realistically make use of an Excel document with over 1M lines ... it would take an eternity to open the document first of all. You are hitting the limits of Microsoft Excel and I would go with CJ's solution and try to find a way or criteria to split the report into manageable size and at the same time may be overcome these technical constraints.
     
  7. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Of course,
    It is right. But my client told me that check are you able to display 1050000 records in excel or not.

    I am using MS Office 2007. Here excel maximum lines are 1048576

    So I am checking that my query returning 1050000 records, first sheet should show 1048576 and remaining 1424 records should display in second sheet of same excel book.

    So Is it possible?