I have an ArcGIS Server 10.0 for Java running under Red Hat Linux. I would like to be able to publish a Map Document that I have created which has a working Query Layer connecting to Oracle 11g. In ArcMap the layer works as expected. I have installed all the Oracle client software on the ArcGIS Server (the server is actually running Oracle also). I am able to connect via SQL Plus as the ArcGIS server user. I have set all the environment variables to the best of my knowledge. However when I publish the Map Document I get the following in the log
WARNING The Layer:'XXXXXXXX' in Map:'Layers' is invalid. No SDEHOME environment variable set WARNING The Layer:'XXXXXXXX' in Map:'Layers' is invalid. No SDEHOME environment variable set
INFO3 Server Object instance on machine XXXXXXXX is created with errors. The Layer:'XXXXXXX' in Map:'Layers' is invalid. No SDEHOME environment variable set INFO3 Server Object instance on machine XXXXXXXX is created with errors. The Layer:'XXXXXXX' in Map:'Layers' is invalid. No SDEHOME environment variable set
I don't have ArcSDE installed and I thought the idea of Query Layers was that you didn't need it? Very confused and Google didn't turn up much :-(
Any help would be most appreciated.
Regards
Colin