RVR-SF-RDBMS-309

1. Issue Summary

   • You encountered the error "Failed to get the column description" with Error Code: RVR-SF-RDBMS-309 when using the RDBMS data connector in Rivery. This error typically indicates that the platform is unable to retrieve column metadata for the specified database table during the data extraction or transformation process.

   • A likely cause for this error could be issues with database permissions, connectivity, or an unsupported data type or object within the database schema.

2. Action Steps:

   • Verify Database Connectivity and Permissions:
     • Ensure that the database connection settings in Rivery are correct. Test connection and verify that the credentials provided have the necessary permissions to access metadata information such as column details from the database.
   • Check Table and Column Naming Conventions:
     • Ensure that the table names and column names comply with Rivery's naming conventions. Specifically, avoid using names that mix uppercase and lowercase characters or special characters that might not be supported.
   • Update or Refresh Metadata:
     • If you have recently made changes to the database schema, refresh the metadata in Rivery to ensure it reflects the current structure of the database.
   • Review Logs for Detailed Error Messages:
     • Check the execution logs or any available diagnostic messages in Rivery to pinpoint where the issue occurs and gather more context about the error.
   • Reinitialize the Data Pull if Using Incremental Mode:
     • If this error occurs during an incremental pull, you might need to reinitialize your data extraction in Rivery and ensure all previous configurations are correctly set.

3. External References:

   • For more details on data connectors or specific settings adjustments, refer to the official Rivery documentation: Rivery Documentation.
   • To understand more about handling specific errors or data connector issues, you may consult the section of Rivery documentation related to RDBMS connections.

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