Forum Discussion

FredrikJ's avatar
FredrikJ
Resolver I
3 years ago
Solved

Problem running a gen2 dataflow from a non azure sql server via a gateway to a Lakehouse

Hi!

 

I have set up a gen2datflow from an oracle database via gateway (version number 3000.178.3) and everything looks fine in the dataflow I can my data. Destinations of the dataflow is to a lake house and it works fine to publish the Dataflow but when refreshing the Dataflow it fails with no error message

 

Regards

Fredrik

  • SidJay's avatar
    SidJay
    3 years ago

    The most recent version of the Gateway (version 3000.174.12 uploaded on May 30th) addresses the "We don't support creating directories in Azure Storage unless they are empty" error.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi,

     

    It works ! Thanks a lot for the quick fix

17 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    What error message are you getting? If you click on the Table Name (DART) is should give you the error message.

     

    I'm having siliar issues. I'm getting this error;

     

    Error Details: Error: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: We don't support creating directories in Azure Storage unless they are empty. Details: #table({"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {}) GatewayObjectId: b4a8b741-aef4-482e-9d30-19d6dea19022. Request ID: 78757b74-d18e-c8c3-6e24-7c16331d838d. (Request ID: 2dfa424a-69ea-41c2-a61a-82484f43eee7).

    • FredrikJ's avatar
      FredrikJ
      Resolver I

      Yes, I see now I get the same errormessage:

      Error Details: Error: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: We don't support creating directories in Azure Storage unless they are empty. Details: #table({"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {}) GatewayObjectId: 89d69b05-cbca-4382-b000-c8c76058d4ed. Request ID: a0a20bcc-958f-09b6-c6bd-bdfab9bf796f. (Request ID: 4a0c7012-c9ec-417a-8029-e2281b52a919).

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello, 

      I have exactly the same error than you after I have updated the Gateway. 

      Did you find any solution yet ?

       

      Thanks,

      David

      • SidJay's avatar
        SidJay
        Microsoft Employee

        The most recent version of the Gateway (version 3000.174.12 uploaded on May 30th) addresses the "We don't support creating directories in Azure Storage unless they are empty" error.

  • miguel's avatar
    miguel
    Community Admin

    Hi all!

     

    The product team has been notified of the issue which is in relationship to the Gateway. They're working hard on pushing out a new version of the gateway that will have the fix for it. 

     

    Thank you for your patience!

  • miguel's avatar
    miguel
    Community Admin

    Hi FredrikJ Anonymous ,

     

    Would you mind updating to the latest version of the gateway and try again? Let us know if you're still any errors after updating the gateway

    • FredrikJ's avatar
      FredrikJ
      Resolver I

      Hi miguel !

       

      I updated the gateway today to version number 3000.178.3. And still got the same problem.

       

      Regards

      Fredrik

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have the latest version installed.

      • SidJay's avatar
        SidJay
        Microsoft Employee

        The most recent version of the Gateway (version 3000.174.12 uploaded on May 30th) addresses the "We don't support creating directories in Azure Storage unless they are empty" error.

  • miguel's avatar
    miguel
    Community Admin

    FredrikJ Anonymous Thank you for confirming this! please go ahead and raise a support ticket so an engineer can look deeper into it

  • suidino2's avatar
    suidino2
    Frequent Visitor

    Same error here. 

    Dataflow pulling from on-premise SQL-server by using enterprise gateway (updated to latest version)

    Dataflow destination setup to lakehouse. Dataflow itself setup successfully, but when tried to refresh the dataflow, it appears the same error message. 

  • Similar problem with DF Gen 2 with Lake house target. Simple one column hand entered table. For testing.  DF runs fine. Target won't keep saved credentials despite being entered repeatedly and seeing the destination in the saving and publishing steps...

    • miguel's avatar
      miguel
      Community Admin

      Hey! 

      As mentioned in the other thread, the problem that you're mentioning seems to be unrelated to the gateway related issue. I'd highly recommend reaching out to the support team to go deeper into this issue and possibly find a solution. 

      if there's no gateway involved in your dataflow, then the problem will be someplace else in our stack.

  • Seems i got a similar error: even when I create a new dataflow and enter data with one column and one row, and I want to write it to the lakehouse i get an error: 

     

     

    It seems that the dataflow can't save my connection using my Organizational Account