Forum Discussion

amitgawali's avatar
amitgawali
Frequent Visitor
8 years ago

Cannot add Data source to Data gateway

Hi ,   I have recently upgraded my On-premises data gateway from version 14.16.6524.1 to 14.16.6584.1 and after that I am not able to add data source under Gateways. Hwnever I try to add Data sourc...
Need Help
amitgawali's avatar
amitgawali
Frequent Visitor
8 years ago

Here is part of GatewayXXXXXXX.log file:

 

 

 

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
Reason= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): MySQL: Reading from the stream has failed.
   at Microsoft.Data.Mashup.ProviderCommon.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
   at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
   at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
   at Microsoft.Data.Mashup.MashupCommand.ExecuteReader()
   at Microsoft.Data.Mashup.DataSourceReference.TestConnection(String connectionString)
   at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.DSRTestConnectionAsync(String dsrJson, MashupCredential credential)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.MashupOleDbConnectionProvider.<TestConnectionAsync>d__3.MoveNext()</pi>

 

Can you help here?

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi amitgawali,

 

I can only find your log alert :

MySQL: Reading from the stream has failed

 

I think you need to check on this part or share more detail logs.

 

Regards,

Xioxin SHeng