This discussion is archived
4 Replies Latest reply: Aug 7, 2013 10:55 AM by de45e462-4cf1-4ad2-8f0b-4688375a6400 RSS

Where to locate a core dump file

Brendan Oracle ACE Director
Currently Being Moderated
I'm getting the following error message when I run a workflow. Where can I find the core dump file ?
Message:
Workflow failed due to unexpected failure in the following nodes, please review if there were any core dumps generated: OUTPUT_2_7.
  • 1. Re: Where to locate a core dump file
    Mark Kelly Oracle ACE
    Currently Being Moderated
    Hi Brendan,
    There are a couple of known issues with persisting the data coming from an Apply node.
    It varies depending on what db you are running.
    Is that what the create table node is persisting?
    What db version are you using?
    What are the output columns that you are persisting?
    If is it the failure that I think it is, you will need to upgrade your db to resolve the issue, or remove some of the apply output columns that are triggering the failure.

    I can give some pointers on how to access your alert log and the trace files.
    If you search the alert log for the logs written at the time of the failure, you will see a trace file name generated and perhaps a incident directory to store it in.
    You can then edit the trace file and it will often show you what sql generated the failure.
    In your case, it should be the create table sql.

    To find the location of the dump/trace files and alert log, execute the following as sys in either sql plus or sql worksheet:

    select * from v$diag_info

    Thanks, Mark
  • 2. Re: Where to locate a core dump file
    Brendan Oracle ACE Director
    Currently Being Moderated
    Thanks Mark

    I'll have a look at your suggestions.

    A workaround is that instead of creating a table for the APPLY process output, I create a view and the process works.

    I'm generating columns for all the 4 classification algorithms. DB is 11.2.0.1.0
  • 3. Re: Where to locate a core dump file
    Mark Kelly Oracle ACE
    Currently Being Moderated
    Ok. That would hit the bug.
    The following apply output columns do not persist in 11.2.0.1:
    GLM:
    1) Function: Prediction Bounds Lower
    Param: Confidence (%): 95.0, Target: <Most Likely>
    2) Function: Prediction Bounds Upper
    Param: Confidence (%): 95.0, Target: <Most Likely>
    SVM
    3) Function: Prediction Probability
    Param: Target: <Most Likely>

    The fix is obtained by upgrading your db to 11.2.0.2 or above.
    Thanks, Mark
  • 4. Re: Where to locate a core dump file
    de45e462-4cf1-4ad2-8f0b-4688375a6400 Newbie
    Currently Being Moderated

    Hi Mark,

     

    Which table contains this information in the Oracle data miner.

    Appreciate your help.

     

    Thanks,

    HS

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points