Loading

Database listener operation throws OutOfMemoryError when max rows is not configured

Veröffentlichungsdatum: Aug 1, 2025
Lösung

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.

 

Nummer des Knowledge-Artikels

001117240

 
Laden
Salesforce Help | Article