Database Import: Operation Failure

If all goes well, the import will complete without any errors. However, there are several reasons why an import could fail. The most common error conditions are listed below:

  • Attempting to append a record that already exists in the destination table (primary key or unique constraint violation)
  • Attempting to append a record that violates referential integrity, e.g. attempting to insert a sample record for a drillhole that has no collar record (foreign key constraint)
  • Failing to supply values for columns that do not allow null (blank) values
  • Attempting to store a value that violates column constraints (e.g. a number that falls outside the limits of a specified numeric range)
  • Data conversion errors (e.g. text characters in a numeric field, invalid date formats, etc.)

When an error occurs, an error dialog is displayed which shows error information returned by the database server, along with details pertaining to the record that caused the error.

At this stage you can decide whether or not to abort the process. If you abort the process, changes may or may not be rolled back, depending on the transaction buffer settings. If you choose to continue, all offending records will be rejected.

Adhoc Import Tool