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

Hi,

 

Exactly same error message. Did you get any solution? Thanks

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have a call with a Microsoft Engineer tomorrow morning - will update after that.

 

Just out of curiousity how are you trying to load data ? we see this issue with dataflows, sql server, oracle databases and sharepoint as sources.

We have a cluster of gateways and our capacity is hosted in EMEA 

  • 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.