Skip to main content
Matrix42 Self-Service Help Center

Generic Data Import (GDIE) Troubleshooting

Overview

This article providers workarounds for know issues.

Issues

Manual Import of Excel Files causes Blocking of the HostcommonX86

Use case

When a user tries to import an excel file manually, the first import works and ends with a success. If the user tries to import the file for a second time and edits the import definition, he/she can't proceed. The button "additional information" has no function.

Reason

The GDIE uses the old "Microsoft Access database engine" component for reading Excel and CSV file on Import Definition authoring (Preview feature) as well on import run time. The component runs in a special 32-bit process HostCommon x86. Communication between processes "IIS", "HostCommon x86", "HostCommon" on some environment could cause the error.

Workaround

As a possible solution, the System can be reconfigured to use a new component version of the "Microsoft Access database engine X64" which does not require a dedicated Windows Process and can be executed inside the default Application processes.

Installation of "Microsoft Access database engine X64" component can fail any of Office 2010 (or earlier version) installed on Application Server.

Installation 

  1. Download the "Access Database Engine".
    Visit "Microsoft" website to download both versions of the component. Download link:

    clipboard_ef6a371bd6a69e9f75e2fad9f4f342671.png
  2. Run Powershell Script for Re-Configuration.
    Open the PowerShell console (e.g. ISE)  and run the command:
cd "<Application Folder>\Config\PowerShellScripts"

.\switchACEProviderToX64Process.ps1 -AceProviderFilePath  C:\Users\<current user>\Downloads\AccessDatabaseEngine_X64.exe

The script automatically uninstalls the previously installed component (Access Database Engine x86) and install the new one instead. Also, the System engines for GDIE are reconfigured to use standard "Common" Engine Host instead of "Common x86".

Rollback to origin

The script allows easily rollback to the default product configuration. For that pass to script parameters the path to the original component, and set the "Rollback "flag:

cd "<Application Folder>\Config\PowerShellScripts"

.\switchACEProviderToX64Process.ps1 -AceProviderFilePath  C:\Users\<current user>\Downloads\AccessDatabaseEngine.exe -Rollback 1
  • Was this article helpful?