Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Using Data Studio V4.1.1 receiving a Java Heap error.
732 views
Skip to first unread message
livelo...@gmail.com
Nov 9, 2016, 6:54:17 PM11/9/16
to
I am running a simple select and I am receiving a Java heap space internal error.
I am just selecting fields from a table, there is nothing complicated about the SQL statement. I do not know where to turn to get help.
I am just selecting fields from a table, there is nothing complicated about the SQL statement. I do not know where to turn to get help.
Ian
Nov 10, 2016, 7:22:59 PM11/10/16
to
On Wednesday, November 9, 2016 at 4:54:17 PM UTC-7, livelo...@gmail.com wrote:
> I am running a simple select and I am receiving a Java heap space internal error.
>
> I am just selecting fields from a table, there is nothing complicated about the SQL statement. I do not know where to turn to get help.
How many rows are returned by the SQL statement?
> I am running a simple select and I am receiving a Java heap space internal error.
>
> I am just selecting fields from a table, there is nothing complicated about the SQL statement. I do not know where to turn to get help.
In Data Studio preferences, under Data Management > SQL Development > SQL Results View Options, what do you have for "Max row count" and "Max display row count" ? The larger these are (and depending on number of rows actually returned by your query) you can exhaust memory.
You can either set these settings to a "reasonable" value (I think the default is 500), or you can limiting the number of rows returned by your query by adding "FETCH FIRST x ROWS ONLY" to the end of your SQL statement (where x is a reasonable number like 100 or 500).
0 new messages