RVR-SYNP-301

Issue summary

The error code RVR-SYNP-301 occurs while trying to create an external file format using the Azure Synapse data connector in Data Integration. This typically indicates a problem with the configuration or execution of the external file format definition in Azure Synapse Analytics. This suggests an issue with the setup parameters, permissions, or the syntax used to define the file format.

Action steps

To resolve the error, follow these steps:

1. Check Synapse SQL access and permissions: Ensure that the user account has the necessary permissions to create external resources in Azure Synapse. You might need ALTER or CONTROL permissions on the database where you're trying to create the format.
2. Validate external file format syntax: Review the syntax used in your external file format creation statement for any errors or omissions. You may refer to Azure Synapse documentation for the correct syntax and examples.
3. Ensure correct data source integration: Double-check the integration settings for Azure Synapse in Data Integration. Ensure that all connection parameters, including storage configurations and authentication methods, are properly configured.
4. Consult Data Integration documentation: Look at Data Integration documentation on setting up connections with Azure Synapse to ensure no steps were missed or incorrectly implemented.

External references

For more information, refer to the following topics:

• Azure Synapse Analytics - Creating External File Formats-Microsoft Documentation
• Data Integration Documentation on Azure Synapse

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.