on 04-10-2013 12:46 AM
Hello,
I'm using Hana studio and I'm trying to do a Calculation View.
That View consist of 2 calculation view and when I run the query (SELECT)
of the view, the memory of hana starting get over and the hana studio
send me an error of memory.
This is the error.
I don't know Why is it happen that?
how can I resolve it?
Can any one help me with the problem?
regards
Hi Rafael,
To process a query, data base may need a certain volume of memory.
These memory could be used as building some intermediate results or some other internal structures, such as hash tables.
The error you mentioned happens when the system do not have enough memory for processing the query.
One of easiest workaround is to run the query on a machine with more memory installed.
Another handy way is restart DB and run the query.
In this way, only tables related to this query will be loaded into memory.
So your budget for processing this query will be larger.
If nothing works, there might something go crazy inside of the query, maybe an engine bug or a model bug.
Best Wishes,
Wu Di
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rafael,
Your posted your problem but without the SQL and what is behind your calculation we can't help you.
Just a guess, check if you are joining tables without link all proper key fields. This can lead to this behavior with a cartesian resultset.
Regards, Fernando Da Rós
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.