RVR-MSSQL-RDBMS-208

1. Issue Summary

   • The error "Failed to get column description" with Error Code: RVR-MSSQL-RDBMS-208 in a Data Connector: MSSQL context indicates a failure in retrieving metadata about columns from a specified database table. This generally relates to permissions or schema changes that are not acknowledged by the system.

2. Action Steps:

   • Verify Permissions: Ensure that the database user has sufficient privileges to access the necessary metadata. The user might need SELECT permissions on the system tables/views or the specific tables in question.
   • Check Database Schema Changes: Review if there have been any recent changes to the database schema, such as renaming tables/columns or removing columns, which are not yet reflected in the river configuration.
   • Update Rivery Schema Configuration: In Rivery, check if the schema needs to be refreshed manually to acknowledge any recent changes in the database structure.
   • Examine Logs for Details: Investigate the logs for any additional error messages that might provide more context on which column or table the issue is occurring.

3. External References:

   • Consult Rivery's documentation on SQL Server connections and troubleshooting permissions issues Rivery Documentation.
   • Microsoft SQL Server Official Documentation on granting permissions could be beneficial if permissions issues are suspected Microsoft Docs.

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