topic Re: after running the script the script is executed completed but my application is not responding in QlikView

after running the script the script is executed completed but my application is not responding

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

The script is not responding despite of complete execution and the application is hanging what may be the reason

Re: after running the script the script is executed completed but my application is not responding

tresB — Wed, 22 Nov 2017 04:49:07 GMT

Could you post a screen shot of your issue?

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 05:06:17 GMT

This application is not responding

Re: after running the script the script is executed completed but my application is not responding

jonathandienst — Wed, 22 Nov 2017 05:13:54 GMT

Hard to say - here are some ideas:

Complex calculation(s) with use of expensive calculation constructs like sum(if()) or aggr().

Expressions that span large tables that are incorrectly associated or not associated at all

Complex and unwanted synthetic key(s)

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 05:23:01 GMT

Hi Saksham,

As Jon suggested one there could be couple of reasons.

1. Huge amount of data

2. Complex calculations

3. Bad data model

Also i would recommend you to check your RAM utilization at the same time, if it is reaching its limits then you have find a solution to optimize it.

Also i can see some tables on the load page, tables take more ram while loading. Try to create a welcome page with no charts on it and then do the load again.

Br,

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 06:08:16 GMT

Please can you provide with the solution for the same?

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 06:11:10 GMT

Hi,

Please provide the below information:

1. qvw size

2. Amount of data loaded

3. Data model snapshot

4. Expression and dimension used in the tables

It is very difficult to identify the root cause with out seeing the actual qvw

Br,

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 06:22:58 GMT

data modelqvw size expression and dimensions

2016

=num(

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value]))/Sales_INR_Unit,

'#,##0.0') and so on.....

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 06:36:14 GMT

Hi,

Issue seems to be your expressions. Try to avoid sum(if( expressions.

Use set analysis.

Br,

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 06:43:05 GMT

so how to covert this into proper set analysis expression?

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 06:44:10 GMT

Try like this:

Create two variable:

vPrevYrMonthTo = MakeDate(Prev_Year,month(To),day(To))

vPrevYrMonthFrom = MakeDate(Prev_Year,month(From),day(From))

Exp:

Num(Sum({<Sold_Date={‘<=$( vPrevYrMonthTo )’}, Sold_Date={‘>=$( vPrevYrMonthFrom )’}>[inv value])/sum(Sales_INR_Unit),’#,##0.0')

Disable other expression and see if the charts are responding, if it works modify other expressions also

Br,

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 07:05:59 GMT

This expression is giving an error

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 07:23:03 GMT

Num(Sum({<Sold_Date={"<=$(=vPrevYrMonthTo) >=$(=vPrevYrMonthFrom )”}>}[inv value])/sum(Sales_INR_Unit),’#,##0.0')

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 07:36:24 GMT

2014 season

num(

sum(

if(

Sold_Date <=

MakeDate(

Prev_Year,

month(

To),

day(

To))

and

Sold_Date >=

MakeDate(

Prev_Year,

month(

From),

day(

From))

and

[Season Code] =

$(vSales_Summary_Previous_Season),

[inv value]))/

Sales_INR_Unit,
'#,##0.0')

Hoe to convert this?

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 07:38:18 GMT

total

=num(
(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)), [inv value]))
-
sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])))
/
sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value])),
'#,##0%')
total season

=num(
(sum(if(Sold_Date <= MakeDate(Curr_Year,month(To),day(To)) and Sold_Date >= MakeDate(Curr_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Current_Season), [inv value]))
-
sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])))
/
sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value])),
'#,##0%')

For this expression also

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 08:30:16 GMT

Did the issue got fixed after updating the expression ?

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 08:32:48 GMT

Num(Sum({<Sold_Date={"<=$(=vPrevYrMonthTo) >=$(=vPrevYrMonthFrom )”}, [Season Code] ={“$(=vSales_Summary_Previous_Season)”}>}[inv value])/ Sales_INR_Unit,’#,##0.0')

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 09:02:36 GMT

again its giving an error

Re: after running the script the script is executed completed but my application is not responding

Anonymous — Wed, 22 Nov 2017 09:10:13 GMT

Order data

Orders:
LOAD
[0SOLD_TO:0SOLD_TO] as SAPCode_Order,
[0MATERIAL:0MATERIAL]&[0AF_COLOR:0AF_COLOR]&[0AF_SIZE:0AF_SIZE] as itemnumber,
left([0MATERIAL:0MATERIAL],3) as [Season Code],
[0CONF_QTY:0CONF_QTY] as quantity_order,
[Z_MRP_INR:Z_MRP_INR] as Sales_price_order,
([Z_WSP_INR:Z_WSP_INR]/[0CONF_QTY:0CONF_QTY]) as WS_price
FROM

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

SAPCode_Orders:
Mapping LOAD
@2 as SAP_Trans_code,
@3 as SAPCode_Order
FROM

(txt, codepage is 1252, no labels, delimiter is '|', msq);

Material_Orders:
Mapping Load
@2&'N'&@3 as Material_Trans_code,
trim(@7) as Material
FROM

(txt, codepage is 1252, no labels, delimiter is '|', msq);

SAP_LEVEL:
LOAD @2 as SAP_Trans_code,
@2&'N'&@3 as Material_Trans_code,
@7 as Color_Size,
@12 as quantity_order,
@15/@12 as WS_Price
FROM

(txt, codepage is 1252, no labels, delimiter is '|', msq)
where @6='';

SAP_LEVEL_Final:
Concatenate(Orders)
Load
ApplyMap('SAPCode_Orders',SAP_Trans_code,'-') as SAPCode_Order,
ApplyMap('Material_Orders',Material_Trans_code,'-')&Color_Size as itemnumber,
Left(ApplyMap('Material_Orders',Material_Trans_code,'-'),3) as [Season Code],
applymap('MRP_temp',ApplyMap('Material_Orders',Material_Trans_code,'-')&Color_Size,'-')*quantity_order as Sales_price_order,
quantity_order,
WS_Price
Resident SAP_LEVEL;

drop table SAP_LEVEL;

Temporary:
mapping LOAD SAPCode as SAPCode_Order,
ETPCode
Resident Store_Mapping ;

Orders_temp:
load SAPCode_Order,
[Season Code],
itemnumber,
quantity_order,
Sales_price_order,
WS_price,
applymap('Temporary',SAPCode_Order,'Others') as ETPCode
resident Orders;

drop table Orders;

Orders_temp2:
left keep (Temp)
load
*
resident Orders_temp;

drop table Orders_temp;

Orders_data:
//Concatenate(POS_Master)
load
SAPCode_Order,
[Season Code],
itemnumber,
quantity_order,
Sales_price_order,
ETPCode
resident Orders_temp2;

Pos_Master_temp:
load *,
itemnumber&ETPCode as Key
resident Orders_data;

WS_Mapping:
mapping load itemnumber&ETPCode as Key,
WS_price
resident Orders_temp2;

POS_Master_final:
load *,
applymap('WS_Mapping',Key,'-') as WS_Cost
resident Pos_Master_temp;

//drop table POS_Master;
drop table Orders_data;
drop table Pos_Master_temp;

drop table Orders_temp2;

this above script is executed before incremetal load

Re: after running the script the script is executed completed but my application is not responding

jyothish8807 — Wed, 22 Nov 2017 09:16:03 GMT

Num(Sum({<Sold_Date={"<=$(=vPrevYrMonthTo) >=$(=vPrevYrMonthFrom )”}, [Season Code] ={“$(=vSales_Summary_Previous_Season)”}>}[inv value])/$(Sales_INR_Unit),’#,##0.0')