Error: 080040: Error While Executing Desire Lines

Error Message

Attempting to run the Desire Lines analysis tool in the Esri Business Analyst Desktop toolbox returns the following error message:

Error:   
ERROR 080040: Error while executing Desire Lines.

Cause

This error can occur due to the following reasons:

Background geoprocessing is enabled by default in ArcMap. If enabled, tools are executed in the background, which allows users to continue working on the layers that are not locked by ArcMap. This can cause issues if the locked layers are dependent on data in other layers.
The dataset contains null geometries.
The input point feature layer contains points on non-traversable network element positions.

Solution or Workaround

The following are possible workarounds for this issue:

Disable Background Geoprocessing

To disable Background Geoprocessing, navigate to Geoprocessing > Geoprocessing Options. In the Background Processing section, uncheck Enabled.

Review Data

As null geometries can cause the Desire Lines tool to fail, check the dataset before executing the Desire Lines tool. To check and repair the dataset for null geometries, use the Repair Geometry tool. For more information, refer to ArcGIS Help: Repair Geometry, and ArcGIS Help: Check Geometry.

Setup Store/Customer Using Tabular/XY Data tool

In the event the Desire Lines tool returns ERROR 080040, a possible workaround is setting up the data using the Store or Customer Setup toolset before using the Desire Lines tool.

Note:
While creating a Customer layer, ensure that the layer contains a Store assignment field. The Store assignment field is based off the Store ID field in the Store layer.

Every customer requires a Store assignment that is either based on a predefined assignment, or by nearest location.

If this assignment is not made while creating the Customer layer, users have to re-run the Customer Setup wizard to Assign Customers in the following layer to Stores.

The following are the four tools for setting up use data depending on the data source and the data type. Upon completing the guided setup process for the dataset, proceed with executing the Desire Lines tool to create the Spider Diagram:

Setup Store Using Tabular Data

Setup Store Using XY Data

Setup Customers Using Tabular Data

Setup Customers Using XY Data

OD Cost Matrix (Network Analyst extension)

The OD cost matrix analysis tool calculates the distance between multiple origins and multiple destinations along a network. This tool is an alternative to using the Desire Lines tool; however, it is exclusive to the Network Analyst extension. For more information on how to use the OD cost matrix analysis tool, refer to ArcGIS Help: OD cost matrix analysis.

Article ID: 000014722

Software: