Bug
In ArcGIS Pro 3.2.x and later, the error message, "Error 000210: Cannot create output <location\table_name> Failed to execute(CopyRows)" is returned when running the Table to Geodatabase tool with a 3.1.x or earlier version of enterprise geodatabase
| Bug ID Number | BUG-000173038 |
|---|---|
| Submitted | December 13, 2024 |
| Last Modified | December 27, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 3.4 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | As Designed |
Additional Information
The issue relates to the new Big Integer field type that was introduced in ArcGIS Pro 3.2. The text file has a ROLLNUM column that is interpreted by Pro's text file reader to contain values that should be in a Big Integer field. You can see in the attribute table or Fields view of the txt table that field type is automatically selected. Trying to export one of the new field types to an old enterprise geodatabase will not succeed, thus the error as described in this report. Use one of the workarounds to resolve the issue.Workaround
- Define a schema.ini for the ROLLNUM column to be interpreted as a text field. https://pro.arcgis.com/en/pro-app/latest/help/data/tables/add-an-ascii-or-text-file-table.htm#GUID-B0FEB6D7-1468-4672-8A34-AD3F6CAC4428
- Use the Map and Scene option "Use field types that are compatible with ArcGIS Pro 3.1 and earlier releases when adding query layers and text files" https://pro.arcgis.com/en/pro-app/latest/help/mapping/properties/default-settings-for-new-maps-and-scenes.htm#ESRI_SECTION1_856A5CFA37884F889D2BBC0FC31315A2
- Upgrade the geodatabase using ArcGIS Pro 3.2.x or keep using ArcGIS Pro 3.1.1 to import the table.
Steps to Reproduce
Bug ID: BUG-000173038
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App