Answered

Error: An unknown error occurred

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Through PowerApps studio the form persisting through the Azure SQL database works however when downloading the App to my iPhone and trying through there I get this Error: An unknown error occurred

Session ID: 2c90b5f5-2bb6-c213-a56b-814b566406d1

Anyone help me out with whats going on?

Cheers

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

AndyPennell Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I am not an expert in SQL, but I see many errors like these in that session:

"message": "Error calling url: https://australia<redacted>.net/apim/sql/<redacted>/items/2",
"eventType": "Error",
"error": "{\"status\":400,\"message\":\"The UPDATE statement conflicted with the FOREIGN KEY constraint \\\"FK_DelayCode_DelayCode\\\". The conflict occurred in database \\\"gemma\\\", table \\\"dbo.DelayCode\\\", column 'DelayCode'.\\r\\n inner exception: Microsoft SQL: The UPDATE statement conflicted with the FOREIGN KEY constraint \\\"FK_DelayCode_DelayCode\\\". The conflict occurred in database \\\"gemma\\\", table \\\"dbo.DelayCode\\\", column 'DelayCode'.\",\"source\":\"sqlconnectionprovider-australiaeast.<redacted>\"}\r\nStack:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AndyPennell,

Not sure if the errors are ordered by timestamp but that could have been from a earlier in the session.

So is there a webpage that I can plug my sessionId in and get a logfile?

Or alternatively is there someway the powerapp can see the stacktrace. I understand the purpose of the generic "Error: An unknown error occurred" but underlying there should be a way to see more....

Cheers
J

Was this reply helpful? Yes No
AndyPennell Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The analytics data I grok from your session ID is only available to engineers on the team.

I took another look at your session and all but one of the errors I see where of the form I posted earlier (complaints about keys). The only other error was a "Canceled" error which occurred during the enumeration of the app list.

Suggest trying to repro again and post another session id.

Was this reply helpful? Yes No