CrossServer extraction source when used with $g reports 'could not find table' if the guid starts with a number #1256
Labels
bug
Issues that highlight a piece of functionality that is not working as expected
Describe the bug
ExecuteCrossServerDatasetExtractionSource
has a fieldTemporaryTableName
that defaults to$g
.At runtime a guid is allocated if the pattern contains '$g'. If that guid starts with a number e.g.
123ab254
then it is not a valid table name. DataTableUploadDestination recognises this and appends an underscore (i.e. it creates a table_123ab254
but then theExecuteCrossServerDatasetExtractionSource
complains that it asked for the table to be created but then the table didnt exist (because it expects it to still be called123ab254
)The workaround is to change the
TemporaryTableName
pattern to_$g
The fix is probably to always put an underscore at the front or trim leading digits from the guid.
The text was updated successfully, but these errors were encountered: