Skip to main content
Feedback

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 Data Integration Schema Configuration: In Data Integration, 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 Data Integration documentation on SQL Server connections and troubleshooting permissions issues Data Integration 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 Data Integration support.