laptop and a wrench

Bogue

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
Numéro d’ID de bogue BUG-000174464
EnvoiFebruary 20, 2025
Dernière modificationJune 23, 2025
S’applique àArcGIS Pro
Version trouvée3.4.2
Système d’exploitationWindows OS
Version du système d’exploitation10.0
StatutAs Designed

Informations supplémentaires

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.

Solution de contournement

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

Étapes pour reproduire

ID de bogue: BUG-000174464

Logiciel:

  • ArcGIS Pro

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement