Troubleshooting
When you configure the Maximum Page Size property to read data from a source, you might get an out of memory issue.
The issue occurs because client side pagination is enabled by default. Enable server side pagination to increase the memory.
Perform the following steps to enable server side pagination and increase the memory for the Java heap size:
- 1In Administrator, select Runtime Environments.
- 2Select the Secure Agent from the list of available Secure Agents.
- 3In the upper-right corner, click Edit.
- 4In the System Configuration Details section, select theType as DTM for the Data Integration Server.
- 5Set the value of JVMOption to -DServerSidePagination=true.
- 6Restart the Secure Agent.