Recently I’ve been receiving this error message when using the “Web Service Connector” and “External Lookup” tool.
Exception from HRESULT: 0x80040E14.
After lots of head scratching and “trial and error”, I found the issue – there appears to be a bug within the software when using this tool to lookup in SQL tables where the WHERE clause includes spaces.
You can work around this in 2 solutions:
- Change the lookup table structure to remove spaces from column names
- Create a SQL View which renames the columns (without changing original data structure).
With my problem, I went for the former.