[Fri Nov 20 12:45:37 2009].35272 CGI Request 1 on process 15866
[Fri Nov 20 12:45:37 2009].35871 msOracleSpatialLayerOpen called with: geom FROM ms_sites_onair_vw USING UNIQUE site_id SRID 8307 (Layer pointer 81ef3b8)
[Fri Nov 20 12:45:37 2009].356784 msOracleSpatialLayerOpen. Shared connection not available. Creating one.
[Fri Nov 20 12:45:37 2009].356800 msConnPoolRegister(on_air,username/password@HOST,81e9da8)
[Fri Nov 20 12:45:37 2009].375819 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:45:37 2009].375855 msOracleSpatialLayerGetItems was called.
[Fri Nov 20 12:45:37 2009].378257 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:45:37 2009].378271 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:45:37 2009].378289 msOracleSpatialLayerWhichShapes was called.
[Fri Nov 20 12:45:37 2009].378378 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT site_id, SITE_ID, INTERNAL_SITE_NAME, SWITCH_OF_HOMED_BTS, CELL_SITE_COMMON_NAME, CASCADE_ID, BTS_SWITCH_ID, BTS_TYPE, EVDO_IMPLEMENTED, DATE_EVDO_IMPLEMENTED, SITE_STATUS, BTS_ON_AIR_DATE, SITE_LINK, geom FROM ms_sites_onair_vw WHERE SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Fri Nov 20 12:45:37 2009].378384 msOracleSpatialLayerWhichShapes. Bind values: srid:8307   minx:-85.535528   miny:44.698078  maxx:-85.418426   maxy:44.841200
[Fri Nov 20 12:45:37 2009].378539 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Fri Nov 20 12:45:37 2009].382353 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Fri Nov 20 12:45:37 2009].382644 msOracleSpatialLayerWhichShapes bind by name and object.
[Fri Nov 20 12:45:37 2009].382742 msOracleSpatialLayerWhichShapes name and object now bound.
[Fri Nov 20 12:45:37 2009].817985 msOracleSpatialLayerNextShape on layer 81ef3b8, row_num: 0
[Fri Nov 20 12:45:37 2009].818136 msOracleSpatialLayerNextShape on layer 81ef3b8, row_num: 1
[Fri Nov 20 12:45:37 2009].818152 msOracleSpatialLayerNextShape on layer 81ef3b8, row_num: 2
[Fri Nov 20 12:45:37 2009].818166 msOracleSpatialLayerNextShape on layer 81ef3b8, row_num: 3
[Fri Nov 20 12:45:37 2009].819080 msOracleSpatialLayerNextShape on layer 81ef3b8, Fetched 0 more rows (3 total)
[Fri Nov 20 12:45:37 2009].828753 msOracleSpatialLayerOpen called with: geom FROM ms_sites_onair_vw USING UNIQUE site_id SRID 8307 (Layer pointer b8a4098)
[Fri Nov 20 12:45:37 2009].828849 msConnPoolRequest(on_air_copy,username/password@HOST) -> got 81e9da8
[Fri Nov 20 12:45:37 2009].830107 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:45:37 2009].830116 msOracleSpatialLayerGetItems was called.
[Fri Nov 20 12:45:37 2009].832150 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:45:37 2009].832164 msOracleSpatialLayerInitItemInfo was called.
[Fri Nov 20 12:45:37 2009].832169 msOracleSpatialLayerWhichShapes was called.
[Fri Nov 20 12:45:37 2009].832217 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT site_id, evdo_implemented, bts_switch_id, geom FROM ms_sites_onair_vw WHERE SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
[Fri Nov 20 12:45:37 2009].832223 msOracleSpatialLayerWhichShapes. Bind values: srid:8307   minx:-85.927119   miny:44.343262  maxx:-85.010276   maxy:45.115590
[Fri Nov 20 12:45:37 2009].832255 msOracleSpatialLayerWhichShapes getting ordinate definition.
[Fri Nov 20 12:45:37 2009].833113 msOracleSpatialLayerWhichShapes converting to OCIColl.
[Fri Nov 20 12:45:37 2009].833165 msOracleSpatialLayerWhichShapes bind by name and object.
[Fri Nov 20 12:45:37 2009].833180 msOracleSpatialLayerWhichShapes name and object now bound.
[Fri Nov 20 12:45:39 2009].43172 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 0
[Fri Nov 20 12:45:39 2009].43712 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 1
[Fri Nov 20 12:45:39 2009].43788 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 2
[Fri Nov 20 12:45:39 2009].43857 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 3
[Fri Nov 20 12:45:39 2009].43924 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 4
[Fri Nov 20 12:45:39 2009].43991 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 5
[Fri Nov 20 12:45:39 2009].44058 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 6
[Fri Nov 20 12:45:39 2009].44124 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 7
[Fri Nov 20 12:45:39 2009].44214 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 8
[Fri Nov 20 12:45:39 2009].44281 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 9
[Fri Nov 20 12:45:39 2009].44361 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 10
[Fri Nov 20 12:45:39 2009].44429 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 11
[Fri Nov 20 12:45:39 2009].44495 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 12
[Fri Nov 20 12:45:39 2009].44573 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 13
[Fri Nov 20 12:45:39 2009].44640 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 14
[Fri Nov 20 12:45:39 2009].44705 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 15
[Fri Nov 20 12:45:39 2009].44770 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 16
[Fri Nov 20 12:45:39 2009].44835 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 17
[Fri Nov 20 12:45:39 2009].44845 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 18
[Fri Nov 20 12:45:39 2009].44929 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 19
[Fri Nov 20 12:45:39 2009].44994 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 20
[Fri Nov 20 12:45:39 2009].45059 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 21
[Fri Nov 20 12:45:39 2009].45136 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 22
[Fri Nov 20 12:45:39 2009].45202 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 23
[Fri Nov 20 12:45:39 2009].45266 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 24
[Fri Nov 20 12:45:39 2009].45345 msOracleSpatialLayerNextShape on layer b8a4098, row_num: 25
[Fri Nov 20 12:45:39 2009].46157 msOracleSpatialLayerNextShape on layer b8a4098, Fetched 0 more rows (25 total)
[Fri Nov 20 12:45:39 2009].46165 msOracleSpatialLayerFreeItemInfo was called.
[Fri Nov 20 12:45:39 2009].46171 msOracleSpatialLayerClose was called. Layer: b8a4098, Layer name: on_air_copy. Layer connection: username/password@HOST
[Fri Nov 20 12:45:39 2009].46240 msOracleSpatialLayerClose. Cleaning layerinfo handlers.
[Fri Nov 20 12:45:39 2009].46367 msOracleSpatialLayerClose. Release the Oracle Pool.
[Fri Nov 20 12:45:39 2009].46372 msConnPoolRelease(on_air_copy,username/password@HOST,81e9da8)
[Fri Nov 20 12:45:39 2009].46387 msOracleSpatialLayerResultGetShape was called. Using the record = 0 of 3. (shape: 2216 should equal pkey: 2216)
[Fri Nov 20 12:45:39 2009].46392 msOracleSpatialLayerResultGetShape: Fetching result from DB start: 0 end:-1 record: 0
[Fri Nov 20 12:45:39 2009].90941 msOracleSpatialLayerResultGetShape: OracleSpatial error. ORA-03113: end-of-file on communication channel

