Loading

Database listener operation throws OutOfMemoryError when max rows is not configured

Дата публикации: Aug 1, 2025
Решение

SYMPTOM

The database connector's On Table Row(<db:listener>) source operation throws java.lang.OutOfMemoryError: Java heap space when there are millions of records in the table.

CAUSE

Database connector does not have a default value for Max Rows parameter(https://docs.mulesoft.com/db-connector/latest/database-documentation#parameters-19), connector tries to load all the rows based on fetch size and the entire heap memory can be consumed. 

SOLUTION

Profile the application execution and configure Max Rows to a appropriate value based on sizing exercise.

 

Номер статьи базы знаний

001117240

 
Загрузка
Salesforce Help | Article