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 Rivery 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 Rivery 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【4:8†Rivery Documentation 202408 (2).pdf】.

   • Check Table Names: Make sure the table names do not include unsupported special characters or a mix of uppercase and lowercase letters. Rivery does not support table or column names that combine uppercase and lowercase characters, which can lead to naming issues【4:6†Rivery Documentation 202408 (2).pdf】.

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

3. External References:

   • Rivery Documentation on MSSQL Connection Setup: Rivery 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 Rivery support.