Forum Discussion
Helper IDataFlow Gen 2 Error:Fast copy user error
Totally understand that there were no settings at the query level, but would you mind checking if the Fast Copy setting at the Dataflow level was enabled?
You can see this inside the Options > Dataflow > Scale tab
You can turn this setting off and your Dataflow will not try to use Fast Copy unless you explicitly use the setting at the query level.
Complex values like [Table] values can create some situations that would prevent Fast Copy to behave the way its intended. It also happens with how Staging that table would yield the same column but with null values as you cannot store "Table" (complex values) into a staging table.
Helper IOk, disabling staging makes it work. Anyone can explain to me why exactly is that the reason foe failed dataflow, when other tables from the source are 100% fine with staging?
Community Adminhi!
Glad that you were able to find a solution.
It depends! but would you mind answering the following questions? it'll help us determine what could've happened:
1. What your Dataflow setting for "Fast Copy" was
2. What data it was holding inside your (did it have any "Binary", "Record" or "Table" values inside the columns?)
- PolinaOr
Hi,
1) Didnt have Fast Copy enabled for any
2) No, only [Table] values, as far as I understood
- miguel
Totally understand that there were no settings at the query level, but would you mind checking if the Fast Copy setting at the Dataflow level was enabled?
You can see this inside the Options > Dataflow > Scale tab
You can turn this setting off and your Dataflow will not try to use Fast Copy unless you explicitly use the setting at the query level.
Complex values like [Table] values can create some situations that would prevent Fast Copy to behave the way its intended. It also happens with how Staging that table would yield the same column but with null values as you cannot store "Table" (complex values) into a staging table.
- PolinaOr
Yeah, in the settings the "Allow use of Fast Copy" was allowed. Will turn it off. Should i turn the Staging back on in this case? As I understood, this allows for faster loading of data. Our database is over 10mln lines in each table.
Essentially the Query was creating mismatched results because of this setting?