Problem:  A generic error is returned when running the Pivot Table tool

相关信息
Article ID: 43344
Bug Id: N/A
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2
Platforms: N/A

问题描述
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.�?

原因
This error is caused by the presence of NULL values in the field used for the pivot field.
已邀请:

易智瑞技术支持

赞同来自:

解决方案
Remove the NULL values or replace them with other values, such as zero.



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.



其它相关参考
  1. ArcGIS Help: 999999 : Error executing function.
  2. ArcGIS Help: Pivot Table (Data Management)
  3. FAQ: How to check for null values in the Field Calculator using Python
  4. HowTo: Automate setting null values to zero
  5. HowTo: Replace one value for another within a field
  6. HowTo: Convert NoData values to other values for raster data


创建及修改时间
Created: 10/29/2014

Last Modified: 1/12/2015
原文链接
http://support.esri.com/en/kno ... 43344

要回复问题请先登录注册