I think you may need to extend your DATA line to include a using Unique and refer to the key field of your SQL table
e.g. DATA "SP_GEOMETRY from SITEUNIT USING UNIQUE MI_PRINX USING SRID=27700" On Sun, Feb 28, 2010 at 8:42 AM, Afroz Kannancheri <[email protected]> wrote: > > Hi, > Tried the Tolerance parameter, now the previous error message is not > coming up anymore. > Checked the sqlserver profiler and now it recieves a valid query, but I > still get the following error on my page for the > GetFeatureInfo results: > > Layer 'region1' > Content-type: application/vnd.ogc.se_xml > <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?> > <!DOCTYPE ServiceExceptionReport SYSTEM > "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd";> > <ServiceExceptionReport version="1.1.1"> > <ServiceException> > </ServiceException> > </ServiceExceptionReport> > > > I enabled DEBUG on the layer and it logs "msMSSQL2008LayerGetShapeRandom bad > shape: 1" in the log file. > > Please find part of my layer information for your reference > > LAYER > NAME "region1" > CONNECTIONTYPE PLUGIN > PLUGIN "C:\Programs\ms4w\Apache\specialplugins\msplugin_mssql2008.dll" > > CONNECTION "server=192.168.254.34;uid=uid;pwd=pwd;database=map;Integrated > Security=false" > > DATA "geom from region1" > TYPE POLYGON > > DEBUG 0 > STATUS ON > TOLERANCE 5 > METADATA > 'wms_feature_info_mime_type' "text/html" > "ows_include_items" "all" > END > PROJECTION > "init=epsg:4326" > END > > > > Thanks and regards > Afroz > -- > View this message in context: > http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4648413.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > -- Dr James Perrins exeGesIS SDM Ltd Great House Barn New Street, Talgarth Powys LD3 0AH. Direct Line: 01646 686650 Tel: 01874 711145 Fax: 01874 711156 Email: [email protected] This E-mail and any files transmitted with it are private and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, the E-mail and any files have been transmitted to you in error and any copying, distribution or other use of the information contained in them is strictly prohibited. Nothing in this E-mail message amounts to a contractual or other legal commitment on the part of exeGesIS SDM Ltd unless confirmed by a signed communication. exeGesIS SDM Ltd will make every effort to keep its network free of viruses. However, the recipient of this message will need to scan this message, and any attachments, for viruses, as exeGesIS SDM Ltd can take no responsibility for any computer virus that might be transferred by this e-mail. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
