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

All the sudden this error shows up - on-premises SQL server

2017-02-09_21-17-27.png

 

After a week working on PowerApps application on my PC connected to on-premises SQL server (a VM with Windows Server 2016), everything was fine and then all the sudden got the error while setting some fields on the form: "Failed to load [dbo].[tablename]. An error occurred on the server. Server response: Unknown Mashup Exception. inner exception: Column 'ProviderSpecificDataType' does not belong to table." 

Tried to isolated the problem, so I created a new database with only one table/one row/primary key ID - pwWelcomeNote, re-install the gateway, and still got the error. I am using a most update Windows 10 and SQL Server 2016 Standard Edition.

Tried rebooting both machine, no luck. Any ideas? 

Thanks in advance...

1 ACCEPTED SOLUTION

Accepted Solutions
marcosh
Level: Powered On

Re: All the sudden this error shows up - on-premises SQL server

It's back!! Up and running! Thank you PowerApps team!!!

View solution in original post

6 REPLIES 6
Rapha222
Level: Powered On

Re: All the sudden this error shows up - on-premises SQL server

Hi Marcosh,

 

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. My environment is quite similar, the only diference is that my SQL Server is 2008 (Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)).

 

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.

 

 

marcosh
Level: Powered On

Re: All the sudden this error shows up - on-premises SQL server

Thanks Rapha, I am glad to know I am not the only one. The funny thing is the PowerApps>Support says: "No known issues: PowerApps is running smoothly!". As a workaround, I was thinking in create an excel file connected to SQL server, and link the PowerApps app to the excel file. Haven't tried though...

Rapha222
Level: Powered On

Re: All the sudden this error shows up - on-premises SQL server

"PowerApps is running smoothly" Smiley LOL Smiley Frustrated Smiley Frustrated Smiley Frustrated

 

I'm debugging the Gateway, but without success... I discover other person that started to suffer the same error:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Unknown-Mashup-Exception/m-p/21764#U21764

 

I'm starting to figure out a workaroud as well... please, tell me if you obtain success using the "excel gateway".

 

I tried to create new applications and I tested gateway from other computers without success... just the same error...

 

Good luck

marcosh
Level: Powered On

Re: All the sudden this error shows up - on-premises SQL server

Connecting PowerApps to excel that is connected to SQL server did not work, I had to do another workaround. It's like Inception movie, dream within another dream.. 

 

Here is what I did:

1. Create an excel worksheet (Sheet1) that is connected to SQL server (Data tab)

2. Create a new worksheet (Sheet2) that copies every single cells from Sheet1. (formula: +Sheet1!A1, this copy the content of the cell A1 from Sheet1 to Sheet2, then just copy the formula to all other cells of Sheet2)

3. Format Sheet 2 as a table (Home tab)

4. Link PowerApps to Sheet2 as a new data source

5. To refresh the data, just Refresh Sheet1 and refresh PowerApps

 

I know it's a little bit of work, but at least it will keep me going while waiting for PowerApps team fix the issue.

 

 

Rapha222
Level: Powered On

Re: All the sudden this error shows up - on-premises SQL server

jajajajajajajajajajaja Inception!

 

I just did a litle test conecting a new App to Google Drive "Worksheet" and it works fine in the firsts tests. In my case, I'm thinking this can be the best solution for some tests that I'm doing in the tool PowerApps. But it's really a temporary solution... In order to effectevely use PowerApps here (production environment) I need to connect it on my SQL Server instance... without it PowerApps can't be used here...

 

I've sent a message to Microsoft Support team about the problem, but I didn't have any answer... 

marcosh
Level: Powered On

Re: All the sudden this error shows up - on-premises SQL server

It's back!! Up and running! Thank you PowerApps team!!!

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,300)