RVR-RS-403

1. Issue Summary

   • The error code "RVR-RS-403" indicates a "Data Integration Redshift User Error." This type of error typically occurs due to permission issues or incorrect configurations within the Redshift environment when trying to connect or execute operations from Data Integration. It's important first to verify user permissions and ensure all prerequisites for the Redshift connection are correctly set up.

2. Action Steps:

   • Verify User Permissions:
     • Ensure the Redshift user associated with the Data Integration connection has the correct permissions, such as SELECT, INSERT, UPDATE, DELETE, and other necessary actions on the target schema and tables【4:4†source】.
   • Check Redshift Connection Settings:
     • Make sure the Redshift cluster is accessible and the host, port, and database name settings are accurate in the Data Integration connection configuration.
   • Whitelist IP Addresses:
     • Ensure that Data Integration IP addresses are whitelisted in the Redshift cluster's security group settings to prevent connectivity issues. This can be managed through the AWS Management Console under the VPC security group settings【4:10†source】.
   • Test the Connection:
     • Use the test connection feature in Data Integration to confirm that the connection to the Redshift cluster is stable and properly established.

3. External References:

   • For more details on setting up user permissions and configuration on Redshift, refer to the Amazon Redshift documentation.
   • Check Data Integration official documentation for additional guidance on Redshift connections and error handling.

If the issue persists or you need further assistance, please open a ticket with Data Integration support.