Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error while opening straight table.


Hi,

I have one qvw in live folder with size 213MB when I am opening straight table it is showing below error.

Cpuld anyone ket me know what it means and how can I solve this please help me.

Thanks.

Labels (1)
13 Replies
datanibbler
Champion
Champion

Hi kavitakadli,

reducing input data is easy to say - usually when you build a QlikView_app, you are supposed to show all of the data.

Still, you have a point - there are often fields which are not needed (in which case there is a "document_analyzer" that will tell about fields not used on the UI - and you might be able to filter for only a certain timerange - the latter possibility depends on the users' wishes...

Another point you could try: You say there are calculated dimensions - those are resource-heavy. Try to think of a way you can calculate these dimensions in the script so that on the UI you can access them as regular fields.

Not applicable
Author

Hi DataNibbler,

Reducing data size--> was a suggestion to test whether the error goes off after doing that. So that we can be sure that its memory problem. Then we can request for upgrading machine hardware to process huge data.

Everybody in the world knows that we need to use all input data according to user requirement in the application.

datanibbler
Champion
Champion

Hi kavitakadli,

I wouldn't be so sure about everybody knowing that - but I didn't mean to cross you. Sorry!

Of course it is a good way to test whether the code in itself works.

(Amelia, just in case, just prefix your LOAD statement with a FIRST XX statement (where XX is a number))

Anonymous
Not applicable
Author

Amelia

Have you tried running Rob Wunderlich 's  Document Analyzer V1.15 against your qvw ?

It is a great way of identifying what in your qvw is consuming what RAM.  Then when you know the cause of the issue defining the solution is a lot easier.

Best Regards,     Bill