RVR-MSSQL-RDBMS-204

1. Issue Summary

   • The error code RVR-MSSQL-RDBMS-204 indicates a failure in retrieving the table name when using the Data Integration platform to connect with an MSSQL data source. This typically occurs due to issues related to table naming conventions or schema permissions. It might also be due to unsupported characters in the table or column names, or an inability to access the metadata necessary to identify the tables correctly.

2. Action Steps:

   • Verify Permissions: Ensure that the user used for the MSSQL connection has appropriate permissions to view and select from the tables. You can grant the necessary permissions in MSSQL to allow Data Integration to access metadata (like table schemas) and table data:

     GRANT SELECT ON SCHEMA::[schema_name] TO [user_name];
     GRANT VIEW ANY DEFINITION TO [user_name];

     This includes permissions to view definitions and select permissions on the relevant tables.

   • Check Table Names: Make sure the table names do not include unsupported special characters or a mix of uppercase and lowercase letters. Data Integration does not support table or column names that combine uppercase and lowercase characters, which can lead to naming issues.

   • Validate Connection Details: Double-check the connection details configured in Data Integration to ensure there are no typos in the database name, schema, or table names. This includes verifying the correct settings and credentials in the Data Integration platform’s connection setup for SQL Server.

3. External References:

   • Data Integration Documentation on MSSQL Connection Setup: Data Integration SQL Server Integration Guide (replace this URL with the correct path if needed).
   • SQL Server Naming Conventions and Permissions: Microsoft SQL Server Documentation.

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