RVR-LTMS-606

1. Issue Summary

   • The error code RVR-LTMS-606 for the load_to_azure_sql data connector indicates that there is an issue with a non-existent schema when attempting to load data into Azure SQL. This is an external error meaning the schema specified in your Rivery pipeline configuration does not exist in the target Azure SQL database.

2. Action Steps:

   • Verify Schema Existence:
     • Check your Azure SQL database to confirm that the schema you are trying to load data into actually exists. This can be done through a SQL query or by browsing through the SQL Server Management Studio (SSMS) or Azure portal.

       SELECT * FROM information_schema.schemata WHERE schema_name = 'YourSchemaName';
       

   • Correct Configuration:
     • Ensure that the schema name is correctly specified in your Rivery pipeline configuration. Minor typographical errors can lead to such issues. Double-check the spelling and case sensitivity.
   • Permissions:
     • Confirm that the user account used by Rivery has the necessary permissions to access and write to the schema in Azure SQL. Grant CREATE, SELECT, or any other necessary permissions to your schema as needed.

       GRANT SELECT, INSERT, UPDATE ON SCHEMA::YourSchemaName TO YourUserName;
       

   • Check Database Connection:
     • If the schema appears to not exist and all configurations seem correct, double-check your connection details in Rivery to ensure it's connecting to the correct database instance where the schema should exist.

3. External References:

   • Rivery Documentation on Azure SQL Connection

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