Execution Faild

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

I have given below script , but i reload this come to error massage " Execution script failed Reload old data" to qlick view. but in this script working properly the sql data base.

please help

sagara

SELECT

tra_branch,

PRODUCT,

TRUNC(tra_pol_date),

pri_class_code,

POLICY_NO,

MECODE,

SUM(RIFUND_PREMIUM) RIFUND_PREMIUM,SUM(RIFUND_COMM)RIFUND_COMM

FROM

(select tra_currency,CLASS,POLICY_NO, MONTH,YEAR,tra_pol_date, tra_branch,PRODUCT,pri_class_code,MECODE,

sum(RIFUND_PREMIUM) RIFUND_PREMIUM, sum(RIFUND_COMM) RIFUND_COMM

from

(SELECT tra_currency,tra_class_code CLASS,TRA_POLICY_NO POLICY_NO ,

( SELECT n.RPO_DDC_SEQ FROM uw_t_ri_policies@ri n where n.rpo_pol_seq_no=a.tra_policy_seq ) deb_rec,

to_char(tra_pol_date, 'MM') MONTH,

to_char(tra_pol_date, 'YYYY') YEAR,

tra_branch,

tra_pol_date,

pri_class_code,

tra_prod_code PRODUCT,

(select c.rpo_pol_marketing_executive_co from uw_t_ri_policies@ri c where C.rpo_pol_seq_no=a.tra_policy_seq )MECODE,

b.PRI_RI_PREMIUM*TRA_CUR_CON_RATE RIFUND_PREMIUM,

b.pri_ri_comm*TRA_CUR_CON_RATE RIFUND_COMM

FROM ri_t_polcy_trans a, ri_t_polcy_trans_rein b

where a.tra_trans_seq=b.pri_trans_seq and a.tra_step_no=b.pri_step_no(+)

and to_char(tra_pol_date,'YYYY')='2017'

//BETWEEN '2014-01' AND '2014-08'

and b.pri_reinsurer_code in ('RI FUND','RIFUND','MIFUND')

AND tra_branch like 'CO%'

)

group by tra_currency,YEAR, MONTH,CLASS,PRODUCT,POLICY_NO,tra_branch,tra_pol_date,pri_class_code,deb_rec,MECODE)

group by YEAR,POLICY_NO,tra_pol_date,tra_branch,PRODUCT,pri_class_code,MECODE

Re: Execution Faild

prma7799 — Fri, 22 Dec 2017 05:39:35 GMT

Please check this

https://community.qlikview.com/thread/34403

Re: Execution Faild

Anil_Babu_Samineni — Fri, 22 Dec 2017 05:57:12 GMT

Is that Query running in SQL engine not Qlikview?

Re: Execution Faild

sushil353 — Fri, 22 Dec 2017 06:03:39 GMT

Hi,

Try Following things:

if you are saving any qvd using this script then ensure that you have access to create the qvd in specified folder and also check if you are going to replace the qvd then if that qvd is used in other program.

topic Re: Execution Faild in QlikView

Execution Faild

Re: Execution Faild

Re: Execution Faild

Re: Execution Faild