RVR-MSS-711

Issue summary

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

Action steps

To resolve the error, follow these steps:

1. Review index design:

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

2. Modify index columns:

   • Reduce the size of columns used in the index (For example, if you use NVARCHAR(1000), this could be reduced if the full length is not 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 does not exceed index limits.
   • Use filtered indexes if possible to reduce index size by indexing only necessary rows.

4. Check column data types:

   • Ensure that you are using appropriate data types for the indexed columns. For example, using VARCHAR instead of NVARCHAR for fields that contain only ASCII characters can help reduce the size.

5. Database design review:

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

External references

For more detailed guidance, refer to the following topics:

• Azure SQL Connectivity and settings.
• Maximum Capacity Specifications for SQL Server.

note

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