Clearwell Export creating a "file_exceptions" directory and a "file_exceptions.csv" file

book

Article ID: 100028411

calendar_today

Updated On:

Cause

This issue can happen when the file path of any single file being exported exceeds the windows MAX_PATH value of 260. When performing an export using the default configuration, Clearwell creates a temporary working directory under D:\CW\V66\data\esab\dataStore_case_xxxxxxxxx_xxxxxxxx can have a total path over 100 characters in length. When selecting the export option to create a zip file, a further 35 characters are reserved for the zip file name, e.g. EXPORT_CONTENT_2018-12-21_06-41-36.zip. As a result an input source file with a path that is little over 100 characters in length can be renamed in the export.

Resolution

 A few things be done to try to reduce the size of the working directory path used by Clearwell, and reduce the chance of paths being renamed:

1. Select the export option "Use short, most relevant folder paths". This might shorten the paths enough to prevent them from being renamed.

2. Select the export option "Access only from appliance". This option doesn't create a zip file. Then set property esa.export.filepathlimit=295. 35 characters will always be removed, as mentioned earlier, because a zip file will not be created. An extra 35 characters can be added. 

3. Use the property esa.export.joboutput.external to specify a network share as the destination for exports.

For example: esa.export.joboutput.external=\\cwsupport29\myexports

Clearwell still creates a temporary working directory under this directory, but the temporary path added by Clearwell is much shorter.

 

 

 

Issue/Introduction

When performing a Native Only export and selecting the option "Preserve folder hierarchy" some of the file paths are changed in the generated export zip file. Now there is a "file_exceptions" directory and a "file_exceptions.csv" file. For example:
C:\>unzip -l D:\CW\V83\data\esadb\dataStore_case_294782252_56833602\fileManager\0.14.1324.5\jobRun_130\EXPORT_CONTENT_2018-12-21_06-41-36.zip
Archive: D:/CW/V83/data/esadb/dataStore_case_294782252_56833602/fileManager/0.14.1324.5/jobRun_130/EXPORT_CONTENT_2018-12-21_06-41-36.zip
Length Date Time Name
--------- ---- ---- ----
271360 12/21/18 06:41 ClearwellExport.pst
0 12/21/12 06:41 Files/
0 12/21/18 06:41 Files/Sample_Folder/
0 12/21/18 06:41 Files/Sample_Folder/file_exceptions/
184 12/21/18 06:41 Files/Sample_Folder/file_exceptions.csv
10 12/13/18 04:02 Files/Sample_Folder/file_exceptions/Transitional Documentation 05-14-09.txt
1549 12/21/18 06:41 input_urn.xml
1785 12/21/18 06:41 output_urn.xml
7259 12/21/18 06:41 summary.xml
-------- -------
282147 9 files

The file_exceptions.csv file lists the original and renamed file paths. For example:
"ShortPath","LongPath"
"file_exceptions\Transitional Documentation 05-14-09.txt","Files\Sample_Folder\__cwsupport29\C$\Sample_Folder\Shares\Sample_Folder2\card01 data\1\Transitional Documentation 05-14-09.txt"