Import Error Guidance

When an import job reports an import error, Reconcilor records an error type and message to help identify the issue. Import errors usually indicate a problem with the source, connection, configuration, mapping, permissions or import framework.

Use the table below to interpret these messages and determine any required action. Some issues can be resolved locally – such as checking file paths or correcting parameters – while others require assistance from your site administrator or Datamine Support.

Import Error Type	Error Message	Meaning
SourceConnectionError	An error has occurred while connecting to the import source.	Reconcilor could not connect to the system or file where the data originates – for example, a fleet management database or network location. Check network access, credentials, or source availability.
DestinationConnectionError	An error has occurred while connecting to the import destination.	The connection to the Reconcilor database failed during import. This usually points to network or database service issues.
InvalidDataSource	The data source defined is invalid.	The import refers to a data source that does not exist or has not been configured correctly in Reconcilor. Check the import definition settings.
InvalidParameters	The set of parameter values supplied is invalid.	One or more parameters used in the import setup – for example, date range, file path, or ID – are missing or incorrect. Review import configuration inputs.
DataReadingError	An error has occurred while reading data from the source.	Reconcilor could connect to the source but was unable to read the data – this may indicate a file format problem, permission issue, or corrupted data.
ConfigurationError	A configuration error has been encountered.	There is an issue with how the import is set up – possibly incorrect mapping, schema mismatch, or a missing configuration file.
UnexpectedError	The import framework has encountered an unexpected error.	A generic system error occurred that does not fit another category. Check logs for more details or contact support.
StatisticsSaveError	An error has occurred while saving import job statistics.	The data imported successfully, but Reconcilor could not record import metrics or job statistics. This is typically non-critical but should be checked by an administrator.
SourceToStagingReadWriterError	An error has occurred while copying data to import tables.	Data was read from the source but failed to transfer into Reconcilor’s staging tables – often due to schema mismatch or data type issues.
SourceSchemaRetrievalError	An error has occurred while retrieving information about the source schema.	Reconcilor could not read the structure – tables and fields – of the source system. Check permissions or confirm that the source database is accessible.
SourceDetailRetrievalError	An error has occurred while retrieving information about the import source.	The import process could not obtain detailed metadata or configuration for the source system.
ProductImportError	An error has occurred during product import logic.	A site-specific or module-specific import failed while applying business logic – for example, processing plant product data.
MappingRevisionConfigurationError	A mapping revision configuration error has been encountered.	The import’s mapping rules – how fields in the source correspond to Reconcilor tables – are out of date or misconfigured. Check Import Revisions for details.
DestinationStagingSchemaPreparationError	An error has occurred while preparing the destination schema and scripts.	Reconcilor could not prepare the staging tables or scripts needed for data transfer – possibly due to missing permissions or schema mismatch.
DestinationStagingQueryError	An error has occurred while running staging queries in the destination.	A SQL or script error occurred while loading data into staging tables. Review query logs to identify the invalid statement.
DestinationStagingError	An error has occurred during the data staging phase.	A general failure occurred during staging – the intermediate step where data is transformed before being written into the database.
DestinationSchemaCreationError	An error has occurred while creating the destination schema for data transfer.	Reconcilor could not create or access the schema where imported data should be stored. Check database permissions and storage configuration.
ImportSourceFinalisationError	An error has occurred while completing processing of an import source after data has been read.	The data was imported successfully but Reconcilor encountered an issue during the finalisation stage – for example, updating metadata or status.
CustomImportError	An error has occurred while performing custom import logic.	A customised or site-specific import process failed. Review site-level scripts or custom logic settings.
PermissionsErrorSource	A permissions error has been encountered while attempting to read from the data source.	The user or system account used for the import does not have permission to access the source file or database. Check access rights.
ProductImportDeadlockError	The import job failed to complete due to a deadlock.	Two or more processes tried to update the same data simultaneously, which caused a database lock. Retry the import after other jobs complete.