Troubleshooting: idresgen utility

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

The following table shows common errors when using the idresgen utility. The table also describes possible causes and solutions.
Error Method Used Possible Cause Possible Solution
Unresolved primary key All The idresgen utility 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 idresgen utility.
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 idresgen utility 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 idresgen utility.

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.
New data does not reference keys that exist in the database update or mixed Existing database data to be referenced was not part of XML file. Extract records that new data refers to and include in XML before the new data.

Rerun idresgen utility using the mixed method.