topic Re: Script is hanged in QlikView

Script is hanged

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

After complete execution of the script ,the script is hanged and cpu utilization reaches to maximum (100 per). What may be the reason behind the same ?

Re: Script is hanged

Anonymous — Mon, 04 Dec 2017 05:34:29 GMT

Re: Script is hanged

Anil_Babu_Samineni — Mon, 04 Dec 2017 05:38:38 GMT

Could be effect due to

1) Data volume

2) RAM is not enough with the file sizes

3) Check in Task manager how statistics are worked

4) My end up point is try to install postgre4.0 with Server statistics to check all none are the DML works?

Re: Script is hanged

Anonymous — Mon, 04 Dec 2017 05:49:33 GMT

Re: Script is hanged

Anil_Babu_Samineni — Mon, 04 Dec 2017 05:50:45 GMT

What this report indicates? Which object is that? How many dims and measures in that report?

Re: Script is hanged

ramasaisaksoft — Mon, 04 Dec 2017 06:01:25 GMT

Hi Saksham,

Case 1:-

As we faced the same issue when "Circular loop happens" in Script.

So my advise is just debug the script for 100 records and find the solution.

then check your data model.

Case 2:-

Else some times we will feel hang the script because of Stored procedure execution.

If Stored Procedure is there then it will take time to execute and get the result from the data base and it will consume RAM also as per the data retrieving from the Data base.

Hope it will solve you issue else,if possible please share your script our folks will help to you ASAP.

Re: Script is hanged

Anonymous — Mon, 04 Dec 2017 06:11:32 GMT

This report indicates sales comparison for the year 2016 and 207

dimensions are :-

1.distribution channel

2. gender

3.category

following are the expressions in the script :

There are different expressions for each year and season for eg:-

2014

2014

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

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')

These are following expressions and so on for other seasons too

Re: Script is hanged

Anil_Babu_Samineni — Mon, 04 Dec 2017 06:15:16 GMT

Till here we are in good. May be 1st point is effecting?

Can you check limitations of dimension in report? If this is straight table there is option called "Dimension Limits" so just click 1000 for a while and try with filter. Is still issue showing i may need to understand your specifications like

1) RAM Size

2) File Size

Re: Script is hanged

Anonymous — Mon, 04 Dec 2017 06:22:38 GMT

This is the error when I debug the script

Re: Script is hanged

Anonymous — Mon, 04 Dec 2017 06:24:46 GMT

Where I will find this option ?

Re: Script is hanged

ramasaisaksoft — Mon, 04 Dec 2017 06:32:26 GMT

It seems OLEDB connection issue.

Had you verified your OLEDB/ODBC connection ?

That error specifies to connect the data base issue ,as well as Retrieving table from that data base.

Try to execute only that query then you will understand easily.

please check one more time table and connection.

Re: Script is hanged

Anil_Babu_Samineni — Mon, 04 Dec 2017 06:35:11 GMT

It has to be properties - Tab called "Dimension Limits" {If this is straight object}

And Ram Size you can look on the desktop screen itself if it 2008 / 2012. And filesize check in properties or the same file with in the text box use FileSize('Path') to know the size.