Duplicate Field in Service Definition

[DavidMajor]

I've added a field to a feature class in my SDE database, then republished the map service using it. The application I use to view the map service now crashes. Its called Cityview. It complains when it crashes that the new field is already in the service. So when I browse to the service, I noticed that the new field I added is displayed twice in the contents of the field definition. I suspect this is the problem but I can't fix it.

I've tried deleting the field, then adding another different field and same thing. Any help would be appreciated.

- David

Using ArcGIS Server 10.1 with SQL SDE and Windows Server 2008 R2

Here is the layer definition:

Layer: Parcels (ID: 17)

Name: Parcels

Display Field: PID

Type:  Feature Layer

Geometry Type: esriGeometryPolygon

Description: 

Definition Expression: 

Copyright Text: 

Default Visibility: true 

MaxRecordCount:  1000

Supported Query Formats:  JSON, AMF

Min Scale:  0

Max Scale:  0

Supports Advanced Queries:  true

Supports Statistics:  true

Has Labels:  false

Can Modify Layer:  false

Can Scale Symbols:  false

Extent: XMin: -1.3333465240339989E7
YMin: 6517317.380403321
XMax: -1.2955377341100832E7
YMax: 6838924.548245557
Spatial Reference: 102100  (3857)


Drawing Info:  Renderer:  Simple Renderer:
Symbol:  Style:  esriSFSSolid
Color:  [0, 0, 0, 0]
Outline:  Style:  esriSLSSolid
Color:  [157, 149, 142, 255]
Width:  1 Label: 
Description:  Transparency:  0
Labeling Info: 
HasZ: false

HasM: false 

Has Attachments:  false

HTML Popup Type:  esriServerHTMLPopupTypeAsHTMLText

Type ID Field:  null

Fields:  ??? OBJECTID  ( type: esriFieldTypeOID , alias: OBJECTID ) 
??? ROLL  ( type: esriFieldTypeDouble , alias: ROLL ) 
??? IDPARCEL  ( type: esriFieldTypeString , alias: IDPARCEL , length: 8 ) 
??? IDOTHER  ( type: esriFieldTypeInteger , alias: IDOTHER , Coded Values:  [100: Islands in Water] , [200: Water Series] , [300: Forestry Road] , ...44 more... ) 
??? ROLLX  ( type: esriFieldTypeString , alias: ROLLX , length: 13 ) 
??? PID  ( type: esriFieldTypeString , alias: PID , length: 11 ) 
??? TOTALHOUSE  ( type: esriFieldTypeInteger , alias: TOTALHOUSE ) 
??? LEGAL_PLAN  ( type: esriFieldTypeString , alias: LEGAL_PLAN , length: 8 ) 
??? BLOCK  ( type: esriFieldTypeString , alias: BLOCK , length: 5 ) 
??? LOT  ( type: esriFieldTypeString , alias: LOT , length: 5 ) 
??? SECTION  ( type: esriFieldTypeString , alias: SECTION , length: 4 ) 
??? TOWNSHIP  ( type: esriFieldTypeString , alias: TOWNSHIP , length: 4 ) 
??? RANGE  ( type: esriFieldTypeString , alias: RANGE , length: 2 ) 
??? MERIDIAN  ( type: esriFieldTypeString , alias: MERIDIAN , length: 1 ) 
??? DISTLOT  ( type: esriFieldTypeString , alias: DISTLOT , length: 5 ) 
??? LGL_SUBD  ( type: esriFieldTypeString , alias: LGL_SUBD , length: 2 ) 
??? STREET  ( type: esriFieldTypeString , alias: STREET , length: 25 ) 
??? LGL_DESC  ( type: esriFieldTypeString , alias: LGL_DESC , length: 100 ) 
??? SIZE_HA  ( type: esriFieldTypeDouble , alias: SIZE_HA ) 
??? OWNER_TYPE  ( type: esriFieldTypeString , alias: OWNER_TYPE , length: 1 , Coded Values:  ,

, , ...17 more... ) 

??? ELECT  ( type: esriFieldTypeString , alias: ELECT , length: 1 , Coded Values:  , , , ...3 more... ) 
??? GIS_TILE  ( type: esriFieldTypeString , alias: GIS_TILE , length: 2 , Coded Values:  [bb: blaeberry] , [dn: donald] , [kh: kicking_horse_river] , ...68 more... ) 
??? MAPSHEET  ( type: esriFieldTypeString , alias: MAPSHEET , length: 4 ) 
??? EDITDATE  ( type: esriFieldTypeDate , alias: EDITDATE , length: 36 ) 
??? EDITREASON  ( type: esriFieldTypeString , alias: EDITREASON , length: 3 , Coded Values:  [New: New feature] , [Chg: Change feature] , [Mis: Missing feature added] , ...1 more... ) 
??? Common_Name  ( type: esriFieldTypeString , alias: Common_Name , length: 30 ) 
??? EditPerson  ( type: esriFieldTypeString , alias: EditPerson , length: 5 , Coded Values:  [Don: Don Richmond] , [Olive: Olive Dodd] , [David: David Major] , ...2 more... ) 
??? Data_Source  ( type: esriFieldTypeString , alias: Data_Source , length: 10 , Coded Values:  [GPS: GPS] , [Ortho: Orthophoto] , [Estimate: Digitized Estimate] , ...9 more... ) 
??? Count_Polygons  ( type: esriFieldTypeInteger , alias: Count_Polygons ) 
??? Block_Plan  ( type: esriFieldTypeString , alias: Block_Plan , length: 50 ) 
??? Comment  ( type: esriFieldTypeString , alias: Comment , length: 150 ) 
??? CSRD_File  ( type: esriFieldTypeString , alias: CSRD_File , length: 25 ) 
??? Parcel_Doc  ( type: esriFieldTypeString , alias: Parcel_Doc , length: 15 ) 
??? Crown  ( type: esriFieldTypeString , alias: Crown , length: 3 , Coded Values:  , ) 
??? Shape  ( type: esriFieldTypeGeometry , alias: Shape ) 
??? testfield  ( type: esriFieldTypeInteger , alias: testfield ) 
??? Shape.STLength()  ( type: esriFieldTypeDouble , alias: Shape.STLength() ) 
??? testfield  ( type: esriFieldTypeInteger , alias: testfield ) 

Supported Operations:   Query   Generate Renderer   Return Updates

[Anonymous User]

Resetting field ordering worked for me as well. Thanks a bunch!

[LisaNelson]

Thank you, thank you, thank you!!!

[HezronPhilip]

This should be marked as the right answer. Solved the issue without any fuss.

[NicoleSulzberger]

in my case a field got the wrong alias in the service after publishing it to ArcGIS Server:

{"name":"PR_PROZESS","type":"esriFieldTypeString","alias":"Shape.STArea())"

Manually reordering the fields helped in my case.

[AlessandroValra]

Reording also worked for me. Agree that this should be the accepetd answer. Thanks!

[NielsGerrits]

Thanks!

[NathanHeickLACSD]

I'm still getting this issue with ArcGIS Pro 2.9.6 and ArcGIS Server 10.6.1.  Hopefully, it's fixed in newer versions of ArcGIS Server.  Resetting the field order did the trick.