Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
jepcom
New Member

Enterprise Gateway, oracle Data source: DM_GWPipeline_Gateway_MashupDataAccessError

‎08-18-2016 01:22 AM

Im having problem adding an Oracle Datasource. I looked around the forum, and ther users have had success in reinstalling. This didn't wrk for me (even though i took over the old gateway settings)

 

Im getting this error message:

 

Power BI

Forbindelsen kunne ikke oprettesDer opstod en fejl under forsøget på at oprette forbindelse til 172.16.50.21:1521/qcdb. Oplysninger: "Der kan ikke oprettes forbindelse til miks-datakilden. Du kan få mere at vide i fejloplysningerne."Skjul detaljer
Aktivitets-id:4cd29032-b1a4-46f5-8011-f4129f3f06f5
Anmodnings-id:1e73167a-b5ee-ce74-96c0-b0a5dc5b2a2c
Klynge-URI:https://wabi-north-europe-redirect.analysis.windows.net
Statuskode:400
Fejlkode:DM_GWPipeline_Gateway_MashupDataAccessError
Klokkeslæt:Thu Aug 18 2016 10:16:32 GMT+0200 (Romance Summer Time)
Version:13.0.1605.328

 

With the underlying error:

Power BI

Underliggende fejlkode:-2147467259
Underliggende fejlmeddelelse:Object reference not set to an instance of an object.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:Oracle
Microsoft.Data.Mashup.ValueError.DataSourcePath:172.16.50.21:1521/qcdb
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error

 

In the log it says:

 

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
Reason= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): Object reference not set to an instance of an object.
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.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.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__b.MoveNext()</pi>

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
InnerType=MashupValueException
InnerMessage=<pi>Object reference not set to an instance of an object.</pi>
InnerToString=<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): Object reference not set to an instance of an object.
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.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.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__b.MoveNext()</pi>
InnerCallStack= at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.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.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__b.MoveNext()
([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTrace:)
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.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.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__b.MoveNext()
--- End of inner exception stack trace ---
([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException.StackTrace:)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.MashupOleDbConnectionProvider.<TestConnectionAsync>d__b.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.AdoNetDbFullConnectionString.<TestConnectionAsync>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.DbFullConnectionString.<TestConnectionAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass28.<<TestDataSourceConnection>b__27>d__2a.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<TestDataSourceConnection>d__2e.MoveNext()
--- End of stack trace from previous location where exception was thrown ---

Message 1 of 5
2,142 Views
0
4 REPLIES 4
ahmad
Frequent Visitor

‎11-01-2016 06:15 AM

Hii @jepcom
Please let me know if you got any Feedback about this problem because i'm facing the same error when i'm trying to connect power BI Gateway to NAV2013 R2.

Message 5 of 5
2,036 Views
0
ahmad
Frequent Visitor

‎11-01-2016 06:09 AM

HI..

please have you got any feedaback about this error because i'm facing the same problem when i'm connecting my power BI Gateway to my NAV2013 R2. 

Message 4 of 5
2,036 Views
0
v-qiuyu-msft
Community Support
Community Support

‎08-21-2016 06:56 PM

Hi @jepcom,

 

In your scenario, I would suggest you check if the Server name and Authentication Mode specified under On-Premises gateway are valid. You can open the Power BI Desktop, then connect to the Oracle database by specifying the server name and database authentication credential to check if connection can be built successful. After you get the data from Oracle database, please configure the data source under gateway use the same server name and credential.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 5
2,117 Views
0
ahmad
Frequent Visitor
In response to v-qiuyu-msft

‎12-18-2016 06:23 AM

HI @v-qiuyu-msft

Looking to your help,

i have almost the same problem, Enterprise Gateway with navision 2015 i have tried to connection from Power BI desktop as you mentioned and it has connect succesfuly but from power BI website it just stay loading without getting any data.

please any information abou this problem.

 

Regards

Ahmad

Message 3 of 5
1,902 Views

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

View All