OLEDB issue - external table is not in the expected format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-11-21 08:07 AM
External Table is not in the expected format
I have observed that the same code works fine in next attempt.
This is happening in Prod only and not able to replicate in UAT and Dev.
Any suggestions to fix this intermittent issue where bot fails to open OLEDB connection?
Thanks in advance
Daulat
------------------------------
Daulat Ram
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-11-21 12:59 PM
I came across this post on Stackoverflow that might address your issue. Looks like they're changing their connection string a bit.
https://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-11-21 05:53 AM
Thanks,
Daulat
------------------------------
Daulat Ram
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-11-21 06:05 AM
Can you also try to check the file format. Some times files are stored as xlsx but they refer to XML spreadsheet type and not your typical Excel Workbook type which creates issue while connecting with excel files as OLEDB. We have seen this issue in past when we directly downloaded any file from SAP and tried to read it directly using OLEDB connection. As a workaround, we first need to save the file again as a proper .xlsx (Excel Spreadsheet Format) and then continue with it.
You can check the different excel formats in the given screenshot below. The one highlighted is likely to case the issues when trying to establish an OLEDB connection. Ensure that your file is first saved as the first xlsx format which you can see in the screenshot :
------------------------------
Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-10-23 05:16 PM
posting on a old thread in case if someone able to resolution on this. Received this error all of sudden while bot running in production and next day on re-run - issue did not came.
------------------------------
Neeraj Kumar
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-10-23 01:51 PM
I've seen this error come up a few times when there is a data mismatch between the columns in the excel file and collections i want to extract to. E.g. a column contains a datetime format in the excel file but the collection might be all text. Its also been an issue where the format types cant be reconciled, i think by default the oledb takes everything as text but if a column is formatted to a type that sql is not familiar with it can cause an error. I resolve this by doing a format to text all for all columns in the excel file before running the oledb action which was ok for the data i was using.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------