[mapserver-users] OGR connection failed - OCI

[GeoLady]

Hi Jeff,

I made some progress. I gave the highest permission in IIS for mapserver and
I have different error.
In my browser I see "this page can't be displayed". This is MS log>

[Thu May 25 14:53:20 2017].96000 CGI Request 1 on process 2400
[Thu May 25 14:53:20 2017].96000 msDrawMap(): rendering using outputformat
named png (AGG/PNG).
[Thu May 25 14:53:20 2017].96000 msDrawMap(): WMS/WFS set-up and query,
0.000s
[Thu May 25 14:53:20 2017].112000
msOGRFileOpen(OCI:user/pass at host:port/SID)...
[Thu May 25 14:53:20 2017].112000 OGROPen(OCI:user/pass at host:port/SID)
[Thu May 25 15:06:55 2017].504000
msConnPoolRegister(ULICE,OCI:user/pass at host:port/SID,000000BFB13E7630)
[Thu May 25 15:06:55 2017].520000 msOGRFileWhichShapes: Setting spatial
filter to -422441 -1246790.34474124 -419074 -1245109.65525876
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=0,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=1,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=2,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=3,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=4,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=5,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=6,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=7,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=8,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=9,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=10,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=11,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=12,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=13,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=14,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning shape=15,
tile=0
[Thu May 25 15:06:55 2017].520000 msOGRFileNextShape: Returning MS_DONE (no
more shapes)
[Thu May 25 15:06:55 2017].520000
msOGRLayerClose(OCI:user/pass at host:port/SID).
[Thu May 25 15:06:55 2017].520000
msOGRFileClose(OCI:user/pass at host:port/SID,64).
[Thu May 25 15:06:55 2017].520000
msConnPoolRelease(ULICE,OCI:user/pass at host:port/SID,000000BFB13E7630)
[Thu May 25 15:06:55 2017].520000
msConnPoolClose(OCI:user/pass at host:port/SID,000000BFB13E7630)
[Thu May 25 15:06:55 2017].520000 msDrawMap(): Layer 0 (ULICE), 815.424s
[Thu May 25 15:06:55 2017].520000 msDrawMap(): Drawing Label Cache, 0.000s
[Thu May 25 15:06:55 2017].520000 msDrawMap() total time: 815.424s
[Thu May 25 15:06:55 2017].535000 msSaveImage(stdout) total time: 0.015s
[Thu May 25 15:06:55 2017].535000 mapserv request processing time (msLoadMap
not incl.): 815.439s
[Thu May 25 15:06:55 2017].535000 msFreeMap(): freeing map at
000000BFB13387E0.
[Thu May 25 15:06:55 2017].535000 freeLayer(): freeing layer at
000000BFB1341590.

Some other information: my oracle table is registered in sdo_geom_metadata,
has spatial index, has srid=2065.
I have the same data in shapefile and MS draws a map successfully.

Can you help me please ? Thanks a lot.



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/OGR-connection-failed-OCI-tp5321449p5321900.html
Sent from the Mapserver - User mailing list archive at Nabble.com.