Skip to main content
Question

MS_ACCESS_JDBC memory issue.

C

I can only use JDBC for my msaccess database in the office (no ODBC or MSACCESS DRIVERS in locked machine).. trying to load ~600,000 features causes the error : java.lang.StackOverflowError eventually..

tried changing as described here: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/msaccess_jdbc/msaccess_jdbc.htm FME_JVM_MAX_HEAP_SIZE variable, re-started FME, rebooted machine, doesn't seem to do any different.. I know I'm close.. I just don't know how to make this variable setting to add more memory to Java..

2 replies

fmelizard
Safer
Forum|alt.badge.img+19
  • fmelizardSafer
  • Safer
  • March 11, 2018

We'll see if others have better advice, but I've just learned you need to set both FME_JVM_MIN_HEAP_SIZE as well as FME_JVM_MAX_HEAP_SIZE for it to take an effect.

ravenkopelman
Safer
Forum|alt.badge.img+1

Hi @cesarp, you have likely encountered a bug; if you can share the source data with us it would be very helpful. The log file from a failed read would also be valuable. We will attempt to reproduce locally (tracked by PR#82699) regardless.

As a potential workaround, try setting an environment variable to increase the the Java stack size: JAVA_TOOL_OPTIONS=-Xss4M (increasing the 4 as much as needed to make things work)

Reply


Helpful Members This Week

Community Stats

31,486
Posts
119,361
Replies
39,106
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.