Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CrossServer extraction source when used with $g reports 'could not find table' if the guid starts with a number #1256

Closed
tznind opened this issue Jun 24, 2022 · 0 comments · Fixed by #1257
Labels
bug Issues that highlight a piece of functionality that is not working as expected

Comments

@tznind
Copy link
Contributor

tznind commented Jun 24, 2022

Describe the bug
ExecuteCrossServerDatasetExtractionSource has a field TemporaryTableName 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 the ExecuteCrossServerDatasetExtractionSource complains that it asked for the table to be created but then the table didnt exist (because it expects it to still be called 123ab254)

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.

@tznind tznind added the bug Issues that highlight a piece of functionality that is not working as expected label Jun 24, 2022
tznind added a commit that referenced this issue Jun 24, 2022
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Issues that highlight a piece of functionality that is not working as expected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant