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

SQL problem yet again!!!

Powerapps connection to Azure SQL database is playing up again. This is a regular monthly occurance. 

Last month we couldn't connect at all now it is so slow it take minutes to save or retrieve records. Again after a powerapps update!!

 

Now I'll wait for...give me your Session ID then 5 days of support emails without a resolution for 2 weeks...

Whilst user have to put up with it!

 

SESSION ID : 1d8270c1-3fb6-4997-8e30-b159be8e00651

 

Come on Microsoft this is pathetic now! 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
katwan
Level: Powered On

Re: SQL problem yet again!!!

Hello all,

 

This issue should be mitigated. We fixed some configuration changes in Sql connector. Please try again and let us know if the issue persists.

 

Thanks,

...Katrina

22 REPLIES 22
mogulman
Level 8

Re: SQL problem yet again!!!

This is very concerning.  I'm currently developing an app with SQL Server using the data gateway.  I plan to migrate it to Azure SQL DB.  I'm doing it this way since I'm using SQL Profiler to understand PowerApps and to optimize performance.  I'm not seeing performance issues using this approach.  I've had to clear the browser cache on occasion to get things working properly.  What devices are you using to run your app?  I use Edge generally and Chrome oocassionally.

 

You could try testing app by migrating app using an on-premise SQL Server and the data gateway.  It works with SQL Server Express (free).   

 

Keep us posted on your progress. 

PowerApps Staff sridutt
PowerApps Staff

Re: SQL problem yet again!!!

@t19670 Thanks for reporting issue. We identified rootcause and working on resolution. This issue impacted one of Northern Europe data centers due to spike in usage, we will keep you posted once mitigated.

PowerApps Staff sridutt
PowerApps Staff

Re: SQL problem yet again!!!

This issue is mitigated now, we will monitor over weekend and next week to ensure that thing are looking good. Please let us know if you are still facing any issues.

t19670
Level: Powered On

Re: SQL problem yet again!!!

Hi, thanks for the reply. Yes the issue has resolved.
Although, can I ask why this keeps happening on a regular basis? This has happened numerous times with Azure SQL connections.
PowerApps Staff sridutt
PowerApps Staff

Re: SQL problem yet again!!!

@t19670, Glad that Issues is resolved for you. After we do discuss prevention steps internally, I can share details of steps taken to prevent this from happening again .

t19670
Level: Powered On

Re: SQL problem yet again!!!

Spoke to soon.... ARRRRGGHHH this is unbelievable!

It seems this morning SQL views are not working correctly with mulitple filters! 

This is system wide, please see seesion ID and errors from one of our devices below.

The SQL view isn't working when I have a boolean filter applied if I remove it it works. Although this has been working since March 2018 and now it suddenly breaks!!

 

PLEASE fix this URGENTLY! 

 

When trying to retrieve a sql view, the error meesage is:

 

The specified record was not found.

Server response: Invalid Column name 'True'.

clientrequestID: b40d0514-6202-4c2c-b36d-b1ff3d0653df

 

Session ID: 8befdc5a-feda-46ea-9a89-d29068c8ad66

 

Should I start another thread.

 

Meneghino
Level 10

Re: SQL problem yet again!!!

We are also having major problems with PowerApps connecting to Azure SQL Server this morning!

Please let us know what is happening!!

We are in the central European zone.

PaulSa
Level: Power Up

Re: SQL problem yet again!!!

I also have an issue with boolean type:

Filter([myTable], column1=false) do not work this morning

I had to change it to Filter([myTable], column1=0). We lost the benefit of delegative query...

OneThing
Level 8

Re: SQL problem yet again!!!

One More to the List. European. Filters no longer work Based in Europe.

 

ETA for a fix?

 

 

 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 140 members 3,930 guests
Please welcome our newest community members: