Forum Discussion

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
3 years ago

Dataflow Gen2 Issue

Hi,   I'm trying to run a very simple Gen2 Dataflow from an on prem sql server.   All setups fine but when I ask it to refresh I get: "Error: Couldn't refresh the entity because of an issue ...
Dataflows
shhemanth's avatar
shhemanth
Frequent Visitor
3 years ago

We are getting error while writting to lakehouse, source is onprem oracle databse, with out writting to lakehouse the gen2 dataflow refreshes succesfully.

 

Mashup Exception Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) Details: DataSourceKind = Lakehouse;DataSourcePath = Lakehouse;Message = A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.);ErrorCode = -2146232060;Number = 121;Class = 20 GatewayObjectId: cd3ddd2d-fd2e-43c2-b2eb-d5f50a748335

miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
3 years ago

this could potentially be a firewall rule set in your environment that is preventing the communications between the gateway and one of the services required to run the dataflow. Please check the article below:

Configure proxy settings for the on-premises data gateway | Microsoft Learn

 

If this doesn't solve the scenario, please create a new topic / thread in the forum so that we can better understand your scenario.