topic arcgis server error 00099: Layer has a join with an unsupported data source in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-error-00099-layer-has-a-join-with-an/m-p/56123#M2066 <HTML><HEAD></HEAD><BODY><P>I tried to publish a dynamically generated layer as a map service.&nbsp; This dynamic layer is generated through a ModelBuilder that consists of a Add Join tool.&nbsp; In the map service publishing, I received the error: 00099: Layer has a join with an unsupported data source.&nbsp; I believe that that is due to the use of an In-Memory FC (unsupported data source).&nbsp; Through google, I could not find any discussion to avoid/eliminate this problem.&nbsp; Do you know how?&nbsp; Appreciate if you can share your experience.</P></BODY></HTML> Tue, 28 Oct 2014 19:45:04 GMT ShaningYu 2014-10-28T19:45:04Z arcgis server error 00099: Layer has a join with an unsupported data source https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-error-00099-layer-has-a-join-with-an/m-p/56123#M2066 <HTML><HEAD></HEAD><BODY><P>I tried to publish a dynamically generated layer as a map service.&nbsp; This dynamic layer is generated through a ModelBuilder that consists of a Add Join tool.&nbsp; In the map service publishing, I received the error: 00099: Layer has a join with an unsupported data source.&nbsp; I believe that that is due to the use of an In-Memory FC (unsupported data source).&nbsp; Through google, I could not find any discussion to avoid/eliminate this problem.&nbsp; Do you know how?&nbsp; Appreciate if you can share your experience.</P></BODY></HTML> Tue, 28 Oct 2014 19:45:04 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-error-00099-layer-has-a-join-with-an/m-p/56123#M2066 ShaningYu 2014-10-28T19:45:04Z Re: arcgis server error 00099: Layer has a join with an unsupported data source https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-error-00099-layer-has-a-join-with-an/m-p/56124#M2067 <HTML><HEAD></HEAD><BODY><P>Is the data source registered with ArcGIS Server?</P><P>Does the data source contain a unique key field that can double as a ObjectId key?</P><P></P><P>Consider using the the Make Query Table tool in your model/python script before calling the Add Join tool</P></BODY></HTML> Tue, 28 Oct 2014 20:23:38 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-error-00099-layer-has-a-join-with-an/m-p/56124#M2067 SusanJones 2014-10-28T20:23:38Z Re: arcgis server error 00099: Layer has a join with an unsupported data source https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-error-00099-layer-has-a-join-with-an/m-p/56125#M2068 <HTML><HEAD></HEAD><BODY><P>Susan:&nbsp; Wonderful!&nbsp; Per your advisory, I substituted the Add Join tool by the Make Query Table tool.&nbsp; Then, it went through in publishing it as a map service.&nbsp; Thanks.</P></BODY></HTML> Wed, 29 Oct 2014 12:17:00 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-error-00099-layer-has-a-join-with-an/m-p/56125#M2068 ShaningYu 2014-10-29T12:17:00Z