Re: Parallel slave terminated with error

Hi Lok,

Sounds like your pl/sql code has removed the full error stack in an exception block and replaced it with a raise application error and a single line from the stack (with sqlerrm).

I suggest changing your code so that the stack gets reported back, or logged somewhere. You want to use dbms_utility.format_error_backtrace, or you want to just use raise (which will send the whole stack) instead of raise_application_error.

Potentially, your exception block code isn’t doing anything useful and you should just remove it and allow pl/sql to do the work of reporting back the real error for you.

Thanks,
Andy

On Fri, Jul 1, 2022 at 12:44 PM, Lok P <loknath.73_at_gmail.com> wrote:

> Hello All, We are seeing below error for one of our procedure execution
> and later the rerun completing successfully. It happened many times. The
> error says one of the parallel slave getting terminated but doesn't say
> anything about what exact Ora- error caused the parallel slave to
> terminate.
>
> We were thinking if we will get the parallel slave failure details
> automatically logged in the trace, but we didn't see anything in the trace
> file either when searched with *12801*. Any way to find the exact cause of
> this failure here?
>
> ORA-20001: ORA-12801: error signaled in parallel query server P005,
> instance db01.App1.com:App1u Error Code: -12801
>
> ORA-06512: at "APP_USER.APP1_SP", line 881
>
> ORA-06512: at line 2
>
> The line-881 in the procedure is pointing to inside 'raise application
> error', so it doesn't state the exact statement which failed, but anyway
> even if we will get the statement we need to understand what exact error is
> causing the parallel slave to get terminated.
>

--
http://www.freelists.org/webpage/oracle-l