laptop and a wrench

Bug

Using CopyRows() or Sort() in ArcGIS Pro from a SQLite table to a geodatabase table lops off the last field in the output table.

ArcGIS Pro
Bug ID Number BUG-000174464
SubmittedFebruary 20, 2025
Last ModifiedJune 23, 2025
Applies toArcGIS Pro
Version found3.4.2
Operating SystemWindows OS
Operating System Version10.0
StatusAs Designed

Additional Information

CopyRows() requires data having a field of the Object ID type named and aliased as OBJECTID. With mykey, the field in this issue, not meeting that requirement, CopyRows() creates an OBJECTID field of the data type Object ID and aliased OBJECTID. Since only one field of data type Object ID is allowed, CopyRows() drops the mykey field in this case. Sort() also does not recognize a field of the Object ID type that is not named and aliased as OBJECTID and thus does not list that field to sort on. The Copy tool maintains a field like mykey, which is of the type Object ID, and the name and alias are different. However, such a field is not available in the copied data to subsequently sort on.

Workaround

Add the .gpkg database to the databases in the Catalog pane, and use Copy() to copy the table instead.

Steps to Reproduce

Bug ID: BUG-000174464

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options