Google Cloud Spanner Connector > Mapping tasks with Google Cloud Spanner > Troubleshooting a mapping task

Troubleshooting a mapping task

"ERROR java.lang.OutOfMemoryError: GC overhead limit exceeded." occurs when you read large number of records and the mapping task runs for a long period.
To resolve this issue, perform the following tasks to configure the JVM options in the Secure Agent to increase the memory for the Java heap size:
  1. 1. In Administrator, select Runtime Environments.
  2. 2. Select the Secure Agent for which you want to increase memory from the list of available Secure Agents.
  3. 3. On the upper-right corner of the page, click Edit.
  4. 4. In the System Configuration Details section, select the Type as DTM for the Data Integration Server.
  5. 5. Edit the JVMOption3 as -Xms1024m and JVMOption4 as -Xmx4096m.
  6. 6. Restart the Secure Agent.
Note: If you run the mapping task and the same issue occurs, you must specify a lower batch size and increase the memory for the Java heap size.