Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I'm using a Postgres table but it doesn't have an oid field. Now that I think about it I think I got around this by specifically creating an OID field. I'll have another look thanks.
So at present it takes ArcGIS Server on Windows and ArcGIS Desktop just over a second to render the map with the Query layer. Under Linux the ArcGIS Server Manager just sits there forever failing to render the preview.
So this has helped. By installing the 32 bit Oracle Client drivers the errors go away. The last message in the log is INFO3 Beginning of layer draw: XXXXXXXX however it seems to be taking an awful long time to draw the layer. I will mess around with the layer and see if I can fix it. This article was the golden nugget however.
I'm not using direct connections I'm using a Query Layer and it works first time on Windows so there must be something missing in my Linux configuration. Or the Linux ArcGIS server doesn't support this.
I'm not using SDE at all and I'm assuming I don't need to because I'm using a Query Layer? The layer works perfectly in ArcMap but not in ArcGIS Server. I'm pretty new at this so not sure how this works exactly. From what I've read using Query Layers allows you to get round using ArcSDE so I'm not sure why the error message comes up. I'm going to try it on ArcGIS Server for Windows as it wouldn't surprise me if this was a Linux issue.
