cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcosh
Regular Visitor

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

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

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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.

 

 

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...

Anonymous
Not applicable

"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

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.

 

 

Anonymous
Not applicable

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... 

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

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,186)