Updating multi-tenancy fields on forms for delta data records
After the multi-tenancy update utility successfully runs against all of the forms in all of your installed applications, you must migrate the delta data from your production server to your staging server. After you migrate the delta data, you must run the multi-tenancy updates against the migrated delta data.
Depending on the volume of data, BMC recommends that you run the multi-tenancy utility after every delta data migration.
Depending on the size of your database, an upgrade on the staging server can take an extended period of time, perhaps days. While the applications and data on the staging server are being updated, your production server will continue to acquire new data. This new data is the delta data, which eventually must also be moved to the staging server and updated with the multi-tenancy model changes.
Depending on the extent of your environment, you might need to process migrated delta data iteratively until the production server and the staging server are synchronized, at which point you can move your staging server into production.
After you migrate the delta data, return to to the Application Maintenance console to prepare the staging server for applying the multi-tenancy updates.
Before you start this procedure, the following tasks must be successful:
- You completed the upgrade.
- You ran the multi-tenancy update utility with no errors.
- You completed the delta data migration.
You use the Maintenance Group field in the Application Maintenance console to select the type of maintenance work that the console manages. For the multi-tenancy update, select Multi-Tenancy only.
From the Home page Applications list, select Administrator console > Application Administration console. Log on to the BMC Remedy ITSM application as an administrator.
- Click the Custom Configuration tab.
Select Foundation > Advanced Options > Application Maintenance console, and then click Open.
The Application Maintenance console opens, as shown in the following figure:
- In the Maintenance Group field, select Multi-Tenancy.
- In the View By field, select All Products, and then click Refresh.
- Review the Status of the records in the multi-tenancy update.
- Verify that all records are set to Successful.
- In the Date field on the Application Maintenance console, enter the date of the time when the database backup was taken from the customer's production server.
You must use the Date field for multi-tenancy runs with delta data migration to specify the date and time from which the system starts applying the data updates. You select the date and time when the last record was created in your production environment prior to taking the snapshot of the database that you used in your upgrade staging environment. This ensures that the update utility processes only the newer records, that is, those records that were created after the snapshot was taken.
- Click Reset.
The status of all forms, for all installed applications, is reset to Pending.
- Restart the multi-tenancy update process.
- Open the SHARE:Application_Properties form and verify that the new records were successfully created.
If the utility ran successfully, one new record per installed product is created.
You can use the Application Maintenance console to check for the following types of information.
Form currently being processed
Check the Status column in the console table for the form with the status of Executing.
If the update stops running because of a data error, check the Status column in the console table for the form with the status of Fail. This is the record with the data error. Perform your troubleshooting diagnosis on this form.
Number of records to process for a given form
Click Refresh Counts and then, in the console table, check the number in the Records to Update column of the form that has the status of Executing.
Forms already processed
Check the Status column in the console table for forms with the status of Successful.
Forms waiting to be processed
Check the Status column in the console table for forms with the status of Pending.
For a description of the columns and other UI controls, see Application Maintenance console description.