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

[BobBistrais]

I am trying to publish XY event data, either to ArcGIS Server or ArcGIS Online.  The data comes from two tables that are joined (one table contains attributes, the other has the XY location data).  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

-The data is all in a file GDB which has been registered to the ArcServer.

[AnthonyKobah]

What version of ArcGIS Server are you using?

[BobBistrais]

Version 10.3.1 for Server and Desktop

[AnthonyKobah]

Are you able to create a Service Definition file to publish from?

Do you see any additional errors in the ArcGIS Server logs (With logging set to say DEBUG)

[BobBistrais]

Not seeing any obvious error messages in the logs.

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.

[BobBistrais]

Some further observations-

If I remove the XY event layer, I can publish as a service

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)

Found this page in the 10.2 documentation: ArcGIS Help (10.2, 10.2.1, and 10.2.2)

-it was of no help whatsoever.

[AnthonyKobah]

Hi Bob,

You should be able to publish the two tables along with the XY event layer. In creating the

Sd file, use the option to not include a connection. (No available Connection). f

[BobBistrais]

Yes, that allowed me to to create a map service from the XY features.

Curious as to why I can't publish directly.

Ultimately, we would like to enable users to edit the attributes in the data tables online (AGOL?)  Any specific advice or gotchas if we want to do that?

[AnthonyKobah]

Hi Bob,

Glad that worked. Try restarting the Publishing Tools in Server, then create a new map document and then attempt the

direct publishing process  again.

--Anthony

[BobBistrais]

I've restarted Publishing Tools, but getting the same error when trying a direct publish, with a new MXD.  I'm not too bothered as long as publishing from the sd file works, but curious why that is that's still giving trouble.  I did find the following in the log, not sure if that's pointing out:

Unable to connect to the identity store using SSL.

ArcGIS Server will revert to using a non-SSL connection to the identity store and credentials will be sent in clear text.

In order to use SSL, verify that your identity store has SSL enabled.