Troubleshooting the multi-tenancy update
If the multi-tenancy update utility encounters a condition that prevents it from finishing the updates to a form and its associated data, it moves the form to Fail status and stops running. The update utility will not process the remaining Pending forms until the condition that caused the update to fail is corrected and the updates are applied to the failed form and its data.
If a form fails, you must investigate why the multi-tenancy update utility stopped running and correct the problem. In most cases, you can determine the cause of the failure by reviewing either the or the on the BMC Remedy AR System server. After you correct the problem, you must restart the update utility.
The following procedure describes a best practice method for investigating a failed form.
To troubleshoot the multi-tenancy update
- On the BMC Remedy AR System server,
- Open the Application Maintenance console.
- Find the entry in the Application Maintenance console with the status of Fail, as described in Investigating multi-tenancy update processing issues, then reset the status of the record to Pending:
- In the Application Maintenance console table, select the record with Fail status.
Click Reset to Pending.
The Reset to Pending button is available only when the selected record is in the Fail status.
- On the Application Maintenance console, click Run to start the multi-tenancy update workflow on the record that you reset.
When the workflow finishes running against the selected record, the record returns to Fail status and processing stops.
- Review the filter and SQL logs to find and then fix the cause of the failure.
- After you fix the problem, repeat steps 3 through 5 until the update completes with a status of Successful.
- Turn off filter and SQL logging.
- Manually restart the multi-tenancy update utility.