Troubleshooting: ID Resolver

If errors occur while resolving identifiers, refer to the following table:

Error Method Used Possible Cause Possible Solution
Unresolved
primary key
All The ID Resolver does not resolve the primary key (identifier) in a table that is not specified in either the KEYS or SUBKEYS table. Add the name of the table for which the primary key is to be resolved to the SUBKEYS table before running the ID Resolver.
Update The primary key is resolved by querying the database. The database query is generated by using either the properties-file entry information or the unique index for the given table. The properties-file entry has priority. Make sure that the unique-index information in the input file is correct.

You may also want to create or modify the appropriate entry in the properties file to generate the appropriate database query to resolve the primary key.

Unresolved
foreign key
All The ID Resolver does not resolve the foreign key in a table where the foreign references are to tables that are not specified in either the KEYS or SUBKEYS table. Add the name of the table referenced to the SUBKEYS table before running the ID Resolver.

In addition, make sure that the foreign-key relationship exists in the database schema.

A foreign key is resolved by using the internal alias or by querying the database. The database query is made only if the internal alias fails to resolve the foreign key. The internal alias is generated by using the primary key and by using the properties-file entry. Make sure that the internal-alias values used as source and target in the input file are correct.
The database query is generated by using either the properties-file entry information or the unique index for the given table. The properties-file entry has priority. Make sure that the unique-index information in the input file is correct.

You may also want to create or modify the appropriate entry in the properties file to generate the appropriate database query to resolve the primary key.

Feedback