Duplicate Field in Service Definition

5738
16
05-17-2013 09:07 AM
DavidMajor
New Contributor II
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
Tags (2)
0 Kudos
16 Replies
by Anonymous User
Not applicable

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

0 Kudos
LisaNelson
New Contributor II

Thank you, thank you, thank you!!!

0 Kudos
HezronPhilip
New Contributor II

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

NicoleSulzberger
Occasional Contributor

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
Occasional Contributor III

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

0 Kudos
NielsGerrits
New Contributor II

Thanks!

0 Kudos
NathanHeickLACSD
Occasional Contributor III

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.

0 Kudos