09-21-2017 09:23 AM
Good morning. I woke up to a few emails from users telling me that there's a random error.
When I log into any of my 5 apps, I get an error that states " An error occured on the server".
Everything appears to be functioning, however, when I'm in the studio and try to do a data refresh on my Azure SQL Db, the PA Editor gives me the error "Try Again. Please see attached photo.
I've checked the username and password and I am able to connect to the SQL db in both Excel and Visual Studio. All other connections (SharePoint, Office 365, OneDrive) are not affected. What would cause this?
Solved! Go to Solution.
09-22-2017 06:43 AM
Our app seemed to start functioning again after simply re-publishing it. Not sure if that triggered something on the data connectors or what happened, but as soon as I re-published both web and mobile work.
09-25-2017 02:03 AM
09-25-2017 06:41 AM
You were saying that the issues should've been fixed, but I still have users experiencing these problems.
2 users on 2 different apps - one app uses Azure SQL connection, one app uses on-premise SQL connection (through gateway) - both get 'An error occurred on the server'
Having a look at the network trace they both get 404 for the same 3 URLs:
With one of the users I have tried to connect to the other affected app and when it gets prompted to create the on-prem SQL connection it gets the following error:
Is anyone able to investigate this? Is this caused by the previous problem? It all seems to be very unstable after the latest update.
09-25-2017 06:57 AM - edited 09-25-2017 06:58 AM
I have actually also started to receive this same error from time to time on SQL Server connection.
All it says is that Error Occurred on Server. The only solution I have found is to tell my users is to reload the app.
09-25-2017 06:59 AM
Refreshing doesn't always fixes it. The user reported that from what he tried it is like 1 in 6 refreshes that it actually works... which is not acceptable for a live application used across the business.