RVR-SYNP-309

1. Issue Summary

   • Error Code: RVR-SYNP-309 indicates a failure when attempting to drop a table in Azure Synapse. This error typically occurs when there is a problem related to the table's existence, permission issues, or the locking of the table by another operation.
   • Initial Diagnosis: The error may arise if the table you are attempting to drop is in use, if the user lacks sufficient permissions, or if there are dependent objects that prevent the table from being dropped.

2. Action Steps:

   • Check Table Existence: Ensure that the table you are trying to drop actually exists in the Azure Synapse database.
   • Permission Verification: Verify that your user account has the necessary permissions to drop tables. This typically requires the DROP permission on the table or ALTER permission on the schema.
   • Resolve Locks or Dependencies: Check if the table is currently locked or if there are existing dependencies (like foreign keys or indexes) that aren't allowing the table to be dropped. Use system views to check for locks or use the Management Studio or scripts to find and resolve dependencies before attempting to drop the table again.
   • Check Active Sessions: Ensure that there aren't active queries or processes that might be using the table, as these can prevent table alterations or deletions.

3. External References:

   • For more details related to Azure Synapse-specific operations and permissions, refer to the official Rivery documentation here.

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