EEE Data Loader fails to import Enabler Configurations

There are various reasons as to why EEE Data Loader may not be able to import the Enabler Till configurations from the Enabler Head Office Server. Below are some symptoms that have been experienced during Magenta Retail testing. If your scenario is not included, please contact Magenta Support.

Scenario 1: EEE Data Loader fails to import Enabler Configurations due to access being denied (Operating System Error 5)

Symptoms

Enabler Till configurations are not importing from the Enabler Head Office Server to the EEE configuration table.

You may receive the following error in the Windows Application Event Log:

Level:  Error
Source:  EEE Data Loader
Event ID:  124
The EEE Data Load service encountered an error in the Enabler configuration importer.  
Microsoft SQL Server Native Client 10.0 [Database: \\EEE_SQL_Server.EEE]: Cannot bulk load because 
the file "<dataloader temp path>\TILLS.imp" could not be opened. Operating 
system error code 5(failed to retrieve text for this error. Reason: 15105).  Extended Info 1: 
IDispatch error #3092

<dataloader temp path> is the Data Loader Temp path configured in EEE Tools Configurator on the server where Data Loader is running

Cause

Operating System Error Code 5 indicates that 'Access is denied'

Although Data Loader is the application that begins the import process, the Bulk Load is actually performed by the SQL Server service. Therefore, the Windows user account that is configured to run the SQL Server service must have permission to access the Data Loader Temp path.

Solution

Configure the Data Loader Temp path that is configured in EEE Tools Configurator to allow the SQL Server service account to have full control.