Skip to main content
Feedback

RVR-MSS-709

  1. 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 generally suggests that there is a problem with the insertion operation into an Azure SQL database. Initial diagnosis could involve various factors such as schema mismatches, data type issues, or possibly issues with the connection settings or query syntax.

  2. Action Steps:

    • Verify Table Schema: Ensure that the table schema in Azure SQL matches the data being inserted, including column names and data types.
    • Check Data Types: Utilize 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 String type.
    • Examine Logs and Queries: Look at the execution logs in Data Integration and the query logs in Azure SQL to see if there are specific SQL errors that provide more context.
    • 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.
    • Reconnect and Retry: Temporarily disconnect and then reconnect to ensure there are no transient connectivity issues. After reconnection, retry the insertion operation.
    • Configuration Verification: Ensure all configurations, such as API endpoints and authentication credentials, are correctly set in Data Integration for your Azure SQL database.

  3. External References:

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

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