Troubleshooting
Problem
Error ORA-12801 Error signaled in parallel query server. This error occurs when adding a calculation as follows: Variance calculation (A-B). This is successful. Add % Variance ( (A-B)/A) and the error occurs.
Resolving The Problem
ORA-12801 error signaled in parallel query server name
Cause: A parallel query server encountered an exception as described in the accompanying message(s).
Action: Correct the error described in the accompanying message.
To resolve this issue, use the method to resolve divide-by-zero errors. This will force local processing (not doing A/B or if (B<>0) then (A/B) else (0).
Calculation:(if (B<>0 then (A) else (0)) / (if (B<>0) then (B) else (1))
Historical Number
74930
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21353864