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 the Fail status and executes all pending forms even if a form update fails.
The multi-tenancy update utility stops running when a form is moved to the Fail status.
In most cases, you can determine the cause of the failure by reviewing either the Filter log or the SQL log on the BMC Remedy AR System server. After determining and correcting the cause of the failure by reviewing either the Filter log or the SQL log on the BMC Remedy AR System server, you need to restart the update utility. The following procedure describes a best practice method for investigating a failed form:
- On the BMC Remedy AR System server, .
- Open the Application Maintenance console.
- On the IT Home page, click the Application Administration Console link.
- Click on the Custom Configuration tab.
- Expand the Foundation list.
- Expand Advanced Options list.
- Click on 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.
To do this:
- In the Application Maintenance console table, select the record with the Fail status.
Click Reset to Pending.
The Reset to Pending button is only available 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 the Fail status and the processing stops.
- Review the filter and SQL logs to determine 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.
- Restart the multi-tenancy update utility manually. For troubleshooting see: .