[Fri Nov 20 12:45:39 2009].90956 msOracleSpatialLayerResultGetShape(): OracleSpatial error. msOracleSpatialLayerResultGetShape could not fetch specified record.
[Fri Nov 20 12:45:39 2009].90970 msDrawMap(): Image handling error. Failed to draw layer named 'on_air'.
[Fri Nov 20 12:45:39 2009].91392 msOracleSpatialLayerClose was called. Layer: 81ef3b8, Layer name: on_air. Layer connection: username/password@HOST
[Fri Nov 20 12:45:39 2009].91432 msOracleSpatialLayerClose. Cleaning layerinfo handlers.
[Fri Nov 20 12:45:39 2009].91454 msOracleSpatialLayerClose. Release the Oracle Pool.
[Fri Nov 20 12:45:39 2009].91458 msConnPoolRelease(on_air,username/password@HOST,81e9da8)
[Fri Nov 20 12:45:39 2009].91466 msOracleSpatialLayerClose was called. Layer: b8a4098, Layer name: on_air_copy. Layer connection: username/password@HOST
[Fri Nov 20 12:45:39 2009].91660 freeLayer(): freeing layer at 81ef3b8.
[Fri Nov 20 12:45:39 2009].91687 freeLayer(): freeing layer at b8a4098.
[Fri Nov 20 12:45:39 2009].91735 msConnPoolClose(username/password@HOST,81e9da8)