PROBLEM

A generic error is returned when running the Pivot Table tool

Last Published: April 26, 2020

Description

The Pivot Table (Data Management) tool creates an Output Table from an Input Table by reducing redundant records and flattening one-to-many relationships. In some instances, using the tool fails and returns a generic error, “Error 999999: Error executing function.”

Cause

This error is caused by the presence of NULL values in the field used for the pivot field.

Solution or Workaround

Remove the NULL values or replace them with other values, such as zero.


Note:
If background processing is turned on, the error message, "Error 001143: Background server threw an exception" may be returned. This is also caused by NULL values in the pivot field, and the NULL values must be removed or replaced.

Article ID: 000012238

Software:
  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options