<h2>ODBC Error Messages: Determining the Java maximum heap size</h2><br/><div style="overflow-x:auto"><article><div ><h3 >Description</h3><section><style type="text/css"><!-- div.margin{ padding: 10px 40px 40px 30px; } table.tocTable{ border: 1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); padding-top: .6em; padding-bottom: .6em; padding-left: .9em; padding-right: .6em; } table.noteTable{ border:1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); width: 100%; border-spacing:2; } table.internalTable{ border:1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); width: 100%; border-spacing:0; } .sp td{ border-bottom: 1px solid; border-right: 1px solid; border-color:#E0E0E0; background-color: #ffffff; height: 20px; padding-top: .5em; padding-bottom: .5em; padding-left: .5em; padding-right: .5em; } .sphr td{ border-right: 1px solid; border-bottom: 1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); padding-top: .5em; padding-bottom: .5em; padding-left: .5em; padding-right: .5em; height: 20px; } .title { color: #D1232B; font-weight:; font-size:25px; } .hd1{ color: #D1232B; font-weight:; font-size:18px; } .hd2{ color: #646464; font-weight:bold; font-size:16px; } .hd3{ color: #7a7a7a; font-weight:; font-size:16 px; text-decoration:; } .hd4{ color: #000000; font-weight:bold; font-size:14 px; text-decoration:; } --></style> <div class="margin"> <p class="title">ODBC Error Messages: Determining the Java maximum heap size</p> <p class="title"> </p> <span class="hd1">Symptoms</span><hr style="border-top-width: 1px; border-top-style: solid; border-top-color: #cccccc;" /> <ul><li>query resulted in data sizes that exceed the Java maximum </li><li>query timed out while processing<br /><span style="font-size: 10pt;"> </span></li></ul> <span class="hd1">Cause</span><hr style="border-top-width: 1px; border-top-style: solid; border-top-color: #cccccc;" />If you receive an out of memory error message indicating that the Java heap size maximum should be increased, the query you issued likely resulted in an intial response that exceeded the Java maximum heap size.</div> <div class="margin"><span class="hd1">Resolution</span><hr style="border-top-width: 1px; border-top-style: solid; border-top-color: #cccccc;" />If you receive the following error message when running an ODBC query, <em><strong>[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]OutOfMemoryError:</strong> <strong>Java heap space. Your current maximum heap size is set at 150MB. Please set it at 300MB and try again.</strong></em>, the query you have issued resulted in an initial response that exceeded the default Java maximum heap size. Try increasing the default Java maximum heap size.<strong> </strong></div> <div class="margin">To increase the size to the value recommended by the error message: <ol><li><span style="font-size: 10pt;">Go to the Management Console and navigate to </span><strong style="font-size: 10pt;">Services > Service Settings > IP Parameters</strong>.<span style="font-size: 10pt;"> </span></li><li><span style="font-size: 10pt;">Set the value of </span><strong style="font-size: 10pt;">ServiceJVMOptions</strong><span style="font-size: 10pt;"> to </span><strong style="font-size: 10pt;">-Xms64m -Xmx300m</strong><span style="font-size: 10pt;">.</span><span style="font-size: 10pt;"> </span></li></ol> For more information on how to change this value, see <a title="Configuring the ODBC Driver" href="https://docs.servicenow.com/csh?topicname=configuring-odbc.html&version=latest" target="_blank" rel="noopener noreferrer nofollow"><span style="color: #0000ff;"><span style="text-decoration: underline;">Configuring the ODBC Driver</span></span></a> in the ServiceNow product documentation.</div></section></div></article></div>