Skip to main content
Question

ArcGIS Enterprise Portal: Fail to update layer with Change Detector

  • September 13, 2023
  • 3 replies
  • 70 views
U

Hello all,

I am trying to update a feature layer on the ArcGIS Enterprise Portal.

I have the feature layer and an Excel I'm using for the updated information.

 

The change detector detects the one change I've added to my test version but when I try to update the online layer I get this error message:

 

"ArcGIS Portal Feature Service Writer: 'updateResults' error for a feature in 'C1_Cluster_Flurstueck'. The error code from the server was '10500' and the message was: 'Cannot convert a value of type 'java.lang.String' to 'INTEGER'.'"

 

The values that I'm trying to update in the excel and in the layer are both text fields and not numerical hence I dont understand where the integer part is coming from.

Can someone tell me if I'm using the right transformers and what I should change to make it work?

Thanks in advance!

 

(I'm fairly new to FME so any help regarding the workspace is appreciated)

 

3 replies

j.botterill
Influencer
Forum|alt.badge.img+40
  • j.botterillInfluencer
  • Influencer
  • September 13, 2023

For the text fields, what have you set as "Type" on the Writer - user attribute definitions. I don't think esri like 'Integer' type having empty/nothing values... so check the text fields have values... using the NullAttributeMapper might help Portal_featyreservice_writer

U
  • utepla
  • Author
  • September 14, 2023
j.botterill wrote:

For the text fields, what have you set as "Type" on the Writer - user attribute definitions. I don't think esri like 'Integer' type having empty/nothing values... so check the text fields have values... using the NullAttributeMapper might help Portal_featyreservice_writer

Hi, thanks for your reply. There are no empty fields. I've tried the NullAttributeMapper anyway but sadly that wasn't it. The user attributes have the following types. imageimage

j.botterill
Influencer
Forum|alt.badge.img+40
  • j.botterillInfluencer
  • Influencer
  • September 14, 2023

hi utepla, can you send a screen grab of the Portal feature service - 'Data' tab and show the field names.

Each time you write to Esri the objectid is the primary index. Appears you are trying to write objectid_12 so this is perhaps where the issue resides

objectidsAlso you don't need to write SHAPE_% attributes, drop these on the writer,,, as these are calculated again in the feature service

Reply


Helpful Members This Week

Community Stats

31,334
Posts
118,864
Replies
38,957
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.