Failed to get data from multiple data sources
Have you found a resolution for this error? we are getting the same error message when using multi data source.
No not yet, the multi data sources work on some machines and this user is able to open the components of the multi data source separately and preview them, it’s just when previewing or using the overall multi data source.
Does anyone have any update on this?
I am having the same issue. The Map is scheduled, and runs (and is failing) throughout the day, and then, all of a sudden, it’s successful. It fails when running manually too, so it’s not the scheduler, but other CRM maps work without issue, so it seems connected to this type of map.
We had five ODBC connections. One to Oracle and the other four to SQL Server. The previews worked individually but combined it gave the same error. We had to name our columns because we used a trim in our select. I know it should be qualified by the table name, but it wasn’t in our case.
ie. select trim(column) from table had to be changed to select trim(column) as name from table.
If you would like to submit an answer or comment, please sign in to the eOne portal.