BUG-000163260 for ArcGIS Pro

Bug ID Number	BUG-000163260
Submitted	November 28, 2023
Last Modified	June 5, 2024
Applies to	ArcGIS Pro
Version found	3.2
Operating System	Windows OS
Operating System Version	10.0 64 Bit
Status	As Designed

Additional Information

The provided CSV file contains integer values in the 64-bit (Big) integer range (greater than 2.147 billion). In the previous release of ArcGIS Pro prior to the 3.2 release, fields with these values were read as the field type 'Double'. Starting in ArcGIS Pro 3.2, fields with these values are read as the field type Big Integer. Big Integer fields cannot be created in the .DBF format; thus, exporting the table to that format returns an error. This error message is to be made more consistent in time, indicating that the reason the output table cannot be created is due to the unsupported field type for the output format.

Workaround

Use a different output format. Use the mapping option "Use field types that are compatible with ArcGIS Pro 3.1 and earlier releases when adding query layers and text files" to have the csv table added using legacy field types that can be exported to dbf format. Refer to the documentation: https://pro.arcgis.com/en/pro-app/latest/help/mapping/properties/default-settings-for-new-maps-and-scenes.htm#ESRI_SECTION1_856A5CFA37884F889D2BBC0FC31315A2.
Use the Field Map parameter of the Export Table tool to change the field from Big Integer to Double when exporting to dbf format. Refer to the documentation: https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/basics/field-map.htm#ESRI_SECTION1_90E9A065A1A440E4BC945C331921E37B.