The UpdateDBSearchIndex task is used to update the ERP search index if ERP data has changed. The update is performed incrementally with the help of the LOGTABLE. An additional column must be created so that the LOGTABLE can be used for both V11 and V12.

This can be done using database software, for example. The name of the column is UPDSEARCH_V12. It is important that it is assigned a default value of 1.

Example SQL-Statement to add the column:

ALTER TABLE LOGTABLE ADD UPDSEARCH_V12 smallint default 1 not null

The name of the column must be entered in the plinkcommon.cfg in the Common block under the LOGTABLE_UPDSEARCH_FIELD key.

In addition, the UpdateDBSearchIndex task must be configured in the plinkcommon.cfg. The OnCatalogChanged trigger must be added to the TimeTable.

In addition, the generation of the CommonErpIndex should be deactivated. This index is used for the geometric search when preferred rows are switched on. As the same index is used here in V11 and V12, it does not need to be generated again in V12. The index is located in the common subdirectory.

It is also important that the AppServer has access to the database and that Autologin is activated for the AppServer. To do this, a configuration must be assigned to the user under which the AppServer is running.

Here in the example the configuration demo.

This configuration must in turn be assigned the username (User ) and password (Password ) for automatic login [Automatic login] to the database.