Sagent Data Flow - COleDispatchException and SaSnHost Error

Product Feature: Weblink Client



When a plan is run from Design Studio, a COleDispatchException is thrown by the excel sink.

When the same plan is run from Sagent web link, a SaSnHost error box pops up but no error message is displayed.


Similar plan runs fine even with much more data than the amount of data that is being displayed at customer end, which indicates this is not a product specific issue but rather a data issue.

After analysing the plan and data at customer end, we could isolate that the "Address" column in the client database is causing this issue.



UPDATED: March 30, 2017
The client identifed the erroneous data record.  After removing the record the issue is resolved.