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-Nummer BUG-000174464
EingereichtFebruary 20, 2025
Zuletzt geändertJune 23, 2025
Gilt fürArcGIS Pro
Gefunden in Version3.4.2
BetriebssystemWindows OS
Betriebssystemversion10.0
StatusAs Designed

Zusätzliche Informationen

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.

Schritte zur Reproduzierung

Bug-ID: BUG-000174464

Software:

  • ArcGIS Pro

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln