Mid Server Import IssueIssue <!-- 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 { white-space:nowrap; text-align:left; border-width: 1px; border-collapse: collapse; font-size:14px; width: 85%; } table.internaltable th { border-width: 1px; padding: 5px; border-style: solid; border-color: rgb(245, 245, 245); background-color: rgb(245, 245, 245); } table.internaltable td { border-width: 1px; padding: 5px; border-style: solid; border-color: #E0E0E0; color: #000000; } .title { color: #D1232B; font-weight:normal; font-size:28px; } h1{ color: #D1232B; font-weight:normal; font-size:21px; margin-bottom:-5px } h2{ color: #646464; font-weight:bold; font-size:18px; } h3{ color: #000000; font-weight:BOLD; font-size:16px; text-decoration:underline; } h4{ color: #646464; font-weight:BOLD; font-size:15px; text-decoration:; } h5{ color: #000000; font-weight:BOLD; font-size:13px; text-decoration:; } h6{ color: #000000; font-weight:BOLD; font-size:14px; text-decoration:; } ul{ list-style: disc outside none; margin-left: 0; } li { padding-left: 1em; } --> Symptoms MID Server run into OutOfMemory error when importing data from JDBC Datasource Release All releases. Cause Depending on the query configure (or if all rows is selected), MID Server might have queried too many records which caused it to run out of memory when data is returned. Resolution MID Server can stream the records in batches to prevent it from running out of memory. This option requires 'Integration - JDBC' plugin (com.snc.integration.jdbc) activated. Follow the below steps to resolve the issue: Create a plugin activation request on HI for 'Integration - JDBC' plugin (com.snc.integration.jdbc) https://docs.servicenow.com/csh?topicname=t_RequestAPlugin.html&version=latest 2. Once Plugin is activated, goto System Import Sets > Administration > Data Sources 3. Personalize the list layout and show the column 'Jdbcprobe result set rows'. 4. Locate the JDBC Data Source that you're working on and configure the size of the result set (ex: 200) you want the integration to fetch per batch based on the following KB article: https://support.servicenow.com/kb_view.do?sysparm_article=KB0635950 5. Restart MID Server.