Log file errors

Errors in the data import process are written to the log file that you set up when you created your import configuration. For more information, see Creating import configurations.

If an error occurs, the import stops and an error message appears. After you have rectified the problem, you can restart the data import.

Some error messages are detailed below:

Error

Solution

You have not mapped or given a default value to <fieldname> which is mandatory and therefore requires a value.

Ensure that mandatory fields are mapped or have a default value.

One of the Business Objects could not import because of a missing Title value which is mandatory.

Ensure that mandatory fields are mapped or have a default value.

String or binary data would be truncated. The statement has been terminated.

The field into which you are importing data is not big enough to contain the entire string.

Cannot insert duplicate key row in object 'tps_user' with unique index 'index$tps_user$name'. The statement has been terminated.

This typically occurs when the record you are trying to import has the same user name as a record that is either Soft Deleted or in a different sub class.

Ensure that there is no replication of user types by changing your name field, or applying a filter to remove replicated names.

Note: When you view objects on the screen, you usually see the TITLE field (not the NAME field) and this does not have to be unique.