-
Title
Notes Directory Export does not create address translation file reporting SQL BULK INSERT ERROR i -
Description
When running Notes Directory Export, the operation completes, having not created the address translation file,with the following in the error log:
18:08:04 ERROR: [2336-122-33-80040E14] Unable to perform BULK INSERT into database
18:08:04 Open(BULK INSERT FROM '\\SERVER\migration\Bulk\T_NMEObjects-GBLON9EMM01-3096.tsv' INTO 'T_NMEObjects'):
18:08:04 Error: Cannot bulk load because the file "\\SERVER\migration\Bulk\T_NMEObjects-GBLON9EMM01-3096.tsv" could not be opened. Operating system error code 5(error not found). -
Cause
The SQL Service account does not have permissions on the target path specified for the Bulk Import Directory ('\\SERVER\migration\Bulk').
-
Resolution
The above error is due to the UNC path entered in the 'Bulk Import Directory', which is specified in the SQL Server Settings within Notes Migrator.
To resolve this, change the current UNC path specified in the Bulk Import Directory to a new UNC path on the SQL Server with appropriate permissions.
Note that other issues relating to errors similar can be due to NTFS permissions and that the SQL User does not have BULK INSERT permissions.