Troubleshoot

Local instance of Find duplicates

Problem: An error is reported when running Find duplicates: An error occurred running Find Duplicates step: Failed to connect to Standardization server.

Cause: The Standardize service is not running.

Resolution:
To fix the issue:

  1. Search for services from the start menu or go to Control Panel > System and Security > Administrative Tools > Services.
  2. Locate Experian Aperture Data Studio {version number} Standardize Server, right-click it and select Properties.
  3. Open the Log On tab.
  4. Select This account and enter NT AUTHORITY\NETWORK SERVICE as the account.
  5. Click Apply to save changes.
  6. Right-click on Experian Aperture Data Studio {version number} Standardize Server and select Start.

Remote instance of Find duplicates

Problem: An error is reported when running Find duplicates: An error occurred running Find Duplicates step: Failed to connect to Standardization server.

Cause: The Standardize service is not running.

Resolution:
To fix the issue, you need to check you have sufficient privileges to start system services:

  1. Search for services from the start menu or go to Control Panel > System and Security > Administrative Tools > Services.
  2. Locate GdqStandardizeServer, right-click it and select Properties.
  3. Open the Log On tab.
  4. Select This account and enter NT AUTHORITY\NETWORK SERVICE as the account.
  5. Click Apply to save changes.
  6. Right-click on the GdqStandardizeServer service and select Start.

Problem: When attempting to start the Tomcat service, the service startup fails. This occurs for two main reasons, outlined below.

Cause 1: Tomcat is unable to find java installed on that machine.

Resolution 1: Configure the JAVA_HOME environment variable.

  1. Right-click the Computer icon and choose Properties, or in Windows Control Panel, choose System.
  2. Choose Advanced system settings.
  3. On the Advanced tab, click Environment Variables.
  4. In System variables, click New to create a new JAVA_HOME setting, or Edit to modify an existing setting.
  5. Set the path to the local Java 17 installation folder.
    System variables window showing the path of JAVA_HOME set to the local Java 17 installation folder.

Cause 2: There is insufficient memory allocated to Tomcat.

Resolution 2:
It is recommended that a minimum of 8GB RAM is allocated to Tomcat.

  1. Navigate to the \bin folder in the Tomcat installation location.
  2. Run tomcat9w.exe
  3. In the Java tab, set the minimum and maximum memory pool.
    Example memory pool allocation in the Java tab.

Problem: The Find Duplicates server is running and the Find Duplicates Swagger page (http://{host}:8080/swagger-ui/index.html, or http://{host}:8080/match-rest-api-{version}/match/docs/index.html if this is a Tomcat deployment) is accessible, but Data Studio reports an invalid URL when testing the connection and calling the \system endpoint from Swagger returns a 500 internal server error

Cause: The most likely cause for this is that the Find Duplicates service (or Tomcat if this is a web server deployment) does not have permissions to access the licensing folder (by default C:\ProgramData\Experian). This normally occurs if the service is running as a named user or as LOCAL_SERVICE.

Resolution: Two options exist for resolution.

  1. Change the service to run as LOCAL_SYSTEM
    • Open the Windows service manager
    • Select Properties for the Find Duplicates (or Apache Tomcat) service.
    • Select the Log On tab
    • Change the service to log on as the Local System account.
      Local system account selected in the Log On tab.
  2. Give the user account the service is running under full access to the licensing folder (by default C:\ProgramData\Experian).