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 Rivery 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 Rivery 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 Rivery 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 Rivery to ensure that they match the intended database and schema where the table should be located.
   • Examine Rivery 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 Rivery, please refer to Rivery's Azure SQL documentation.

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