RVR-MSS-718

1. Issue Summary

   • You are encountering an error with Azure SQL related to index creation, with the error code RVR-MSS-718. This is an external error possibly related to issues with the database setup or permissions preventing successful index creation.

2. Action Steps:

   • Check Permissions: Ensure that the necessary permissions to create indexes are granted to the user executing the operation. The user should have appropriate roles or explicit permissions for index creation in the Azure SQL environment.
   • Review Azure SQL Setup: Sometimes, external errors like these can occur if there are configuration issues within the Azure environment. Verify that the SQL Database is correctly set up and that all required resources are available.
   • Examine Index Creation SQL: Double-check the SQL statements being used to create the index. Ensure syntax correctness and that the target table and columns exist.
   • Monitor Quota Limits: Sometimes, such errors can be related to hitting a certain limit or quota on Azure SQL. Review any logs provided by Azure to see if there are errors related to resource limits.
   • Use Azure Portal Logs: Check the Azure Portal for any logs or alerts that might provide more details on why the index creation failed. Azure’s diagnostic settings can be helpful in identifying such issues.

3. External References:

   • For specific configurations and best practices with Azure SQL, refer to Azure SQL Documentation.
   • General Azure Database Limits and Quotas are detailed here.

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