RVR-MSS-709

Issue summary

The error RVR-MSS-709 indicates an "Insert-Into failed" issue within Data Integration while using Azure SQL as the data connector. This error indicates a problem with the insert operation into an Azure SQL database.

Initial diagnosis involves factors such as schema mismatches, data type issues, connection settings, or query syntax.

Action steps

To resolve the error, follow these steps:

1. Verify table schema: Ensure that the table schema in Azure SQL matches the data inserted, including column names and data types.
2. Check data types: Use the SQL Server datatype mapping to ensure compatibility with Data Integration, as some data types might require conversion. For example, unsupported or mismatched data types could be automatically mapped to the String type.
3. Examine logs and queries: Look at the execution logs in Data Integration and the query logs in Azure SQL to view specific SQL errors that provide more context.
4. Data integrity and constraints: Confirm that there are no data integrity issues or constraints (like unique keys, foreign keys) that might be violated by the insert operation.
5. Reconnect and retry: Temporarily disconnect and reconnect to ensure there are no transient connectivity issues. After reconnection, retry the insertion operation.
6. Configuration verification: Ensure all configurations, such as API endpoints and authentication credentials, are correctly set in Data Integration for your Azure SQL database.

External references

• For further assistance on Azure SQL and setting up proper configurations, refer to Data Integration - Azure SQL as a Target topic.
• If you suspect datatype mismatches, review Microsoft’s official documentation on SQL Server Data Types topic.

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.