Error
Using CopyRows() or Sort() in ArcGIS Pro from a SQLite table to a geodatabase table lops off the last field in the output table.
| Número de ID del error | BUG-000174464 |
|---|---|
| Enviado | February 20, 2025 |
| Última modificación | June 23, 2025 |
| Relacionado con | ArcGIS Pro |
| Versión encontrada | 3.4.2 |
| Sistema operativo | Windows OS |
| Versión de sistema operativo | 10.0 |
| Estado | As Designed |
Información adicional
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.Solución alternativa
Add the .gpkg database to the databases in the Catalog pane, and use Copy() to copy the table instead.
Pasos para reproducir
ID del error: BUG-000174464
Software:
- ArcGIS Pro
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri