Why do I see "Problems During Load - Unknown" error while exporting to Excel file?
Environment:
Analytics, Oracle B2C Service all versions
Resolution:
Error "Problems During Load - Unknown" is an MS Excel engine error. It returned when at least one of the exported records contain hyperlink/URL that is pointing to the server or PC locally stored file (can only be accessed from the application or from a single workstation).
Examples:
"Folder/Subfolder/Example1.pdf"
"C:\New Folder\Example2.pdf"
MS Excel engine performs a URL check and errors since it unable to reach the local file.
This is specifically related to the column formatting where text values displayed as a URL:
- Right Click on a Column
- Edit Format
- URL tab
- Use cell value as URL
In such occasion we recommend to export to CSV file instead. URL check is not performed during the export because links in Comma-Separated Values files stored as a plain text.
Additionally, column formatting can be set back to default where cell value displayed as a text. In this case data can be exported directly to Excel file.
