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.

 

Knowledge 기사 번호

001117240

 
로드 중
Salesforce Help | Article