The lookup cache file with the named prefix <prefix name> used by the Lookup transformation <Lookup transformation name> cannot be reused.
You attempted to use a persistent lookup cache that was incompatible with the Lookup transformation, and the Integration Service does not delete the lookup cache files when you use a named prefix. The lookup cache files can be unusable for the following reasons:
If you change an attribute, such as the database connection in, the persistent cache may become incompatible with the Lookup transformation.
If more than one session uses the same lookup cache name, the lookup cache may be incompatible with a Lookup transformation in one of the sessions. For example, if you modify the attributes in one session, but you do not modify the second session, the lookup cache becomes unusable for the second session.
You upgraded the Integration Service. The format for information in the Lookup transformation in the upgraded version of the Integration Service is incompatible with the format of information in the cache file that was created by an earlier version of the Integration Service.
Update the Lookup transformation attributes, or remove the existing lookup cache files. You must remove both the
.
idx and .dat files. This allows the Integration Service to create a lookup cache.