RVR-MSS-806

1. Issue Summary

   • The error "Target table is missing, Error Code: RVR-MSS-806" indicates that the specified target table for your data operation within Data Integration cannot be found. This usually occurs when the table does not exist in the target database or the connection details or permissions do not allow Data Integration to access or create the table.

2. Action Steps:

   • Verify Target Table Existence:
     • Check if the target table exists in the designated database. You can do this using a database management tool or query.
   • Check Database Permissions:
     • Ensure that your Data Integration connection to the Azure SQL has the necessary permissions to access or create tables if they do not exist.
   • Review Connection Setup:
     • Revisit the connection setup parameters in Data Integration to ensure that they match the intended database and schema where the table should be located.
   • Examine Data Integration Configuration:
     • Verify the river configuration to ensure the correct table name is specified and intended actions (e.g., create if does not exist) are properly set.

3. External References:

   • For additional information and steps about configuring Azure SQL as a target in Data Integration, please refer to Data Integration Azure SQL documentation.

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