Skip to main content
Feedback

RVR-LTMS-606

Issue summary

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

Action steps

To resolve the error, follow these steps:

  1. Verify Schema existence:
    • Check your Azure SQL database to confirm that the schema you are trying to load data into actually exists by using 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';
  1. Correct configuration:
    • Ensure that the correct schema name is correctly specified in your Data Integration pipeline configuration. Minor typographical errors can lead to such issues. Double-check the spelling and case sensitivity.
  2. Check permissions:
    • Confirm that the user account used by Data Integration 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;
  1. Check Database connection:
    • If the schema appears not to exist and all configurations are correct, double-check your connection details in Data Integration to ensure it connects to the correct database instance where the schema exists.

External references

For more information, refer to Data Integration documentation on Azure SQL Connection.

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.

On this Page