Troubleshoot: idresgen utility

Administer > Transforming, loading, and extracting data > Overview of the mass load utilities > Resolve identifiers

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

Related concepts

Overview of the mass load utilities

Related tasks

Configure the idresgen utility
Specify a properties file with the idresgen utility
Create an XML file to use internal-alias ID resolution
Create an XML file to use unique-index ID resolution

Related reference

idresgen utility

+
Search Tips | Advanced Search

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.