Forum Discussion
Need Help with solving ODBC - Gateway OutOfMemoryError in service
Hi Anonymous
The error is saying that it is consuming too much memory.
What I would suggest doing is to rather use an actual query to get your data, instead of what you have done above. Your code shown above does not have anything for the incremental part with the rangeStart and rangeEnd?
Hi GilbertQ ,
I have changed it to odbc query and with a simple select statement, the query loadss the preview data but with a left outer join i need to use, i get an error below.
The query I am passing is:
Should I reach out to the DB team to expose a single table/view with all the columns I needed by joining all the tables? I can then do a star schema model to separate out fact & dim tables...
Any suggestions in overcoming the error above or alternate options to proceed?
Hi Anonymous
That is an issue from the database, so I would suggest chatting to your DBA and see how they can assist with a query to get the data out as efficiently as possible.