Error 400 Unable to add feature service definition

Question

Getting Error code 400 - saying [CREATE TABLE failed becuase column 'example1' in table...

I'm not seeing duplicates.  So I moved the 'example1' column down to the bottom, tried again, and I'm then I get an error on 'example2' column.

I'm guessing I have too many fields.

EAGSA Groundwater Extractions.xlsx

sfpic.PNG

dougbrowning · Answer

Oh found it is 1024 for 123.  You close.  Looked like there are ways to consolidate some in there.

https://community.esri.com/t5/arcgis-survey123-questions/maximum-number-of-attribute-fields-in-agol-feature-service/m-p/785286/highlight/true

EddyClark · Answer

This is what the error log says:  error: {
"code": 400,
"details": [
"CREATE TABLE failed because column 'wus_urban_bv_mar_Calc' in table 'service_33x5e5902cb34f2ea25b09335c03f53e_GROUNDWATER_EXTRACTIONS' exceeds the maximum of 1024 columns."
],
"message": "Unable to add feature service definition."
}

dougbrowning · Answer

I can only find the specs for a File Geodatabase.  Not sure what AGOL is but 1400 would be way lower.

File geodatabase size and name limits are as follows:

File geodatabase size: No limit

Table or feature class size: 1 TB (default), 4 GB or 256 TB with keyword

Number of feature classes and tables: 2,147,483,647

Number of fields in a feature class or table: 65,534

Number of rows in a feature class or table: 2,147,483,647

Geodatabase name length: Number of characters the operating system allows in a folder name

Feature class or table name length: 160 characters

Field name length: 64 characters

Text field width: 2,147,483,647