RVR-SF-RDBMS-316

1. Issue Summary

   • Error Code: RVR-SF-RDBMS-316
   • Data Connector: RDBMS
   • Error Description: This error indicates a failure in fetching available warehouses in a Data Integration River setup. It may be related to incorrect configurations, permissions, or connectivity issues between Data Integration and the data warehouse service (e.g., Snowflake, Databricks, etc.).

2. Action Steps:

   • Check Connection Settings: Verify that the connection settings to the warehouse are correctly set up in Data Integration. This includes ensuring the correct server address, ports, and credentials are in use.
   • Verify Warehouse Permissions: Ensure that the credentials used in the data connector have adequate permissions to access the warehouse resources. You might need roles that allow viewing or interacting with warehouses.
   • Whitelist Data Integration IPs: If access is restricted by IP, ensure that Data Integration IPs are whitelisted in your warehouse's network configuration. For specific guides on whitelisting, refer to the relevant Data Integration documentation.
   • Consult Logs and Error Messages: Check any available logs or error messages returned by Data Integration or your data warehouse service, as these may provide additional context or specific error descriptions related to connectivity or permissions.
   • Reinitialize or Reset Connections: Sometimes reinitializing the connection or resetting the Data Integration river that connects to the warehouse can resolve transient issues.

3. External References:

   • For more detailed configuration and setup instructions, refer to Data Integration official documentation on connections and ensure your warehouse setup aligns with the recommendations.
   • Check the specific data warehouse provider's documentation (e.g., Snowflake, Databricks) for any additional required settings or troubleshooting tips.

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