How to Troubleshoot Data Import

This article provides both visual and written instructions for analyzing import-related issues.


Review Data Load

Example 1: Load File Mapping Errors

In the example below, there are a number of problems with the load file mapping: 70 - 01 - Reveal Load File Mapping errors-1-1

  • The ITEMID and PARENTID are mixed up.
  • The CREATION_DATE and CREATION_TIME are mixed up.
  • The BEGDOC and EXPORTED_NATIVE_FILE location are mixed up.

Once the mapping is saved (or Save As to provide a new name), you can run Preview. In this example, however, an error is flagged before Preview opens: 70 - 01a - Reveal Load File Mapping error warning

Once the error is acknowledged by clicking OK the Preview screen will open but display no data.

If we correct the problem with ITEMID and PARENT_ITEMID and save the mapping, Preview will display with no errors because all data fields have been mapped.

70 - 07 - Reveal Import preview BEGDOC wrong-1

Looking at the Preview, however, we can see that even though it reports at bottom No setup errors were detected during preview the Begin Number looks wrong. At load time, the following results might be seen while using Test Mode:

70 - 03 - Reveal Import Test Mode Result-1

70 - 04 - Reveal Import Test Mode Status-1

The error log file mentions Truncation and Duplicate key errors.

Data Truncation

In the example, data was truncated when the Native File Path information of 100+ characters was accidentally loaded into the BEGDOC field with a max length of 100 characters.

This issue was first presented in the Error Log with the starting phrase “Data truncated for [Review Field] [truncated data in its entirety]...70 - 05 - Reveal Import Error log

"field [Review Field] from [data size] to [max field size], data line [line# in load file (excludes header)], error file [in View Data Errors (includes header)]”. 70 - 06 - Reveal Import Error log detail

The logging has since been improved to provide better guidance as to what fields specifically need to be changed: 70 - 05a - Reveal Import Error log updated

If we were to look at the field detail we would see that the BEGDOC field has a max length of 100. Checking the data we see the path is 139 characters long. This explains the truncation. Our solution here is to change the Field to BEGDOC instead of EXPORTED_NATIVE_FILE in our field mapping.

If this were a simple truncation, another possible solution would be to change the Maximum length to something which will accommodate the data size.

Duplicate Keys

This example also has Duplicate Key Values in ITEMID because the user accidentally loaded Parent ID (attachment information) into that field. This results in 4130 load file duplicates as Parent ID is not unique and Reveal Review requires a unique identifier in ITEMID.70 - 08 - Reveal Import error log - duplicate key value

When there are duplicate key values, the software will reference their line in the load file (excluding header). In this instance, errors “Duplicate key value 74933 for column ITEMID on line 2 and ITEMID on line 3” in the error above reference lines 3 and 4 in the load file and preview below.

View of Original Load File

70 - 09 - Reveal Import load file sample

Preview View

70 - 10 - Reveal Import load file preview

View Errors

70 - 11 - Reveal Import load file view errors

There is nothing in View Errors for these items as they are skipped at load time and only the first item (original) is loaded.

Test Mode Alerts

Some errors are deemed fatal and not worth the time to run a test load to evaluate. Where a necessary value is not found, for example, you might get an error like this:

70 - 03a - Test Import AlertThe solution to this error is suggested in the Alert message: check the template or mapping. Once you click OK to this message, the Test Mode will halt. 70 - 03b - Test Import Abort

Check and validate the mapping to confirm that all necessary fields are properly mapped. Check the template to make sure that all required fields are present.

Example 2 – Duplicate Load File

In this example, we have tried to load a duplicate load file. Reveal Review requires unique BEGDOCs. Loading duplicates will result in an error and Reveal Review will not load the documents. If we have duplicate records in the database, Reveal Review will notify on the Status screen.

70 - 12 - Reveal Import test load duplicates

Error Log

70 - 13 - Reveal Import duplicates error log

Pop-Up Loading Errors

In addition to the error log errors, you may encounter pop-up errors while loading data which will inform when a data issue is encountered.

Error Message

Meaning

Resolution

No row at position 1:

An Error Occurred. The error description is: There is no row at position 1.

Unable to auto-generate Parent_ItemID, disconnect between fields used to generate the itemid and parent_itemid values.

EXAMPLE:

Your BegDoc and BegAttach are different, and you are using these to auto-generate:

BEGDOC – ENE000001

BEGATTACH – ENRON000001

Modify the load file data so that the BEGDOC and BEGATTACH are the same.

String Conversion Error:

An Error Occurred. The given value of type String from the data source cannot be converted to type nchar of the specified target column.

The field type and the data are incompatible.

EXAMPLE:

Error converting a TIME column. Format should be HH:MM am/pm (e.g., 09:32 am; Timezone indicator cannot be included). This is the record that errors: Ϸ2:28:00 (GMT) PMϷ

For this example, you would remove the time zone.

Header Synch Issue

Data error for column [Field Header] on line 1, data error file line 2 Error.70 - 14 - Reveal Partial Import error

This usually shows up with a DAT file header not being in synch with data.

EXAMPLE:

Data error for column CC_ADDRESSES on line 1, data error file line 2 error.

This error had a DAT with CC header but no delimited field for CC in the data.

 

 

Reveal Processing

 Within the Processing Framework, exception-related information is logged to the table [dbo].[Errors] within the project database. Ultimately, the status of a processing task should guide remediation efforts, as the presence of an exception within the database does not necessarily mean that the processing task failed.  

Processing frozen at item number #

This error will occur when a container file times out during child extraction due to ‘freezing’ during processing. This is observed at times with PST/ OST/NSF files. This exception is typically due to corruption within the message store.

Remediation efforts should be attempted on the archive.

Actual/Expected Child Count Mismatch

This error will be associated with a container when the actual generated child count during extraction is not equal to the expected child count collected prior to extraction. Similar to the previous error, this message often indicates corruption within the container.

Remediation efforts should be attempted on the archive.

Error Importing : 0x80030050…

This is an informative error which indicates that an item identified as an email could not be loaded as an email as is the case with corrupt loose/attached MSG files.

Unless a disproportionate volume of these messages is found, no remediation work is needed and they can be referenced as informative errors.

UNABLE TO ACCESS SOURCEFILE. FID=######

This exception will be logged during archive processing of the source archive from the processing repository cannot be accessed.  

If this exception is logged, then the presence of the project path needs to be validated. This exception can also be generated when connectivity issues exist between the agent and the processing folder, when temp space is entirely consumed on the agent, or when the source file has been quarantined by antivirus.

Zero items extracted from email archive

This exception will be logged for any email archive where zero children have been extracted during processing. While this error will be logged for empty PSTs, if this occurs on a PST that is not empty (as can be identified by its file size), it typically appears in conjunction with an additional exception.

 

Child Related Errors

This will occur for NSF files where a child-related error such as an encrypted attachment is encountered.

This can only be remediated by changes to the archive itself (such as applying certificates/user.id etc).

 

Last Updated 8/23/2022