Skip to main content
Feedback

RVR-SYNP-308

Issue summary

  • The error code RVR-SYNP-308 encountered in Data Integration when attempting to load data into an Azure Synapse table typically suggests a failure during the data loading process. This can arise from various issues such as connectivity problems, misconfigurations in data mapping, or permissions related issues.
  • Initial diagnosis based on similar cases highlights the need to check the table schema compatibility, data types, and loading modes used in the Data Integration setup.

Action steps

To resolve the error, follow these steps:

  • Verify Connection: Ensure that the connection to Azure Synapse is properly configured. This can include checking the connection parameters like host, database, username, and password.
  • Check Table Schema: Confirm that the table schema and data types in Synapse match those expected by Data Integration. Any discrepancies can cause data loading to fail.
  • Permissions: Make sure that your Data Integration service account has sufficient permissions on Azure Synapse. Specifically, it should have permissions to insert data into the tables you are targeting.
  • Review Logs: Check Data Integration logs and Azure Synapse logs for more specific error messages that might indicate the exact cause of the data load failure.
  • Loading Mode Configuration: Ensure that the loading mode (e.g., upsert-merge, append-only) is correctly set if using specific methods that might require pre-existing indexes or constraints.

External references

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.

On this Page