Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Gen2 Dataflow load to Lakehouse error - We cannot convert the value null to type Table

I am inconsistently getting this error across refreshes when loading to a lakehouse from a Gen2 Data flow (this is loading from an original dataflow) Sometimes the refresh completes - sometimes it ...
Dataflows
  • Anonymous's avatar
    Anonymous
    3 years ago

    This should now be fixed - we worked with the product team and it was addressed in a release last week

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I am using a SQL Server on-prem as source with latesest version of the gateway. 

From source to dataflow, all tables work but from DF to lakehouse, random tables are failing.

This is one of the error messages I can have

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sounds like exactly the same situation - once i have met with the Microsoft aupport engineer I will update this post

  • SidJay's avatar
    SidJay
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    Could you please try upgrading to the latest Gateway (version 3000.178.9 released on June 15th). That should help address at least one class of errors involving output destinations and/or queries that depend on other staged queries.

     

    Please let us know if the issues persist after that. Thanks.

    • amolt's avatar
      amolt
      Icon for Resolver I rankResolver I
      3 years ago

      Hello SidJay,
      I have updated the gateway and manually restarted the loading. No more errors!
      I'll wait for the scheduled executions and update my post.

      thanks