Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Issue

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

Cause

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

Steps for Recovering the Application

1) Force Admin App's First-Time Setup

On this step, we need to clear all the data records created during first time setup.

  1. Please make sure to stop ODS API and Admin App websites under IIS or within the Azure portal.

Ex (in Azure):  EdFiOdsApiWebSite-{environment}-{resourceGroupid}

      EdFiOdsAdminAppWebSite-{environment}-{resourceGroupid}

      2. Connect to SQL Server on SSMS or use Azure Query Editor

3. Select the EdFi_Admin database.

4. Execute the following sql commands for clearing all the data records created during first time setup process.

SQL
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

5.) Please start the ODS API and Admin App websites under IIS or within the Azure portal once the SQL commands executed successfully.

2) Update Admin App web site on IIS or Azure

Note: That older versions of Admin app need the presence of “SetupRequired.txt” 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.

To create this file just create text file with the name “SetupRequired.txt” and set the content of it to: Placeholder file to let the AdminApp know additional setup of the system is required.

On IIS or 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 within Admin App.

Deployed pages and resources can be accessed on Azure portal.

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

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



  • No labels