[fdo-users] SQL Server 2008 layers not rendering in Mapguide

[Brent Robinson]

Are there any image columns in the class's table?

If there are, does that datastore have the f_attributedefinition table. If it does, is the image column listed in f_attributedefinition.columnname?

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Bill Ten Broeck
Sent: Wednesday, July 09, 2008 10:39 AM
To: FDO Users Mail List ; brent.robinson at autodesk.com
Subject: Re: [fdo-users] SQL Server 2008 layers not rendering in Mapguide

Hey Brent.

Yes. The first error is when I simply try to view the data:

<2008-07-09T10:26:05>                   Administrator
  Error: Failed to stylize layer: FloorPlans_SQLSpatial_FMWeb
         An exception occurred in FDO component.
         RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
call methods on image.
  StackTrace:
   - MgMappingUtil.StylizeLayers line 776 file
d:\buildforgeprojects\carrera_nightly\build_32.2\ent\os\server\src\services\mapping\MappingUtil.cpp
Failed to stylize layer: FloorPlans_SQLSpatial_FMWeb
An exception occurred in FDO component.
RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot call
methods on image.


This second one is if I try just for giggles to select non-existent
entities; btw, the geometry column shows up in Studio:




<2008-07-09T10:28:08>                   Administrator
  Error: An exception occurred in FDO component.
         RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
find either column "geometry" or the user-defined function or aggregate
"geometry.STIntersects", or the name is ambiguous.
  StackTrace:
   - MgRenderingServiceHandler.ProcessOperation line 83 file
d:\buildforgeprojects\carrera_nightly\build_32.2\ent\os\server\src\services\rendering\RenderingServiceHandler.cpp
   - MgOpQueryFeatures.Execute line 125 file
d:\buildforgeprojects\carrera_nightly\build_32.2\ent\os\server\src\services\rendering\OpQueryFeatures.cpp
   - MgServerRenderingService.QueryFeatures line 647 file
d:\buildforgeprojects\carrera_nightly\build_32.2\ent\os\server\src\services\rendering\ServerRenderingService.cpp
   - MgServerRenderingService.RenderForSelection line 1252 file
d:\buildforgeprojects\carrera_nightly\build_32.2\ent\os\server\src\services\rendering\ServerRenderingService.cpp
   - MgServerSelectFeatures.SelectFeatures line 249 file
d:\buildforgeprojects\carrera_nightly\build_32.2\ent\os\server\src\services\feature\ServerSelectFeatures.cpp
An exception occurred in FDO component.
RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find either
column "geometry" or the user-defined function or aggregate
"geometry.STIntersects", or the name is ambiguous.
<2008-07-09T10:30:39>



Brent Robinson wrote:
> Hi Bill,
>
> Do any messages show up in Error.log when you try to draw the features in MapGuide?
>
> Brent.
>
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Bill Ten Broeck
> Sent: Monday, June 30, 2008 6:49 AM
> To: FDO Users Mail List
> Subject: [fdo-users] SQL Server 2008 layers not rendering in Mapguide
>
> I populated SQL Server 2008 with some data, using both Map 2009 and FME.
> Map can render both sets of data, as can FME universal viewer. Mapguide
> however does not. Mapguide sees the data in Studio, picks up the
> coordinate system (arbitrary xy) and allows creation of a layer.
> However, once I try to view the layer in a layout - nothing. The layer
> appears in the TOC, but nothing renders in the Map. I threw a PK on the
> table just for grins.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users