Bug ID Number |
BUG-000174464 |
Submitted | February 20, 2025 |
Last Modified | June 23, 2025 |
Applies to | ArcGIS Pro |
Version found | 3.4.2 |
Operating System | Windows OS |
Operating System Version | 10.0 |
Status | As Designed
After review by the development team, it has been determined that this behavior is as designed. See the Additional Information section for details.
|
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