Getting error on Azure Orchestrator URL home page - An unknown error has occurred. (#200)

[prince.rastogi]

we upgraded our database on test setup (App Running on VM and DB running on Azure SQL Server) and then copied that upgraded database to new prod setup (here everything running as PaaS on Azure). When I am trying to browse Orchestrator URL then I am getting error - “An unknown error has occurred. (#200)”. In URL it show - errorCode=unauthorized_client.

image|558x293

Are we missing something?

[prince.rastogi]

More details:

We have upgraded DB from 2019 to 2020 version and It included something related to identity data. Identity Data on App Setting and Web config looks like different in both setup and we moved database from one setup to another. That is why we are facing issues.

Now what I am looking for: Steps to Move database (on version 20.10.7) from one setup to another which can handle Identity data in those steps.

[Pablito (Pawel Wozniak)]

Hi @prince.rastogi,
Please contact our Technical Support that is dedicated to the Enterprise customers. It is really hard to figure out what might cause an issue where we don’t have a possibility to check your environment.

[codemonkee (Tim)]

I happened to revisit this issue today and found that the identity.ClientRedirectUris table in the database needs to have the correct Redirect Uris referenced to the Orchestrator Client ID.

Orchestrator installation on 2 servers

I happened to revisit this today randomly and for some reason it just clicked when I thought about what it might be… The symptom was Load-balanced URL and the Primary Node would successfully redirect to the Identity Service using the Load-balanced URL and after authenticating it would redirect back to the original requested address. However, any other URL would fail when it redirected to the Identity Service and throw an Error. Web UI: An unknown error has occurred. (#200) and in Event Viewer…