AW: [UMN_MAPSERVER-USERS] Error in drawquery with OracleSpatiall

Tue Apr 24 06:38:07 PDT 2007

Hi Fernando,

thanks for your reply.
I use a query to get information about the objects selected and
highlight these objects. 

// resArr1 is an array with the ID´s selected

foreach($resArr1 as $ID) {   
    @$mysearchLayer->queryByAttributes("EID", "EID = " . $ID,
MS_MULTIPLE);
}
$ANZ = $mysearchLayer->getNumResults();
.
.
//Setting the map-extends
.
.
$img = $gpoMap->drawQuery();     // this is the line with der Error

And here´s the log. Ist very long, but i dont want to delete important
information

First call with zoom 

[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen. Shared connection not available. Creating
one.\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,023F3660)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
SELECT EID, SK, GEOM FROM SDOUSER.TABLEITUNG WHERE SDO_FILTER( GEOM,
MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340895
3.56,5712292.86,3409605.88,5712782.1) ),'querytype=window') = 'TRUE'\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,023F3660)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msConnPoolClose(sdouser/sdouser at GIERSEDB,023F3660)\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:04 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php

Second call with query

[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen. Shared connection not available. Creating
one.\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,021E8588)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
SELECT EID, SK, GEOM FROM SDOUSER.TABLEITUNG WHERE SDO_FILTER( GEOM,
MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340930
8.86,5712666.1,3409328.86,5712686.1) ),'querytype=window') = 'TRUE'\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,021E8588)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolClose(sdouser/sdouser at GIERSEDB,021E8588)\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen. Shared connection not available. Creating
one.\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,02644528)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetItems was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetShape was called. Using the record = 38752.\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetShape. Sql: SELECT X_MANUEL, NAME, LAENGE, SK,
EID, SCHACHTOBE, SCHACHTUNT, STRASSE, MATERIAL, PROFILART, PROFILBREI,
PROFILHOEH, BAUJAHR, HYDRANG, KOSTENSTEL, X1, Y1, X2, Y2, OBEN, UNTEN,
ENTWAESSER, SOHLEOBEN, SOHLEUNTEN, NETZ, GEOM FROM SDOUSER.TABLEITUNG
WHERE EID = 38752\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,02644528)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolClose(sdouser/sdouser at GIERSEDB,02644528)\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen. Shared connection not available. Creating
one.\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,02621B50)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
SELECT EID, SK, EID, GEOM FROM SDOUSER.TABLEITUNG WHERE EID = 38752 AND
SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340466
2,5706718.13,3418395,5717017.88) ),'querytype=window') = 'TRUE'\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,02621B50)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolClose(sdouser/sdouser at GIERSEDB,02621B50)\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen. Shared connection not available. Creating
one.\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetItems was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetShape was called. Using the record = 38752.\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetShape. Sql: SELECT X_MANUEL, NAME, LAENGE, SK,
EID, SCHACHTOBE, SCHACHTUNT, STRASSE, MATERIAL, PROFILART, PROFILBREI,
PROFILHOEH, BAUJAHR, HYDRANG, KOSTENSTEL, X1, Y1, X2, Y2, OBEN, UNTEN,
ENTWAESSER, SOHLEOBEN, SOHLEUNTEN, NETZ, GEOM FROM SDOUSER.TABLEITUNG
WHERE EID = 38752\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
SELECT EID, SK, EID, GEOM FROM SDOUSER.TABLEITUNG WHERE EID = 38752 AND
SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340466
2,5706718.13,3418395,5717017.88) ),'querytype=window') = 'TRUE'\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolClose(sdouser/sdouser at GIERSEDB,026136F8)\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen. Shared connection not available. Creating
one.\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRegister(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetItems was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetShape was called. Using the record = 38752.\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerGetShape. Sql: SELECT X_MANUEL, NAME, LAENGE, SK,
EID, SCHACHTOBE, SCHACHTUNT, STRASSE, MATERIAL, PROFILART, PROFILBREI,
PROFILHOEH, BAUJAHR, HYDRANG, KOSTENSTEL, X1, Y1, X2, Y2, OBEN, UNTEN,
ENTWAESSER, SOHLEOBEN, SOHLEUNTEN, NETZ, GEOM FROM SDOUSER.TABLEITUNG
WHERE EID = 38752\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerOpen called with: GEOM FROM SDOUSER.TABLEITUNG USING
UNIQUE EID\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerInitItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
SELECT EID, SK, GEOM FROM SDOUSER.TABLEITUNG WHERE SDO_FILTER( GEOM,
MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(340895
3.56,5712292.86,3409605.88,5712782.1) ),'querytype=window') = 'TRUE'\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerFreeItemInfo was called.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose. Cleaning Oracle handlers.\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolRelease(tableitung,sdouser/sdouser at GIERSEDB,026136F8)\r,
referer: http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msConnPoolClose(sdouser/sdouser at GIERSEDB,026136F8)\r, referer:
http://localhost/hst/map75.php
[Tue Apr 24 15:32:57 2007] [error] [client 127.0.0.1]
msOracleSpatialLayerClose was called. Layer connection:
sdouser/sdouser at GIERSEDB\r, referer: http://localhost/hst/map75.php

Best regards

Dominik Gierse, Dipl. Ing. (FH)
Softwareentwicklung	
mailto:gierse at systemtechnik.net	
Tel./Fax: +49 291 9929-70 / 7691
-----------------------------------------------------------------------	
Sitz der Gesellschaft:
HST Hydro-Systemtechnik GmbH
Sophienweg 3
D-59872 Meschede, Germany	
Tel./Fax: +49 291 9929-0 / 7691
http://www.systemtechnik.net
-----------------------------------------------------------------------	
Geschäftsführer: Dipl.-Ing. Martin Frigger, Dipl.-Ing. Richard Ernst	
Registergericht: Amtsgericht Arnsberg - HRB 3396	
UST-IDNR.: DE 191 917 337	
Steuer-Nr.: 334 5706 0269