Error 400 Unable to add feature service definition

633
5
03-29-2021 03:14 PM
EddyClark
New Contributor III

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.  

Tags (2)
0 Kudos
5 Replies
DougBrowning
MVP Notable Contributor

The very first row has a reserved word.  That is what the mark is for.  Not sure if that it is or not but maybe.

DougBrowning_0-1617056816195.png

That is a lot of fields though!  Not sure why you have one per agency a lot.  Hope that helps

EddyClark
New Contributor III

Thanks for the help.  I found the error log, turns out I do have too many fields.  

DougBrowning
MVP Notable Contributor

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

0 Kudos
EddyClark
New Contributor III

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."
}

0 Kudos
DougBrowning
MVP Notable Contributor

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-...

 

0 Kudos