1. Custom Exception Types
InterchangeExceptions.cs | ExceptionUserServices.cs (codes 300–361)
|
Code |
Exception |
When It Occurs |
|---|---|---|
|
300 |
|
Wrong number of fields in delimited data or the delimiter is missing. Parameters: line number, expected field count, actual field count. |
|
301 |
|
Incoming field value does not match the expected data type. Parameters: line number, field name, expected type, actual value. |
|
302 |
|
Key field query returned more than one matching record. Parameters: field name, field value, line number. |
|
303 |
|
Key field is missing from the import data entirely. |
|
304 |
|
Key field query returned zero records. Parameters: field names, field values, line number. |
|
305 |
|
List field value not found in the configured list. Parameters: value, list name, text field name, table name. |
|
306 |
|
Cannot open the import file (e.g., file is locked by another process such as Excel). Parameters: file name, inner exception. |
|
307 |
|
Field value exceeds the maximum allowed length. Parameters: line number, field name, max length, actual length. |
|
308 |
|
Barcode value was not found in the system. Parameters: barcode, field name. |
|
309 |
|
Parent list value not found for a parent-child list relationship. Parameters: value, parent value text, text field name, table name. |
|
310 |
|
eDoc file specified in the import does not exist at the expected path or is inaccessible. Parameters: file name, path. |
|
311 |
|
Date range value has an incorrect format. Parameters: line number, field name, expected type, separator value, actual value. |
|
360 |
|
Invalid container for the item type during import. Parameters: location plural name, item plural name. |
|
361 |
|
The container type is not permitted to hold the specified item type. Parameters: container item type, item type name. |
2. Additional Custom Exceptions
InterchangeExceptions.cs
|
Exception |
When It Occurs |
|---|---|
|
|
A request with the same identifier already exists in the system. Custom message provided at throw site. |
|
|
The Modify Reason field must be updated when performing Modify or AddModify import types. Custom message provided at throw site. |
3. UI Validation — Execute Interchange
Admin\Interchange\ExecuteInterchange.aspx.cs
|
Resource Key |
Error Message |
When It Occurs |
|---|---|---|
|
|
Please select a valid file type. |
File upload validation fails — unsupported file type selected. |
|
|
Please upload delimited file to be imported first! |
ZIP file validation — no delimited file provided inside the archive. |
|
|
(from resource file) |
No import profile has been selected before attempting to execute. |
|
|
(from resource file) |
File is not ready for import or has not been fully uploaded. |
|
hardcoded |
File to be imported must be uploaded first! |
User attempted to execute import before uploading a file. |
|
|
Importing data has the potential to consume significant resources. As a result, it is recommended that imports be performed during off hours. |
Informational warning displayed before import execution. |
4. UI Validation — FTP / SFTP Imports
Admin\Interchange\FTPImports.aspx.cs
|
Resource Key |
Error Message |
When It Occurs |
|---|---|---|
|
|
A required field is missing |
SFTP profile form submitted with a required field left empty. |
|
hardcoded |
Process Order must be a unique value |
Duplicate process order value entered for an SFTP import profile. |
|
hardcoded |
Profile name must be a unique value |
Duplicate profile name entered for an SFTP import profile. |
|
hardcoded |
Password is required when SSH key authentication is not enabled. |
No password provided and SSH key authentication is disabled. |
|
hardcoded |
There was an error saving the profile - {exception details} |
Unhandled exception while saving the SFTP profile to the database. |
|
hardcoded |
Error generating PGP keys: {exception message} |
PGP key pair generation failed. |
5. UI Validation — Import Log
Admin\Interchange\ImportLog.aspx.cs
|
Error Message |
When It Occurs |
|---|---|
|
{date field label} must be a valid date or isnull, isnotnull, today, tomorrow, yesterday or % |
Invalid date format entered in the import log search filter. |
|
Error deleting all import log files {exception details} |
Database error while attempting to delete import log entries. |
6. Runtime — FTP / SFTP Operations
Interchange\InterchangeService.cs
|
Error Message |
When It Occurs |
|---|---|
|
Error loading FTP security settings: {message} |
FTP security configuration could not be loaded. |
|
Failed to decrypt file {name} - importing encrypted file for profile {profile} |
PGP decryption failed; the system continues by importing the encrypted file as-is. |
|
Error decrypting file {name}: {message} - importing encrypted file for profile {profile} |
PGP decryption threw an exception with details; falls back to encrypted file. |
|
Error deleting file: {name} on sftp site. {exception} |
Could not delete the file from the SFTP server after import completed. |
|
Error renaming file: {name} on sftp site. {exception} |
Post-import rename action failed on the SFTP server. |
|
Error importing file {file} using profile {profile} {exception} |
The main file import operation failed for a specific profile. |
7. Runtime — File Processing
Interchange\InterchangeService.cs
|
Error Message |
When It Occurs |
|---|---|
|
Error deleting import file: {fileName} |
Cleanup of the temporary import file failed after processing. |
|
Error deleting .zip file {file} - {exception} |
Cleanup of a processed ZIP archive failed. |
8. Runtime — Database / Record Operations
Interchange\InterchangeService.cs
|
Error Message |
When It Occurs |
|---|---|
|
Error adding record {rowError} |
Database insert or update failed; the DataTable row error provides specifics. |
|
Error adding record {exception message} |
Database insert or update threw an exception. |
|
No record was identified by barcode {barcode} |
Barcode lookup returned no matching record during cover sheet import. |
|
Error deleting file: {filePath} |
Image file deletion failed during cover sheet import processing. |
|
Error in ProcessCoverSheetImport {full exception} |
General unhandled error in the cover sheet import pipeline. |
|
Error on list import multi-language update {full exception} |
Multi-language list value update failed during import. |
9. Import Log Output Format
Interchange\InterchangeService.cs
|
Template / Value |
Description |
|---|---|
|
Error #{num} Line number {line} had the following error: {message} |
Standard format for each error entry written to the import error log. |
|
ErrorIndicator, LineNumber, ErrorNumber, ErrorMessage, DateTime, TotalErrorCount |
CSV header row used when exporting error logs. |
|
Complete with Errors |
Final status written to the IMPORT_LOG table when the import finishes with one or more error records. |
|
******** Errors in import profile '{name}' *********** |
Section header written to log output before listing errors for a specific profile. |
10. Security / Permission Errors Security
|
Source File |
Action Denied Exception Message |
When It Occurs |
|---|---|---|
|
DeleteInterchangeProfile.aspx.cs |
Configure Import Profiles |
User does not have the security right to configure (or delete) import profiles. |
|
ExecuteInterchange.aspx.cs |
Execute Import Profiles |
User does not have the security right to execute import profiles. |