VERIFIED SOLUTION i
X

Sagent Data Flow - COleDispatchException and SaSnHost Error

Issue

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.

Cause

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.


 

Resolution

UPDATED: March 30, 2017


The client identifed the erroneous data record.  After removing the record the issue is resolved. 

 

Environment Details

Product Feature: Weblink Client


 

Downloads

  • No Downloads