[mapserver-users] Question about oracle spatial configuration change

[David Alda Fernandez de Lezea]

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/newpass at 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: dalda at ikt.es                                web: www.ikt.es
··················································································