Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Hi,
1. Created system DSN in Custom ODBC driver
2. Power BI desktop works fine with system dsn ( Connection string used is 'dsn=system dsn name' with sql option)
3. While creating data source with same driver with system dsn in on premise gateway non personal mode facing exception
Please find stack trace copied from export logs, Is anything is incorrect while configuring data source?
GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=MashupValueException
InnerMessage=<pi>ODBC: ERROR [HY000] Connection failed:
The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:09:59.9910036'.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY000] Connection failed:
The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:09:59.9910036'.</pi>
InnerToString=<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): ODBC: ERROR [HY000] Connection failed:
The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:09:59.9910036'.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY000] Connection failed:
The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:09:59.9910036'.
at Microsoft.Data.Mashup.ProviderCommon.MashupResource.<>c__DisplayClass4`1.<StartEvaluationAndGetResultSource>b__2()
at Microsoft.Mashup.Security.Impersonation.RunAsProcessUser[T](Func`1 func)
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>
Thanks
Abhishek
Hi @Anonymous,
This could be a problem with .NET. The TCP port Sharing service is not started before all Orion services. This could also be a problem where the following Microsoft Updates KB3102429 was installed. Please check blog to find the solution.
Regards,
Frank
Hi Frank,
Thanks for your reply, i tried everything suggested in blogs but no luck all though it works fine with Power BI Desktop
1. Restart NetTcpPortSharing and then restart gateway service
2. KB3102429 update is not installed where gateway is installed
3. We dont use orion services
Thanks
Abhishek