Database maintenance plan fails due to locked objects
Article # 3030702 - Page views: 167
Issue
When a database maintenance plan is run, it fails due to locked objects in the database.
Cause
The INVOICES database maintenance plan requires exclusive access to the database. Any modules that are open or services that are running must exit the program before the maintenance plan can run.
Solution
Please ensure that all INVOICES modules are closed and services are stopped before the maintenance plan is run.
Alternatively, you can enable an INI file setting to force the maintenance plan to run even though there are locked objects. In the EIGLOBAL.ini file's [Options] section, add and/or update the following entry and value: AllowMaintenanceOnLockedObjects=1.
Please see the INI help article in the reference section for more details.
Level of Complexity
Moderate
Applies to
| Product | Version | Build | Environment | Hardware |
|---|---|---|---|---|
| INVOICES | All |