XY Event layer won't work

Discussion created by spatialit on May 16, 2011
Latest reply on May 31, 2011 by gilest

I'm converting a WebADF application to the REST API. It uses an XY event layer and that layer is messing up the REST service. My mxd has three layers in addition to the XY layer, so without the XY layer the ids are 0, 1, and 2 and they all work fine.

When I add the XY layer as the first layer in the mxd, refresh the service, and go to the ServiceName/MapServer page, the XY layer doesn't show up. The other layers are now ids 1, 2, and 3 - no layer 0. If I try MapServer/0 it says there is no layer 0. /1 and /2 work, but /3 doesn't. /3 gives me the display field, type, and geometry type. Under description it says "Index was outside the bounds of the array."

I found posts about problems querying and using the find task on XY layers, which implies they at least got the layer to load and display. Does anyone know what could be wrong?

I am using ArcGIS Server 9.3.1 and my XY data is in SQL Server 2008. I ran the Make Query Table tool on the XY table as suggested in a post, but it didn't help.