AnsweredAssumed Answered

Why do I get the error "unable to add feature service definition" when creating a feature service based on an existing service?

Question asked by wfhenry on Nov 8, 2018
Latest reply on Nov 14, 2018 by KGerrow-esristaff

My AGOL Org has a number of templates that users create their own hosted feature services off of by using the Create Feature Layer from an Existing Layer option under Content.

One of the templates is now giving the error "Unable to add feature service definition" when this action is attempted.

The error details say "Column name 'geometry' does not exist in the target table or view." Error

Is the 'target' the new feature service or the one being based on? The original feature service is a point geometry and appears fine.

The user that reported the issue was able to create a new feature service and then discovered the issue the next day when he was unable to enable attachments on his service. I don't know if the two issues are related. The error when enabling attachments is "There are no primary or candidate keys in the referenced table 'tablename' that match the referencing column list in the foreign key 'FK_servicename.' Could not create constraint or index. See previous errors.

Can anyone tell me what the problem is here?

Outcomes