Topic: SingleSpecies Map not working
The maps have not been working for a couple of days now. A query like this...
https://gis.nbn.org.uk/SingleSpecies/NH … magesize=4
...returns an error containing the following exception...
msDrawMap(): Image handling error. Failed to draw layer named 'Grid-10km'.
msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL statement: SELECT [geom],convert(varchar(36), [identifier]) from (select geom.STCentroid() [geom], [dbo].[Feature].[identifier] from [dbo].[Feature] with (INDEX(sidx_Feature_geom)) join (select distinct [alias_11105611].[FEATUREID] from ((select [dbo].[MappingDataPublic].[featureID] [FEATUREID] from [dbo].[MappingDataPublic] join [dbo].[TaxonTree] on [dbo].[TaxonTree].[childPTVK] = [dbo].[MappingDataPublic].[pTaxonVersionKey] where ([dbo].[TaxonTree].[nodePTVK] = 'NHMSYS0000530681' and [dbo].[MappingDataPublic].[absence] = 0 and [dbo].[MappingDataPublic].[resolutionID] = 1)) union all (select [dbo].[MappingDataEnhanced].[featureID] from [dbo].[MappingDataEnhanced] join [dbo].[TaxonTree] on [dbo].[TaxonTree].[childPTVK] = [dbo].[MappingDataEnhanced].[pTaxonVersionKey] join [dbo].[UserTaxonObservationID] on [dbo].[UserTaxonObservationID].[observationID] = [dbo].[MappingDataEnhanced].[id] where ([dbo].[TaxonTree].[nodePTVK] = 'NHMSYS0000530681' and [dbo].[UserTaxonObservationID].[userID] = 1 and [dbo].[MappingDataEnhanced].[absence] = 0 and [dbo].[MappingDataEnhanced].[resolutionID] = 1))) [alias_11105611]) [alias_23491131] on [dbo].[Feature].[id] = [alias_23491131].[FEATUREID]) AS foo WHERE geom.STIntersects(geometry::STGeomFromText('POLYGON((-14.0555598402195 49.1178643161011,4.53864053218213 49.1178643161011,4.53864053218213 61.569739031998,-14.0555598402195 61.569739031998,-14.0555598402195 49.1178643161011))',4326)) = 1
-[Microsoft][ODBC SQL Server Driver][SQL Server]The query processor could not produce a query plan for a query with a spatial index hint. Reason: Could not find required binary spatial method in a condition. Try removing the index hints or removing SET FORCEPLAN.