RVR-MSS-821

Issue summary

• The error code RVR-MSS-821 indicates a "Connection missing field" problem with the Azure SQL data connector within Data Integration. This error suggests that a necessary connection field has not been provided or is improperly configured. Initial diagnosis points to a missing or incorrect input required for establishing a proper connection to Azure SQL.

Action steps

To resolve the error, follow these steps:

• Verify Connection Credentials: Ensure all required fields for the Azure SQL connection are provided. Typically, this includes:
  • Server name
  • Database name
  • User name
  • Password
• Check Firewall Settings: Configure Azure SQL firewall settings to allow connections from the Data Integration platform. Ensure Data Integration IP addresses are allowlisted.
• Review Connection Configuration: Double-check the correctness of each input needed during the connection setup in Data Integration.
• Test the Connection: Use the "Test Connection" feature in Data Integration to validate that all the inputs are correct and that there are no connection blockages. Adjust any parameters if necessary and retest.

External references

• Data Integration Documentation on Azure SQL Connection for detailed steps on setting up the Azure SQL connection.
• Azure SQL Database Connectivity Architecture for general information on setting up access and firewall configurations for Azure SQL.

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.