Troubleshoot: idresgen utility

Troubleshoot: idresgen utility

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

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. Verify 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. Verify 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. Verify 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.

Related concepts

Loading utilities

Related tasks

Configure the idresgen utility
Specifying a properties file with the idresgen utility
Use internal-alias ID resolution
Use unique-index ID resolution
Related reference

idresgen utility

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.	Verify 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.	Verify 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.	Verify 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.