Hi list. I have a strange error with WFS POST query on mapserver 6.0
and Oracle 10g. I have two queries that it gives me the same number of
records. But the first one crash and I try to find why? Is this a
problem with data, with my query or a bug? <br>
<br>Here mapserver log...<br><br>This one crash:<br><br>[Thu
Jun 16 10:47:46 2011].849332 msOracleSpatialLayerWhichShape<div>s. Using
this Sql to retrieve the data: SELECT IDMAO, NO_PERM, NO_PERM_LOCA_NUM,
NO_PERM_EXPL, NOPCL, NODIAG, MES_TYPE, PCL_TYPE, SUP_CUL, SUP_NOR,
SUP_TOT, SUP_HA, NOPCLTRI, DRAINAGE, NO_PERM_NUM, PROCOD, PRCSUPMAO,
SUPMAO, SUPDECL, SUPMAOORI, ASSURE, NB_CULT, VOLSRCCMS, DGN,
LOD_LOCANUM, STATUT, STATUT_X, ANNEE, IDTRANS, DT_PROD, DT_MOD, DT_VAL,
USG_PROD, USG_MOD, USG_VAL, VER_NORME, ECL_NUM, IDIMG_1, IDIMG_2,
IDIMG_3, IDIMG_4, CTD_X, CTD_Y, CTD_Z, FUSEAU, CODGEO, MUS_CO_GEO,
CODUTM, ZCOL1, ZCOL3, DESCRIPTION, SHAPEOID, SAS_SHAPEOID, CDS_SHAPEOID,
CDX_ID, SAD_ID, SAM_ID, SAX_ID, NOP_SHAPEOID, OBJECTID, VERSION,
ID_TERR, rownum, geom FROM sagr_v_sdo WHERE ( (NO_PERM_NUM= 82776)
AND ( (NODIAG= 1) AND ( (ANNEE= 2011) AND (STATUT= 'ACT') ) ) )<br>
[Thu Jun 16 10:47:46 2011].849348 msOracleSpatialLayerWhichShapes. Bind
values: srid:4326 minx:-83.414878 miny:42.585122 maxx:-53.585122
maxy:63.414878<br>
[Thu Jun 16 10:47:46 2011].849457 msOracleSpatialLayerWhichShapes getting ordinate definition.<br>
[Thu Jun 16 10:47:46 2011].851214 msOracleSpatialLayerWhichShapes converting to OCIColl.<br>
[Thu Jun 16 10:47:46 2011].851440 msOracleSpatialLayerWhichShapes bind by name and object.<br>
[Thu Jun 16 10:47:46 2011].851456 msOracleSpatialLayerWhichShapes name and object now bound.<br>
[Thu Jun 16 10:47:47 2011].256210 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 0<br>
[Thu Jun 16 10:47:47 2011].256472 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 1<br>
[Thu Jun 16 10:47:47 2011].256553 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 2<br>
[Thu Jun 16 10:47:47 2011].256652 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 3<br>
[Thu Jun 16 10:47:47 2011].256792 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 4<br>
[Thu Jun 16 10:47:47 2011].256871 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 5<br>
[Thu Jun 16 10:47:47 2011].256954 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 6<br>
[Thu Jun 16 10:47:47 2011].257033 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 7<br>
[Thu Jun 16 10:47:47 2011].257119 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 8<br>
[Thu Jun 16 10:47:47 2011].257208 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 9<br>
[Thu Jun 16 10:47:47 2011].257279 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 10<br>
[Thu Jun 16 10:47:47 2011].257358 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 11<br>
[Thu Jun 16 10:47:47 2011].257428 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 12<br>
[Thu Jun 16 10:47:47 2011].257497 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 13<br>
[Thu Jun 16 10:47:47 2011].257583 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 14<br>
[Thu Jun 16 10:47:47 2011].257675 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 15<br>
[Thu Jun 16 10:47:47 2011].257763 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 16<br>
[Thu Jun 16 10:47:47 2011].257838 msOracleSpatialLayerNextShape on layer 0x8553318, row_num: 17<br>
[Thu Jun 16 10:47:47 2011].258352 msOracleSpatialLayerNextShape on layer 0x8553318, Fetched 0 more rows (17 total)<br>
[Thu Jun 16 10:47:47 2011].261058 msOracleSpatialLayerGetShape was
called. Using the record = 0 of 17. (shape: 5028718 should equal pkey:
5028718)<br>
[Thu Jun 16 10:47:47 2011].261084 msOracleSpatialLayerGetShape: Fetching result from DB start: 0 end:-1 record: 0<br>
[Thu Jun 16 10:47:50 2011].978549 msOracleSpatialLayerGetShape:
OracleSpatial error. ORA-03113: fin de fichier sur canal de
communication<br>
<br>
[Thu Jun 16 10:47:50 2011].978584 msOracleSpatialLayerGetShape():
OracleSpatial error. msOracleSpatialLayerGetShape could not fetch
specified record.<br clear="all"><br><br><br>This one work fine ...<br><br>[Thu Jun 16 10:55:51 2011].403830 msOracleSpatialLayerWhichShapes.
Using this Sql to retrieve the data: SELECT IDMAO, NO_PERM,
NO_PERM_LOCA_NUM, NO_PERM_EXPL, NOPCL, NODIAG, MES_TYPE, PCL_TYPE,
SUP_CUL, SUP_NOR, SUP_TOT, SUP_HA, NOPCLTRI, DRAINAGE, NO_PERM_NUM,
PROCOD, PRCSUPMAO, SUPMAO, SUPDECL, SUPMAOORI, ASSURE, NB_CULT,
VOLSRCCMS, DGN, LOD_LOCANUM, STATUT, STATUT_X, ANNEE, IDTRANS, DT_PROD,
DT_MOD, DT_VAL, USG_PROD, USG_MOD, USG_VAL, VER_NORME, ECL_NUM, IDIMG_1,
IDIMG_2, IDIMG_3, IDIMG_4, CTD_X, CTD_Y, CTD_Z, FUSEAU, CODGEO,
MUS_CO_GEO, CODUTM, ZCOL1, ZCOL3, DESCRIPTION, SHAPEOID, SAS_SHAPEOID,
CDS_SHAPEOID, CDX_ID, SAD_ID, SAM_ID, SAX_ID, NOP_SHAPEOID, OBJECTID,
VERSION, ID_TERR, rownum, geom FROM sagr_v_sdo WHERE ( (NO_PERM_NUM=
82776) AND ( (ANNEE= 2011) AND (STATUT= 'ACT') ) )<br>
[Thu Jun 16 10:55:51 2011].403847 msOracleSpatialLayerWhichShapes. Bind values: srid:4326 minx:-83.414878 miny:42.585122 maxx:-53.585122 maxy:63.414878<br>[Thu Jun 16 10:55:51 2011].403955 msOracleSpatialLayerWhichShapes getting ordinate definition.<br>
[Thu Jun 16 10:55:51 2011].405614 msOracleSpatialLayerWhichShapes converting to OCIColl.<br>[Thu Jun 16 10:55:51 2011].405910 msOracleSpatialLayerWhichShapes bind by name and object.<br>[Thu Jun 16 10:55:51 2011].405928 msOracleSpatialLayerWhichShapes name and object now bound.<br>
[Thu Jun 16 10:55:51 2011].811085 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 0<br>[Thu Jun 16 10:55:51 2011].811347 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 1<br>[Thu Jun 16 10:55:51 2011].811450 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 2<br>
[Thu Jun 16 10:55:51 2011].811546 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 3<br>[Thu Jun 16 10:55:51 2011].811636 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 4<br>[Thu Jun 16 10:55:51 2011].811708 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 5<br>
[Thu Jun 16 10:55:51 2011].811779 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 6<br>[Thu Jun 16 10:55:51 2011].811864 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 7<br>[Thu Jun 16 10:55:51 2011].811936 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 8<br>
[Thu Jun 16 10:55:51 2011].812020 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 9<br>[Thu Jun 16 10:55:51 2011].812110 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 10<br>[Thu Jun 16 10:55:51 2011].812190 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 11<br>
[Thu Jun 16 10:55:51 2011].812291 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 12<br>[Thu Jun 16 10:55:51 2011].812371 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 13<br>[Thu Jun 16 10:55:51 2011].812519 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 14<br>
[Thu Jun 16 10:55:51 2011].812623 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 15<br>[Thu Jun 16 10:55:51 2011].812701 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 16<br>[Thu Jun 16 10:55:51 2011].812804 msOracleSpatialLayerNextShape on layer 0x87b42a0, row_num: 17<br>
[Thu Jun 16 10:55:51 2011].813314 msOracleSpatialLayerNextShape on layer 0x87b42a0, Fetched 0 more rows (17 total)<br>[Thu
Jun 16 10:55:51 2011].815880 msOracleSpatialLayerGetShape was called.
Using the record = 0 of 17. (shape: 5028720 should equal pkey: 5028720)<br>
[Thu Jun 16 10:55:51 2011].815906 msOracleSpatialLayerGetShape: Fetching result from DB start: 0 end:-1 record: 0<br>[Thu
Jun 16 10:55:51 2011].819632 msOracleSpatialLayerGetShape was called.
Using the record = 1 of 17. (shape: 5028721 should equal pkey: 5028721)<br>
[Thu Jun 16 10:55:51 2011].820750 msOracleSpatialLayerGetShape was
called. Using the record = 2 of 17. (shape: 5028722 should equal pkey:
5028722)<br>[Thu Jun 16 10:55:51 2011].821585
msOracleSpatialLayerGetShape was called. Using the record = 3 of 17.
(shape: 5028723 should equal pkey: 5028723)<br>
[Thu Jun 16 10:55:51 2011].822336 msOracleSpatialLayerGetShape was
called. Using the record = 4 of 17. (shape: 5028724 should equal pkey:
5028724)<br>[Thu Jun 16 10:55:51 2011].822934
msOracleSpatialLayerGetShape was called. Using the record = 5 of 17.
(shape: 5028725 should equal pkey: 5028725)<br>
[Thu Jun 16 10:55:51 2011].823609 msOracleSpatialLayerGetShape was
called. Using the record = 6 of 17. (shape: 5028726 should equal pkey:
5028726)<br>[Thu Jun 16 10:55:51 2011].824308
msOracleSpatialLayerGetShape was called. Using the record = 7 of 17.
(shape: 5028727 should equal pkey: 5028727)<br>
[Thu Jun 16 10:55:51 2011].824912 msOracleSpatialLayerGetShape was
called. Using the record = 8 of 17. (shape: 5028728 should equal pkey:
5028728)<br>[Thu Jun 16 10:55:51 2011].825664
msOracleSpatialLayerGetShape was called. Using the record = 9 of 17.
(shape: 5028729 should equal pkey: 5028729)<br>
[Thu Jun 16 10:55:51 2011].826465 msOracleSpatialLayerGetShape was
called. Using the record = 10 of 17. (shape: 5028730 should equal pkey:
5028730)<br>[Thu Jun 16 10:55:51 2011].827179
msOracleSpatialLayerGetShape was called. Using the record = 11 of 17.
(shape: 5028731 should equal pkey: 5028731)<br>
[Thu Jun 16 10:55:51 2011].827928 msOracleSpatialLayerGetShape was
called. Using the record = 12 of 17. (shape: 5028733 should equal pkey:
5028733)<br>[Thu Jun 16 10:55:51 2011].828699
msOracleSpatialLayerGetShape was called. Using the record = 13 of 17.
(shape: 5028715 should equal pkey: 5028715)<br>
[Thu Jun 16 10:55:51 2011].830029 msOracleSpatialLayerGetShape was
called. Using the record = 14 of 17. (shape: 5028714 should equal pkey:
5028714)<br>[Thu Jun 16 10:55:51 2011].831003
msOracleSpatialLayerGetShape was called. Using the record = 15 of 17.
(shape: 5028717 should equal pkey: 5028717)<br>
[Thu Jun 16 10:55:51 2011].831687 msOracleSpatialLayerGetShape was
called. Using the record = 16 of 17. (shape: 5028718 should equal pkey:
5028718)<br>[Thu Jun 16 10:55:51 2011].832687 msOracleSpatialLayerClose
was called. Layer: 0x87b42a0, Layer name: SAGR_V_SDO. Layer connection:
zzz/zzz@zzz<br>
[Thu Jun 16 10:55:51 2011].833843 msOracleSpatialLayerClose. Cleaning layerinfo handlers.<br><br><br>thank's a lot<br><br><br>-- <br>Simon Mercier<br>Consultant en géomatique<div><div>
<a href="http://www.mgeospatial.com/" target="_blank">www.mgeospatial.com</a><br>linkedIn : <a href="http://ca.linkedin.com/in/simonmercier" target="_blank">http://ca.linkedin.com/in/simonmercier</a><br>twitter : <a href="http://twitter.com/simonmercier" target="_blank">http://twitter.com/simonmercier</a></div>
</div></div>