Hi list, We were working with mapserver 5.6.1 and oracle spatial, and we have change the user (the new one has less privileges - it cannot modify anything stored in the DB) that connects to oracle spatial, and now we cannot connect to the layers stored in oracle. We get the following message:
[Wed Jul 14 14:01:29 2010].755000 CGI Request 1 on process 2648 [Wed Jul 14 14:01:30 2010].380000 msOracleSpatialLayerGetItems(): Query error. Cannot retrieve column list [Wed Jul 14 14:01:30 2010].380000 msDrawMap(): Image handling error. Failed to draw layer named 'provincias'. [Wed Jul 14 14:01:30 2010].380000 mapserv request processing time (msLoadMap not incl.): 0.625s [Wed Jul 14 14:01:30 2010].380000 msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:32 2010].520000 CGI Request 1 on process 1924 [Wed Jul 14 14:01:32 2010].661000 msOracleSpatialLayerGetItems(): Query error. Cannot retrieve column list [Wed Jul 14 14:01:32 2010].661000 msDrawMap(): Image handling error. Failed to draw layer named 'provincias'. [Wed Jul 14 14:01:32 2010].661000 mapserv request processing time (msLoadMap not incl.): 0.141s [Wed Jul 14 14:01:32 2010].661000 msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].36000 CGI Request 1 on process 2408 [Wed Jul 14 14:01:33 2010].161000 msOracleSpatialLayerGetItems(): Query error. Cannot retrieve column list [Wed Jul 14 14:01:33 2010].161000 msDrawMap(): Image handling error. Failed to draw layer named 'provincias'. [Wed Jul 14 14:01:33 2010].161000 mapserv request processing time (msLoadMap not incl.): 0.125s [Wed Jul 14 14:01:33 2010].161000 msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].505000 CGI Request 1 on process 2064 [Wed Jul 14 14:01:33 2010].677000 msOracleSpatialLayerGetItems(): Query error. Cannot retrieve column list [Wed Jul 14 14:01:33 2010].677000 msDrawMap(): Image handling error. Failed to draw layer named 'provincias'. [Wed Jul 14 14:01:33 2010].677000 mapserv request processing time (msLoadMap not incl.): 0.172s [Wed Jul 14 14:01:33 2010].677000 msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].989000 CGI Request 1 on process 3216 [Wed Jul 14 14:01:34 2010].130000 msOracleSpatialLayerGetItems(): Query error. Cannot retrieve column list [Wed Jul 14 14:01:34 2010].130000 msDrawMap(): Image handling error. Failed to draw layer named 'provincias'. [Wed Jul 14 14:01:34 2010].130000 mapserv request processing time (msLoadMap not incl.): 0.141s [Wed Jul 14 14:01:34 2010].130000 msFreeMap(): freeing map at 019AB590. Do we have to refresh something or do somethign else? Layer config: CONNECTIONTYPE oraclespatial CONNECTION "newuser/newp...@ora10gex" If configure the layer with the old user, it works. Thanks. Un saludo, ·················································································· David Alda Fernández de Lezea Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad IKT Granja Modelo s/n · 01192 · Arkaute (Araba) ·················································································· Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 ·················································································· email: [email protected] web: www.ikt.es ·················································································· _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
