Preventing content store locking when you add or update numerous schedules

In IBM Cognos Business Intelligence, when numerous schedules are added or updated, the content store database can lock if the schedules contain invalid data. If you experience this problem, you can set an advanced property that validates schedule properties and disables invalid schedules.

About this task

Schedules that contain invalid data can lock the content store database. For example, a schedule can contain invalid user account credentials. If you add or update schedules, and the credential property references invalid user account credentials, Content Manager repeatedly attempts to update invalid schedules without success.

If the emf.schedule.validation.enabled property is set to true, schedule properties such as start date, end date, data types, and user account credentials are validated. Invalid schedules that are encountered are disabled, and details of the disabled schedules are logged in the log files.

The default for this property is false. To enable schedule validation, set the property to true.

Procedure

Follow the steps in the topic, Configuring advanced settings for specific services.
In the list of dispatcher services, select EventManagementService.
For the Environment configuration setting, in the Value column, click Edit.
To add the parameter name, type emf.schedule.validation.enabled.
To add the value, type true.