Skip to Content
0
Jul 08, 2016 at 09:37 AM

fatal error: Error in the generated plan. See error trace for details

201 Views

Hi Guys

do you have an hint for me?

This query gives me the error

fatal error: Error in the generated plan. See error trace for details

here the query:

select "orpa_flg_status" , "orpb_c_part"

from "flusso_orpa" , "flusso_orpb" , "flusso_mrpa"

where "orpa_tst_doc"="orpb_tst_doc" and

"orpa_prf_doc"="orpb_prf_doc" and

"orpa_a_doc"="orpb_a_doc" and

"orpa_n_doc"="orpb_n_doc" and

"orpa_c_ditta"="orpb_c_ditta" and

"orpb_c_part"="mrpa_c_part" and

"orpb_c_ditta"="mrpa_c_ditta" and

( "mrpa_tst_doc"='PAA' or

"mrpa_tst_doc"='RAA' or

"mrpa_tst_doc"='PLE' ) and

"orpa_c_ditta"='01' and

"orpa_tst_doc"='ROA' and

"orpa_dt_ini_val" <={d '2016-07-08' } and

"orpa_dt_fin_val" >={d '2016-07-08' } and

"mrpa_c_part" >='' and

"mrpa_c_part" <= 'zzzzzzzzzz'

If I try just some clause I've no error

How can I see error trace?

Thanks in advance