RVR-BSPTOR-116

Issue summary

• The error code "RVR-BSPTOR-116" pertains to a failure in generating mapping for non-Excel files when using Data Integration’s storage data connector. This issue often arises when the platform is unable to understand or process the structure of the data file provided if it is not an Excel file. This can occur if the file type is not supported or properly configured for auto mapping or if there is a mismatch in expected file format settings.

Action steps

To resolve the error, follow these steps:

• Verify the file type: Ensure that the file you are using Data Integration supports by Data Integration for the data operation you intend to perform (CSV, JSON in jsonlines format, or other files). If your file type is unconventional or not typically listed, consider revising it to a supported format.
• Check Mapping Configuration: Make sure the columns or fields in your file are correctly defined or loaded. Use Data Integration’s "Auto Mapping" feature to automatically set the mapping based on your file's structure, or manually configure mapping if auto mapping fails.
• Review any settings related to non-Excel file handling: Adjust settings related to "raw data preservation" in some target platforms like Snowflake if necessary. Sometimes enabling such settings can help in dealing with unstructured or unexpected data formats.

External references

• For more information on supported file types and mapping, refer to the Data Integration Documentation on File Integration (ensure you navigate to the correct section relevant to your file type).

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.