topic Re: Duplicate Field in Service Definition in ArcGIS Enterprise Questions

Duplicate Field in Service Definition

DavidMajor — Fri, 17 May 2013 16:07:02 GMT

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

Re: Duplicate Field in Service Definition

JakubOrálek — Tue, 09 Jul 2013 12:23:26 GMT

I have the same problem. In the feature class the field is only once, as well in Item's XML definition and as well in ArcMap Layer. But through REST API it is displayed twice.

Any solution please?

Kuba

Re: Duplicate Field in Service Definition

DavidMajor — Tue, 16 Jul 2013 14:50:50 GMT

If I create a copy of the feature class, delete the fc in SDE, import it back in to SDE from the copy, then re-publish the service, it does not create a duplicate of the new field. It has not worked every time though, and sometimes it duplicates one of the new fields but not another. But it is always a field that I have included after originally creating the fc. More of a workaround/dart throwing than a solution but you could try that.

David

Re: Duplicate Field in Service Definition

TanuHoque — Wed, 17 Jul 2013 15:30:34 GMT

David, Kuba:
I'd suggest to contact Esri Tech Support to have them take a look at your issue.

few things:
1. I have noticed that "Shape.STArea()" field is missing even though it is a polygon fc
2. are you publishing by copying the data (it does not seem to; just wanted to double-check)
3. did you stop the map service before adding the new field? or, do you happen to have schema-locking disabled?
4. did you ever try deleting the exiting map service first >> then add new field >> and publish as a new map service?

thanks.
Tanu

Re: Duplicate Field in Service Definition

DavidMajor — Mon, 22 Jul 2013 16:02:19 GMT

I had a ticket with ESRI and its been resolved. The problem was arcgis account. I manage my services using database authentication, then publish services using MXDs with OS authentication. We found that when I published the data using database authentication the duplicate field problem was gone. The permissions aren't an issue when using database authentication.

Why it results in this kind of crazy error is beyond me. You would think it would stop you from publishing it rather than publish it with some configuration that shouldn't be possible.

We deleted the existing arcgis account, also deleted some old ArcGISSOC accounts related to server 10.0, then ran the server account wizard to recreate the arcgis account. We re-added the arcgis account to the instance logins and database users in SQL then made sure it had db_datareader role.

David

Re: Duplicate Field in Service Definition

MasaoMatsuoka — Mon, 15 May 2017 23:30:30 GMT

This is an old thread, but this is the only one with the exact problem I had.

In my case I was able to resolve this by resetting the field order in ArcMap, then publishing it again. You can reset the field order in the layer properties window, under the fields tab, click "Options", then "Reset Field Order".

Hopefully it helps somebody.

Re: Duplicate Field in Service Definition

arunchanumalla — Fri, 19 May 2017 18:40:00 GMT

It helped me tremendously .

Many Thanks

Re: Duplicate Field in Service Definition

MikeAlverson — Tue, 23 May 2017 20:53:55 GMT

Thanks for sharing. Resetting the field order fixed the duplicate fields that were created when publishing services.

Re: Duplicate Field in Service Definition

KyleGjeruldsen — Thu, 25 May 2017 18:35:29 GMT

I'd like to hug you right now!

Re: Duplicate Field in Service Definition

SanneMikkelsen — Tue, 10 Oct 2017 09:10:59 GMT

At first I did not look at this, because the thread started in 2013, so I thought it was too old. But as my options ran out I found this!

THANK YOU SO MUCH!

Re: Duplicate Field in Service Definition

Anonymous User — Tue, 17 Oct 2017 22:37:01 GMT

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

Re: Duplicate Field in Service Definition

LisaNelson — Thu, 09 Nov 2017 00:32:55 GMT

Thank you, thank you, thank you!!!

Re: Duplicate Field in Service Definition

HezronPhilip — Fri, 15 Jun 2018 06:59:03 GMT

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

Re: Duplicate Field in Service Definition

NicoleSulzberger — Fri, 31 Aug 2018 08:40:23 GMT

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.

Re: Duplicate Field in Service Definition

AlessandroValra — Wed, 06 Feb 2019 12:02:57 GMT

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

Re: Duplicate Field in Service Definition

NielsGerrits — Wed, 25 Sep 2019 09:30:44 GMT

Thanks!

Re: Duplicate Field in Service Definition

NathanHeickLACSD — Tue, 27 Jun 2023 02:08:32 GMT

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.