Forum Discussion

Ariunbold_Chimeddorj's avatar
Ariunbold_Chimeddorj
Copper Contributor
Jan 05, 2021

Sql server 2019 polybase: 100001;Failed to generate query plan.

Hello all, I have enabled the polybase on my sql server. When i try to create external data source, below error throws. What is the cause of this error? Error: 100001;Failed to generate query plan...
MarkE1475's avatar
MarkE1475
Copper Contributor
Feb 02, 2021

I'm receiving the same error with the same version of sql.  I'm attempting to create a SQL external data source though.  I have an open support ticket with Microsoft.  I'll update this thread if we discover a resolution.  

MarkE1475's avatar
MarkE1475
Copper Contributor
Feb 10, 2021

MarkE1475 We have a resolution for our issue '100001; Failed to generate query plan' when attempting to create External Data Source.  We had to reinstall the latest CU.  Steps to replicate the error:

1) Install SQL 2019 base version.

2) Upgrade the latest CU.

3) Install Polybase.

4) Attempt to create External Data Source - receive error.

5) ***Resolution*** - Reinstall CU.

 

EricChizzle I believe this will resolve your issue with Dev and Test environment not working the same.

  • stephanesql's avatar
    stephanesql
    Copper Contributor
    Feb 10, 2021

    Thanks MarkE1475 . I reinstalled the last CU and I could create the data external source without this error.

Resources