ERROR 999999 during Web Layer Share ArcGIS Pro 3.0.1

[LeonardoOrazi]

Hello to the community,

We have a problem with publishing a web layer. The process fails and a ERROR 999999 error is reported during the Staging phase.

LeonardoOrazi_3-1679995372067.png

We have isolated the Layer causing the problem, it is an XY Event Type data source layer imported from a SQL Server DB table (registered and non-geospatial database).

LeonardoOrazi_1-1679995265002.png

When we proceed in ArcGIS pro to add a join with a view (not a table) always in the same database, the layer changes the data source to Enterprise Geodatabase Feature Class.

LeonardoOrazi_2-1679995289500.png

and the sharing, which was successful before the Join, gives the error mentioned above and in text here:

11:51:27       Status: Failed ErrorMessage: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. 

The Join is a simple Join on a text field.

We use all the latest version available at today:

• ArcGIS Pro latest version available today, 3.1.0
• ArcGIS Server Enterprise and Portal version 11.0

Thanks for any kind help

Leonardo Orazi

Turin - Italy

[BillFox · Accepted solution]

Hi Leonardo,

is this what you are describing?

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/make-xy-event-layer.htm

BillFox_0-1680020636545.png

[LeonardoOrazi]

Thanks Bill, I verified that the original query used like input data source doesn't have an ID from the original table to use like Object ID.

All the best

Leonardo