Post-Upgrade Procedures

This guide provides instructions on important procedures that should be accomplished after a successful software upgrade. Follow the sequence of the procedures to apply the updates to the Analysis Server setup properly.

1. Redeploy SQL Database. A redeploy in the database schema is necessary since the upgrade might include updates on the data warehouse.

2. Redeploy OLAP Database. A redeploy in the SQL Server Analysis Services database is necessary since the upgrade might include updates on the OLAP cubes.

Check the Task Scheduler configured command from the previous installation. If there is a customization in the command (e.g., adding /from /to parameters), please follow these instructions to apply it in the orchestrator:

1. Open the file defs.yaml located in C:\Program Files\OpeniT\Analysis Server\Configuration\dagster\defs\sync_data_type

2. Look for the defaults block. Edit the datatypes > arguments, set the value based on this example:

   Example

   defaults:
   	assets:
   		automation:
   		cron: "0 6 * * *"
   		require_upstreams_ready: true
   
   	datatypes:
   		argument: "/from:2022-01-01 /to:20206-12-31"

   Make sure that the value is the same as the previous installation customization.

3. Save the changes.

4. Restart the service Open iT Analysis Server Pipeline.

   

   Analysis Server Pipeline Service

If Labeling (from Factory File) is previously configured, compare the following configuration files from the backed-up installation directory with the upgraded files to apply previously configured modifications:

• openit_product_factoryfile. Use the instructions in Vendor License Labeling File Configuration section to access the file.
• openit_feature_factoryfile. Use the instructions in Feature Labeling File Configuration section to access the file.

If you haven't switched to columnstore before, it is recommended to follow the configurations in the following link to switch to Columnstore Index Type.

• Switching to Columnstore

If Reporting Services is previously configured, it is recommended to follow the instructions in the following link to update the Reporting Services Home Page links.

• Updating Reporting Services Home Page Links

If you skipped the dialog for providing Ingress URI upon upgrade or decided to finally connect the Analysis Server to Ingress, use the following link to manually configure the Analysis Server connection to Ingress.

• Analysis Server Connection to Ingress Manual Configuration

Upgrade Verification

To verify that the upgrade is successful, follow these instructions:

1. Make sure that the analysisserver code location is successfully loaded by following these instructions:

   a. Access the Data Processing GUI by navigating:

   • With Ingress: https://<ingress-uri>/dagster-webserver
   • Without Ingress: http://localhost:27910/dagster-webserver

   b. In the left navigation, click Deployment. Make sure that the Status of analysisserver code location is Loaded.

   

   Analysis Server Code Location

   NOTE

   Click View Error to see the error logs for troubleshooting.

2. Access the Analysis Server web interface and navigate through each of the pages. This is to make sure that the upgrade did not break any page and that the configurations are still present. Choose among the following accessing methods of the web interface that fits your setup:

• Accessing the Web Interface without Ingress

• Accessing the Web Interface through Ingress

  NOTE

  You may experience a delay when trying to access the web interface for the first time after upgrading due to the registration process of Analysis Server with Ingress.

2. Run the scheduled job in the Task Scheduler and check the logs to see if errors are encountered. This is to make sure that the process will run successfully in future executions. Refer to the instructions in the Running the Scheduled Job in Task Scheduler section.