Page Comparison

...

The application deployed and First-time Time setup was successful. But , however unable to proceed further with the Admin App settings page.

...

Admin App secret configuration , azure sql and/or Azure SQL configuration values became corrupted for whatever reason.

Steps for Recovering the Application

...

BEGIN TRAN   
DECLARE @ApplicationId INT;

SELECT @ApplicationId = ApplicationId FROM dbo.Applications WHERE ApplicationName = 'Ed-Fi ODS Admin App'    

DELETE FROM dbo.ClientAccessTokens WHERE EXISTS (
        SELECT 1 FROM dbo.ApiClients
        WHERE ClientAccessTokens.ApiClient_ApiClientId = ApiClients.ApiClientId
        AND Application_ApplicationId = @ApplicationId 
) 

    DELETE FROM dbo.ApiClients WHERE Application_ApplicationId = @ApplicationId
    DELETE FROM dbo.ApplicationEducationOrganizations WHERE Application_ApplicationId = @ApplicationId
    DELETE FROM dbo.ProfileApplications WHERE Application_ApplicationId = @ApplicationId
    DELETE FROM dbo.Applications WHERE ApplicationId = @ApplicationId
    DELETE FROM dbo.OdsInstances
    DELETE FROM adminapp.SecretConfigurations
COMMIT  TRAN

References

If you have any questions on how to connect to the EdFi-Admin database please refer to this articles below:

...

https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-ssms

2) Update/Re-deploy just Admin app on Azure

...

https://www.gslab.com/blogs/kudu-azure-web-app

Note: That older versions of Admin app need the presence of “SetupRequired” file. This indicates to the first time setup process that it has not run. If the file not present, this means that the first-time setup was completed. Recreating the file will enforce the First time setup process to run again.

...

On Azure proceed to restart the application. Once the restart has finished use your web browser and navigate to the Admin App URL. You should be able to continue the First time setup.

References

If you have any questions on how to connect to the EdFi-Admin database please refer to this articles below:

https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-portal

https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-ssms