RVR-MSSQL-RDBMS-208

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.

Action steps

To resolve the error, follow these steps:

• Verify Permissions: Ensure that the database user has necessary 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 Data Flow 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.

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 you suspect Microsoft Docs.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.