RVR-MSS-711

1. Issue Summary

The error "External Error - Index max size exception Error Code: RVR-MSS-711" encountered with the Azure SQL data connector suggests that your data operation attempts to create or work with an index that exceeds the maximum size limit defined by SQL Server. This can occur if the size of the indexed columns combined surpasses the SQL Server's limit for maximum index key size which is 900 bytes.

2. Action Steps:

To resolve this issue, you can take the following steps:

1. Review Index Design:

   • Evaluate the columns included in the index. Ensure that they do not exceed the maximum size limit of 900 bytes for indexed columns in SQL Server. This usually happens with VMCHAR, CHAR, and other character-based data types.

2. Modify Index Columns:

   • Consider reducing the size of columns used in the index (e.g., if you use NVARCHAR(1000), this could be reduced if the full length isn't necessary) or remove non-critical columns from the index.

3. Implement Efficient Indexing Strategies:

   • Consider breaking the operations task into smaller chunks to ensure each chunk doesn't exceed index limits.
   • Use filtered indexes if possible to reduce index size by indexing only necessary rows【4:15†source】.

4. Check Column Data Types:

   • Ensure that you're using appropriate data types for the indexed columns. For example, using VARCHAR instead of NVARCHAR for fields known to hold only ASCII characters can help reduce the size【4:15†source】.

5. Database Design Review:

   • A broader review of your database schema might be necessary to avoid such issues and optimize performance, focusing on how data is indexed and queried.

6. External References:

For more detailed guidance, you might refer to:

• Rivery Docs on Azure SQL Connectivity and Settings.
• SQL Server Documentation on Maximum Capacity Specifications for SQL Server.

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