Update indexes

Infor e-Commerce maintains several indexes of information stored in the Infor e-Commerce database. Infor e-Commerce uses these indexes for processing search queries. These indexes must be updated so that they contain the latest information from the Infor e-Commerce database. A certain index may correspond to one or several Infor e-Commerce Interest Centers.

IES indexes are administered through the Application Setup:Lucene LES Indexes page. You can do an Update or Rebuild per index or configure the scheduled job for Lucene indexes, LuceneLES.Index, in the Application Setup:Scheduled Jobs. An update means adding new entries to an index that were not included in a previous update. A rebuild means re-indexing the Infor e-Commerce database tables that are related to the index.

During the installation of Infor e-Commerce, IES database triggers are installed but not activated. These triggers are disabled to improve replication performance when replicating data from M3 BE to the Infor e-Commerce database. If these triggers are enabled, a log table is updated for each data replicated, adding one step to the replication process.

However, if these triggers are disabled even after replication, the log table will not be updated when you add, modify, or delete records from the Infor e-Commerce database. The log table is used when updating indexes. If the log table is not updated, the indexes will then become outdated. You will have to manually rebuild the indexes for them to become up to date.

To enable the database triggers, select Enable Index Triggers in the Lucene IES Indexes page.

The setting mentioned above controls the behavior of the LuceneLES.Index scheduled job. Even if you set the job to run on a schedule, as long as the triggers are disabled, nothing happens. However, if you run a scheduled job manually (by clicking Run on the LuceneLES.Index job in Scheduled Jobs page) and the triggers are disabled, a rebuild is executed and the triggers are set to enabled (succeeding executions will be updates and are run as scheduled). If you run a scheduled job manually and the triggers are enabled, an update is executed.

The Lucene IES Indexes page gives you an overview on the status of indexes and some data on the way Lucene indexes your database, like how many unique terms it has indexed. This page contains a table that lists all the indexes and information for each index.

This table describes each Lucene index.