Error: Designer x64: The Designer x64 reported: You have found a bug. The pipe has been en

Question

Hi All,

I'm using the ADLS connector to fetch a csv file from my datalake.

This cvs file is from Salesforce and a encrypted version of the file is here.  This is how SF stores the file.  I need other tables to get the specifics.

It's a simple read, but I get the error as seen in my screenshot:

This is a very cryptic error message.

I know that I can ingest csv files from the same ADLS container that are from different sources with no issues, so I think it must be related to salesforce.

Any inclines on what this error to be pinting to as the root cause?

Note that my csv file is attached below.

When I save the file locally to my hard drive and read it in using an 'Input Data' tool, it reads perfectly.

ProposalHistory.CSV

prpatel · Accepted Answer

Update:  I did not find the root cause of this error, but we think it had to do with the cvs file not terminating correctly.

We resolved this issue by using the Simba OBDC driver and making an OBDC connection directly into SalesForce.