cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dgsonic
Level: Powered On

Unknown Mashup Exception

Why does my data connection fail randomly for no apparent reason.  About every 5-6 days i get an exception error.  I was doing a demo of powerapp and i get "Failed to load [dbo].[tablename]. An error occurred on server. Server Response. Unknown Mashup Exception. inner exception: Column 'ProviderSpecificDataType' does not belong to table."

 

What the heck is this all about.  One day data connection good.. next day this...

 

Dgsonic

20 REPLIES 20
Rapha222
Level: Powered On

Re: Unknown Mashup Exception

Hi dgsonic,

 

I'm living the same problem since yesterday. I have 3 applications that was working yesterday and today can't access any data in the database (without any modifications on apps). I'm my case, I'm using gateway to access a database SQL Server is 2008 (Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)).

 

Are you using gateway to connect to database? What your database?

 

Looks like a general problem on Power Apps Data Access Service...

 

If I discover a way to solve this problem, I'll share... please do the same if you find a solution.

Microsoft LSRAF
Microsoft

Re: Unknown Mashup Exception

I am getting the same errror today on an app I created yesterday. It worked fine when I created it and today I get this error. It actually will submit data to my table but that message pops up when the app is started. I am using a Gateway to connect to my SQL Server 2012.

dgsonic
Level: Powered On

Re: Unknown Mashup Exception

Yep, same scenario.. I'm using the Gateway to communicate to my on premise SQL 2012 R2 database. These problems keep coming and going.  I can't use this as a real world production app because of these ongoing connection problems.  They appear without me touching the app.

 

Dgsonic

Anonymous
Not applicable

Re: Unknown Mashup Exception

Same problem with me.  My PowerApps was working fine, connecting to an on-prem SQL Server.  It has been working fine for a week but now it doesn't.  Help!!!

Highlighted
dgsonic
Level: Powered On

Re: Unknown Mashup Exception

Has anybody else got a resolution for this problem so far.  I tried creating a NEW app connecting to a completely new table using the gateway to onPremise SQL connection and getting the same "Unknown Mashup Exception". So now I know it's not my existing table. It's the Gateway to SQL Azure having a problem.

 

Dgsonic

Anonymous
Not applicable

Re: Unknown Mashup Exception

Same experience for me.  New apps using on-prem datasource will not work.  Microsoft can you help?  Please fix!?  Production down! 

Rapha222
Level: Powered On

Re: Unknown Mashup Exception

Same experience for me as well! And I agree that production is down... there is no connection with SQL Server... !

ssjohnson
Level: Powered On

Re: Unknown Mashup Exception

I just created a simple PowerApp using a gateway to SQL Server 2014 and I am also getting the error.  If I find a solution, I'll share.

Anonymous
Not applicable

Re: Unknown Mashup Exception

Does Microsoft monitor this forum, or do we need to call them and tell them that they have a Production Platform down? 

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,980)