topic Re: Why do I get the error &quot;unable to add feature service definition&quot; when creating a feature service based on an existing service? in ArcGIS Online Questions https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81802#M3995 <HTML><HEAD></HEAD><BODY><P>Hi Kelly,</P><P>I can't share the service publicly. I can create you an account in our Organization if you'd be willing to test it.</P><P>Thanks.</P></BODY></HTML> Tue, 13 Nov 2018 23:31:41 GMT WalkerHenry 2018-11-13T23:31:41Z Why do I get the error "unable to add feature service definition" when creating a feature service based on an existing service? https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81800#M3993 <HTML><HEAD></HEAD><BODY><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">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.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">One of the templates is now giving the error<SPAN>&nbsp;</SPAN><STRONG style="border: 0px; font-weight: bold;">"Unable to add feature service definition"</STRONG><SPAN>&nbsp;</SPAN>when this action is attempted.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">The error details say<SPAN>&nbsp;</SPAN><STRONG style="border: 0px; font-weight: bold;">"Column name 'geometry' does not exist in the target table or view."</STRONG><SPAN>&nbsp;</SPAN><A href="https://i.stack.imgur.com/hpw3X.png" style="color: rgba(53, 141, 170, 0.8); border: 0px; font-weight: inherit; text-decoration: underline;"><IMG alt="Error" src="https://i.stack.imgur.com/hpw3X.png" style="border: 0px; font-weight: inherit;" /></A></P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">Is the 'target' the new feature service or the one being based on? The original feature service is a point geometry and appears fine.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">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<SPAN>&nbsp;</SPAN><STRONG style="border: 0px; font-weight: bold;">"There are no primary or candidate keys in the referenced table '<EM style="border: 0px; font-weight: inherit;">tablename</EM>' that match the referencing column list in the foreign key 'FK_<EM style="border: 0px; font-weight: inherit;">servicename</EM>.'</STRONG><SPAN>&nbsp;</SPAN>Could not create constraint or index. See previous errors.</P><P style="color: #242729; background-color: #f9f8f6; border: 0px; margin: 0px 0px 1em;">Can anyone tell me what the problem is here?</P></BODY></HTML> Thu, 08 Nov 2018 23:32:23 GMT https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81800#M3993 WalkerHenry 2018-11-08T23:32:23Z Re: Why do I get the error "unable to add feature service definition" when creating a feature service based on an existing service? https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81801#M3994 <HTML><HEAD></HEAD><BODY><P>Are you able to share the source feature service?</P></BODY></HTML> Sat, 10 Nov 2018 00:20:34 GMT https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81801#M3994 KellyGerrow 2018-11-10T00:20:34Z Re: Why do I get the error "unable to add feature service definition" when creating a feature service based on an existing service? https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81802#M3995 <HTML><HEAD></HEAD><BODY><P>Hi Kelly,</P><P>I can't share the service publicly. I can create you an account in our Organization if you'd be willing to test it.</P><P>Thanks.</P></BODY></HTML> Tue, 13 Nov 2018 23:31:41 GMT https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81802#M3995 WalkerHenry 2018-11-13T23:31:41Z Re: Why do I get the error "unable to add feature service definition" when creating a feature service based on an existing service? https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81803#M3996 <HTML><HEAD></HEAD><BODY><P>Hi Walker,</P><P></P><P>Try getting in touch with tech support. That way a dedicated analyst can work through this issue with you and perform tests.</P><P></P><P>-Kelly</P></BODY></HTML> Wed, 14 Nov 2018 18:21:46 GMT https://community.esri.com/t5/arcgis-online-questions/why-do-i-get-the-error-quot-unable-to-add-feature/m-p/81803#M3996 KellyGerrow 2018-11-14T18:21:46Z