(v23) Troubleshoot the Amazon Redshift Connector

Troubleshoot the Amazon Redshift Connector

This applies to: Visual Data Discovery

The SymphonyAmazon Redshift connector lets you access the data available in Amazon Redshift storage using the Symphony client. You can troubleshoot out of memory errors that may occur when executing heavy queries against large databases.

Out Of Memory Errors

To troubleshoot out of memory errors, you'll need to set the connector log to DEBUG mode. Edit the Redshift configuration file, edc-redshift.properties. See Connector Properties and Property Files. Use the information available in the log to adjust your environment to prevent further errors.

After you set your log to DEBUG mode, run your queries again. Review the logs, and use one or more approaches to resolve the out of memory issues.

• Rewrite your most memory-consuming queries to return more granular results.

• Increase the RAM allocation in your Symphony environment for this connector. See Configure Memory Settings.

• Increase the wlm_query_slot count in your AWS environment. See Troubleshooting queries - Amazon Redshift.