topic Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484155#M18714 <HTML><HEAD></HEAD><BODY><P>Not seeing any obvious error messages in the logs.</P><P>I can save a service definition as an .sddraft, but ArcGIS Server will then complain because it is "not an .sd file", so I can't import it.</P></BODY></HTML> Tue, 10 May 2016 20:07:07 GMT BobBistrais 2016-05-10T20:07:07Z Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484151#M18710 <HTML><HEAD></HEAD><BODY><P>I am trying to publish XY event data, either to ArcGIS Server or ArcGIS Online.&nbsp; The data comes from two tables that are joined (one table contains attributes, the other has the XY location data).&nbsp; The XY event layer derived from this works well in ArcMap, but when I try to publish in ArcGIS Server, I get the following message: 001270: Consolidating the data failed</P><P></P><P>-The data is all in a file GDB which has been registered to the ArcServer.</P></BODY></HTML> Tue, 10 May 2016 15:25:49 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484151#M18710 BobBistrais 2016-05-10T15:25:49Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)?  I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484152#M18711 <HTML><HEAD></HEAD><BODY><P>What version of ArcGIS Server are you using? </P></BODY></HTML> Tue, 10 May 2016 15:45:07 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484152#M18711 AnthonyKobah 2016-05-10T15:45:07Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484153#M18712 <HTML><HEAD></HEAD><BODY><P>Version 10.3.1 for Server and Desktop</P></BODY></HTML> Tue, 10 May 2016 15:48:58 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484153#M18712 BobBistrais 2016-05-10T15:48:58Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)?  I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484154#M18713 <HTML><HEAD></HEAD><BODY><P>Are you able to create a Service Definition file to publish from?</P><P>Do you see any additional errors in the ArcGIS Server logs (With logging set to say DEBUG)</P></BODY></HTML> Tue, 10 May 2016 16:00:03 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484154#M18713 AnthonyKobah 2016-05-10T16:00:03Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484155#M18714 <HTML><HEAD></HEAD><BODY><P>Not seeing any obvious error messages in the logs.</P><P>I can save a service definition as an .sddraft, but ArcGIS Server will then complain because it is "not an .sd file", so I can't import it.</P></BODY></HTML> Tue, 10 May 2016 20:07:07 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484155#M18714 BobBistrais 2016-05-10T20:07:07Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484156#M18715 <HTML><HEAD></HEAD><BODY><P>Some further observations-</P><P>If I remove the XY event layer, I can publish as a service</P><P>If I convert the tables to dbf and use them instead of file gdb, the service will publish (but I will need to use geodatabase in production)</P><P>Found this page in the 10.2 documentation: <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//00vp0000002r001270" title="http://resources.arcgis.com/en/help/main/10.2/index.html#//00vp0000002r001270">ArcGIS Help (10.2, 10.2.1, and 10.2.2)</A> </P><P>-it was of no help whatsoever.</P></BODY></HTML> Wed, 11 May 2016 15:00:13 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484156#M18715 BobBistrais 2016-05-11T15:00:13Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)?  I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484157#M18716 <HTML><HEAD></HEAD><BODY><P>Hi Bob, </P><P></P><P>You should be able to publish the two tables along with the XY event layer. In creating the </P><P>Sd file, use the option to not include a connection. (No available Connection). <IMG alt="Tables.png" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/199824_Tables.png" style="width: 620px; height: 607px;" />f</P></BODY></HTML> Wed, 11 May 2016 15:34:52 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484157#M18716 AnthonyKobah 2016-05-11T15:34:52Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484158#M18717 <HTML><HEAD></HEAD><BODY><P>Yes, that allowed me to to create a map service from the XY features. </P><P>Curious as to why I can't publish directly.</P><P>Ultimately, we would like to enable users to edit the attributes in the data tables online (AGOL?)&nbsp; Any specific advice or gotchas if we want to do that?</P></BODY></HTML> Wed, 11 May 2016 16:35:48 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484158#M18717 BobBistrais 2016-05-11T16:35:48Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)?  I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484159#M18718 <HTML><HEAD></HEAD><BODY><P>Hi Bob, </P><P></P><P>Glad that worked. Try restarting the Publishing Tools in Server, then create a new map document and then attempt the </P><P>direct publishing process&nbsp; again. </P><P></P><P>--Anthony</P></BODY></HTML> Wed, 11 May 2016 16:55:57 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484159#M18718 AnthonyKobah 2016-05-11T16:55:57Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484160#M18719 <HTML><HEAD></HEAD><BODY><P>I've restarted Publishing Tools, but getting the same error when trying a direct publish, with a new MXD.&nbsp; I'm not too bothered as long as publishing from the sd file works, but curious why that is that's still giving trouble.&nbsp; I did find the following in the log, not sure if that's pointing out:</P><P>Unable to connect to the identity store using SSL. </P><P>ArcGIS Server will revert to using a non-SSL connection to the identity store and credentials will be sent in clear text. </P><P>In order to use SSL, verify that your identity store has SSL enabled.</P></BODY></HTML> Wed, 11 May 2016 18:58:27 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484160#M18719 BobBistrais 2016-05-11T18:58:27Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)?  I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484161#M18720 <HTML><HEAD></HEAD><BODY><P>One more thing, create a new connection to your ArcGIS Server (In ArcMap) using http.</P><P>Am assuming your site's protocol is set to both HTTP and HTTPS. Try publishing with the new connection. </P></BODY></HTML> Wed, 11 May 2016 19:01:59 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484161#M18720 AnthonyKobah 2016-05-11T19:01:59Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484162#M18721 <HTML><HEAD></HEAD><BODY><P>Nope, still gives the same error message as earlier.</P></BODY></HTML> Wed, 11 May 2016 19:44:06 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484162#M18721 BobBistrais 2016-05-11T19:44:06Z Re: Is it possible to publish an XY event layer to Arc Server (or ArcGIS Online)? I am trying but keep getting this error: 001270: Consolidating the data failed https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484163#M18722 <HTML><HEAD></HEAD><BODY><P>Hi, it`s works in arcgis 10? it`s posibble to set a No available Connection</P></BODY></HTML> Tue, 29 Aug 2017 13:34:18 GMT https://community.esri.com/t5/arcgis-enterprise-questions/is-it-possible-to-publish-an-xy-event-layer-to-arc/m-p/484163#M18722 FernandoGonzales 2017-08-29T13:34:18Z