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

An Unknown Error Occured.. Problems again with Azure SQL

Powerapps is really struggling again with random "An Error Occurred on the server".

 

Anyone else having problems? The app was working perfectly a few days ago, then it started to slow down and now it randomly giving the "An Unknown Error Occured". 

 

This is happening far too often now!!!

 

 

17 REPLIES 17
Community Support Team
Community Support Team

Re: An Unknown Error Occured.. Problems again with Azure SQL

Hi @t19670,

Could you please share more details about the error message within your app?

Please take a try to re-create a new connection from your app to the Azure SQL table, then run your app again, check if the issue is solved.

In addition, please also take a try to turn off/disable the "Explicit column selection" option and "Delayed load" option within Advanced settings of App settings, then check if the issue is solved.

If the issue still exists, please take a try to re-create your app, check if the issue still exists.

 

Best regards,

Kris

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
t19670
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

Hi Kris,

I have turn all settings in advanced settings now and check a few things in my app. I have republished it. I will update you on how it’s holding up soon.

I have already shared my session if and screenshots with Microsoft support.

Thanks
t19670
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

Hi Kris,

 

No joy with the errors, still getting the same random errors. I have reconnected the data sources, turned all experimental features off.

App works in preview mode in studio and then when I publish the app works for an hour or so then the errors start again. 

 

Connection is to SQL database. Had these issues before and never had an explanation of why this keeps happening. 

 

I can send session ID if needed.

 

 

saimarasheed1
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

I am having the same issue. i deleted my PowerApps client from my ipad


@t19670 wrote:

Powerapps is really struggling again with random "An Error Occurred on the server".

 

Anyone else having problems? The app was working perfectly a few days ago, then it started to slow down and now it randomly giving the "An Unknown Error Occured". 

 

This is happening far too often now!!!

 

 



and reinstalled it. it was working fine for few entries but when i went offline and came back online. its not refreshing my databse gallery. I even tried adding a refresh button but keeps saying "An unknown error occured". 


@t19670 wrote:

Powerapps is really struggling again with random "An Error Occurred on the server".

 

Anyone else having problems? The app was working perfectly a few days ago, then it started to slow down and now it randomly giving the "An Unknown Error Occured". 

 

This is happening far too often now!!!

 

 


 

amchern
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

Hi,

 

I work on the Product Group for PowerApps. Could you please provide a session Id for when this specific error occurs? If you go into the left panel of the home page, there should be a panel that says "Session Id". This will allow us to further investigate this issue.

 

Thanks,

Amy

saimarasheed1
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

Hi Amy,

 

Thanks for the quick response.

Please see the details below

 

Session ID: 9fcbe52b-00dd-411e-ac06-d68f27da49e3
PowerApps 3.18105.18

amchern
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

It doesn't look like the session you provided encountered the "unknown error occurred" issue. Could you try sending a new session Id?

 

Thanks,

Amy

t19670
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

Hi Amy,

I am in contact with MINDTREE and this issue still hasn’t been resolved. The support team at mindtree have said they have reached out to the product team, not sure if that is the same team you are in, and the last contact I had was 2 days ago, see their answer below...
I don’t have a session Id to hand at moment but it is logged in the ticket below.

Ticket number:
REG:118110919325596

This is a known issue that has been recently fixed.
The fix is deployed in Preview starting (‪11/12‬) and will start deployment to Production by ‪Monday 11/19‬
We will let you know once we hear from them. Will keep you posted.
Thanks for your patience and cooperation.
Apologize for the inconvenience caused.


So is this actually fix yet or not and will it be fixed on 11/19/2018.

They have had this ticket now for over a week.

This is far too slow and my users are really angry now.

Could we please have a proper explanation this time on why this keeps happening?
I’m starting to think think Microsoft don’t want us to use SQL databases with powerapps!

 
nbarsley1
Level: Powered On

Re: An Unknown Error Occured.. Problems again with Azure SQL

We also are experiencing major issues connecting to Azure. 

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

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

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 461 members 4,519 guests
Recent signins:
Please welcome our newest community members: