RVR-RS-403

Issue summary

The error "Data Integration Redshift User Error" with error code RVR-RS-403 indicates that Data Integration is unable to connect to or perform operations on an Amazon Redshift cluster due to permission, network access, or configuration issues.

Common causes include:

• Insufficient user permissions on schemas, tables, or functions
• Incorrect Redshift connection configuration
• Network or security group restrictions blocking access
• Redshift cluster accessibility or session-related configuration issues

Action steps

1. Verify user permissions: Ensure that the Redshift user associated with the Data Integration connection has the required permissions on the target schemas and tables. Verify permissions such as SELECT, INSERT, UPDATE, DELETE.
   Also, confirm access to any required schemas or functions by running the appropriate SQL commands in a SQL client connected to Redshift.
2. Check Redshift connection settings: Confirm that the Redshift connection details configured in Data Integration are correct, including, Host, Port, Database name, Username and Password.

   Ensure the Redshift cluster is running and reachable.

3. Review Network access and security groups: Verify that the Redshift cluster’s VPC security group enables inbound traffic from the IP addresses used by Data Integration. This can be configured through the AWS Management Console.
   If the cluster is intended to be publicly accessible, ensure it can be reached from outside the VPC. Otherwise, confirm that appropriate private networking is correctly configured.
4. Test connection: Use the Test Connection feature in Data Integration to validate that credentials, network access, and configuration settings are correct and that a stable connection can be established.
5. Contact support: If the issue persists after completing the steps above, open a support ticket with Data Integration Support. Include the error code (RVR-RS-403) and any relevant logs or error messages to assist with troubleshooting.

External references

• For more details on setting up user permissions and configuration on Redshift, refer to the Amazon Redshift and Super users topics.
• for additional guidance on Redshift connections and error handling, refer to the Data Integration Redshift connection topic.

note

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