Kourier Integrator Administration - Fixing Corrupt Indexes
According to the U2 documentation, if index corruption is found, the
best practice is to delete the index with the
DELETE.INDEX filename ALL command, and then to recreate the
indexes. Because Kourier Net Change leverages the Index functionality to update
files outside of your system's base files, the proper procedure would be the
following:
- Use the command LIST.INDEX filename
to get the list of indexed fields
- Remove the U2 file indexes with the command
DELETE.INDEX filename ALL
- Create new U2 file indexes for the indexed fields found earlier with the LIST.INDEX command. See the
U2 documentation for the CREATE.INDEX
command. Do not try to create the index for KCL_INDEX.
- Create the Kourier Net Change index by executing the following commands
from TCL:
: SELECT KT_EXPORTS
WITH F15 = "filename"
> KT.SETUPNETCHG
- Build the new indexes with the TCL command BUILD.INDEX
filename ALL
- Run a Kourier Service for all affected Exports in Full Refresh mode.
See Also
Kourier Integrator Setup and Administration
Guide
Kourier TCL Commands