Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Script Excecution Freeze ?

Hi All,

Here i am trying to update application with new set of QVDs. Script execution works fine, if i limit the load for 2 million records by using debug wizard. When i applied full data reload script Execution freezes at one particular table and at particular record point as shown in below pic. can any one help me how to overcome this issue. PFA Image.

Note: I checked Keep progress open after reload form user preferences

                                             and

        i checked log-file option in document settings .

Cheers,

Ganesh.

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Does the freeze occur at the end of the script? How long does it freeze? What is the ram usage of the machine at the time of the freeze? Can you post the script?


talk is cheap, supply exceeds demand
Highlighted
Creator III
Creator III

Hi Gysbert,

Thanks for the replay.

Here Freeze occurs in the middle of  the script, As i mentioned in screen shot it stops at temp_Days_Worked table. Here freeze means it is not showing any process running, i waited for 20 mins but process is at same place where it is before, i have gone through the RAM usage it is 4.5 GB at that time . I am using task manager to come out from this loop.

Cheers,

Ganesh.

Highlighted
MVP & Luminary
MVP & Luminary

Perhaps you simply have to have a little more patience than 20 minutes. But you could also be doing something in the script that could be done in a less costly way. Can you post the script? And how much RAM is still available (free) at that time?


talk is cheap, supply exceeds demand
Highlighted
Creator III
Creator III

hi ,

FYI my QVD size is 687,896 KB

Highlighted
MVP & Luminary
MVP & Luminary

Well, you're creating a lot of temporary tables to create new fields and then join that table to the original source table. That is expensive in terms of calculation time and memory usages. You should try to create these fields in preceding loads. If that's not possible you'll simply have to accept the calculation time penalty. Ram usage doesn't seem to be a problem on your machine.


talk is cheap, supply exceeds demand
Highlighted
Creator III
Creator III

Hi Gysbert,

I found the problem where the script freezes. On the script i am using subfield function in nested if clause to perform transformations.  Here subfield function won't work for large data sets. if i use Distinct keyword in front of date field it works fine.

Cheers,

Ganesh.