laptop and a wrench

Bug

In ArcGIS Pro 3.2, the error message, “ERROR 002809: Field OID in <path> is of an unsupported type for the output workspace." is returned when using the Export Table geoprocessing tool to export as a file geodatabase from a non-enterprise geodatabase.

ArcGIS Pro
Bug ID Number BUG-000164103
SubmittedJanuary 3, 2024
Last ModifiedMay 2, 2024
Applies toArcGIS Pro
Version found3.2
Operating SystemWindows OS
Operating System VersionN/A
StatusAs Designed

Additional Information

A non-geodatabase database table is used in ArcGIS Pro as a query layer. If that table does not have an ObjectID field (the code sample for creating the table in the database did not specify an ObjectID), the system automatically adds one for use in ArcGIS Pro. This ObjectID field is 64-bit by default. Tables with a 64-bit ObjectID field cannot be exported to legacy formats like dBASE database files, which do not support 64-bit Object IDs or Big Integer fields. The workaround provided using the option to ensure compatible field types are used allows the table to be added into ArcGIS Pro using a 32-bit ObjectID field, so this table view can then be used as input to export to an output dBASE table.

Workaround

In the Options dialog on the Maps and Scenes page, check the box to Use field types that are compatible with ArcGIS Pro 3.1 and earlier releases when adding query layers and text files.

Steps to Reproduce

Bug ID: BUG-000164103

Software:

  • ArcGIS Pro

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback