cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhishek11533 Frequent Visitor
Frequent Visitor

Not able to Create Data Source in On-Premise Gateway using Custom ODBC Driver having System DSN

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Not able to Create Data Source in On-Premise Gateway using Custom ODBC Driver having System DSN

Hi @abhishek11533,

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
abhishek11533 Frequent Visitor
Frequent Visitor

Re: Not able to Create Data Source in On-Premise Gateway using Custom ODBC Driver having System DSN

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