Bug
The custom queries saved from the SQL Server Management Studio (SSMS) and opened in ArcGIS Pro have a default length of 8000.
| Bug ID Number | BUG-000135925 |
|---|---|
| Submitted | December 7, 2020 |
| Last Modified | April 18, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.6.3 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
Correct text files default to defining text fields as 8000 to support interoperability workflows with ArcGIS Online. The size can be controlled via a 'schema.ini' if desired. [myQueryResults.csv] Format=CSVDelimited ColNameHeader=True Col1=objectid Long Col2=junctionty Long Col3=name Text Width 50 Col4=created_by Text Width 255Workaround
- Right-click the table and export the table.
- In the Export Table dialog box, go to each field Properties and manually change the length of each field.
Steps to Reproduce
Bug ID: BUG-000135925
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