[mapguide-users] ODBC connection: No points shown

Fri Mar 16 05:38:58 EDT 2012

Thank you, Jonathon.

As long as i don't add a geometry i can preview the data correctly.
But the points don't show up in the preview when i added the geometry. It says: "An exception occurred in FDO component. Internal error "

The corresponding log message looks like this:

<2012-03-16T10:12:47>  1240 MapGuide Developer 127.0.0.1 Administrator
 Error: An exception occurred in FDO component.
        Internal error
 StackTrace:
  - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\builds\mg22win32\mgdev\server\src\services\feature\FeatureServiceHandler.cpp
  - MgOpSelectFeatures.Execute() line 109 file c:\builds\mg22win32\mgdev\server\src\services\feature\OpSelectFeatures.cpp
  - MgServerFeatureService.SelectFeatures() line 433 file c:\builds\mg22win32\mgdev\server\src\services\feature\ServerFeatureService.cpp
  - MgServerSelectFeatures.SelectFeatures() line 266 file c:\builds\mg22win32\mgdev\server\src\services\feature\ServerSelectFeatures.cpp

I have set the same coordinate system as in my map. I also tried a X-Y Meter coordinate system.

The primary key indeed should be int32. FDO Toolbox and Autocad Map show this correctly, while Maestro is showing int64.
I have edited the config.xml. I deleted the primary key element and took another suitable property as the primary key. It had no effect.

What could be done in addition to prevent this error?
In my view that i'm accessing there are also the tables dtproperties, sysconstraints and syssegments next to the table that i need for the points.
Are they of any importance when accessing the table with the points? Just for testing i deleted them in the config.xml so that only my points-table remained. But still, the same error.

Regards,
Jan

________________________________
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GIS4U
Sent: Thursday, March 15, 2012 7:30 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] ODBC connection: No points shown

Does the information show up in your Data Source when you preview?

If so, do you have a coordinate system set so that MG can reference it to the map? If not, make sure to set it.

If so, I would suspect that the primary key as int64 may be the issue. I think you would be safer with int32. Given the FDO error message, I am thinking this is the culprit...

Regards,
Jonathon

On Thu, Mar 15, 2012 at 8:28 AM, von Wartburg, Jan BKSD <Jan.vonWartburg at bl.ch<mailto:Jan.vonWartburg at bl.ch>> wrote:
Hello all,

I have connected to a SQL server 2000 database using the ODBC provider. I have configured the tables in order to get the right columns for the X and Y values (stored as "double" in the database, primary key is int64). After creating a layer using this feature source, the points should show up in my map, but they don't. I'm using MGOS 2.2 and Maestro 4.0.0 on Windows XP.
In the server error log I have the following entry:

<2012-03-15T15:41:00>  1712 Ajax Viewer 127.0.0.1 Administrator
 Error: Failed to stylize layer: test
        An exception occurred in FDO component.
        Internal error
 StackTrace:
  - MgMappingUtil.StylizeLayers() line 831 file c:\builds\mg22win32\mgdev\server\src\services\mapping\MappingUtil.cpp

The feature xml looks like this:

<?xml version="1.0" encoding="utf-8"?>
<FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
  <Provider>OSGeo.ODBC</Provider>
  <Parameter>
    <Name>ConnectionString</Name>
    <Value>DSN=ADAM;Uid=sd3;Pwd=adff;</Value>
  </Parameter>
  <SupplementalSpatialContextInfo>
    <Name>Default</Name>
    <CoordinateSystem>PROJCS["CH1903 / LV03",GEOGCS["CH1903",DATUM["CH1903",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[674.374,15.056,405.346,0,0,0,0],AUTHORITY["EPSG","6149"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4149"]],PROJECTION["Hotine_Oblique_Mercator"],PARAMETER["latitude_of_center",46.95240555555556],PARAMETER["longitude_of_center",7.439583333333333],PARAMETER["azimuth",90],PARAMETER["rectified_grid_angle",90],PARAMETER["scale_factor",1],PARAMETER["false_easting",600000],PARAMETER["false_northing",200000],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","21781"]]</CoordinateSystem>
  </SupplementalSpatialContextInfo>
  <ConfigurationDocument>config.xml</ConfigurationDocument>
</FeatureSource>

Can anyone help?

Thanks&Regards,
Jan

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/mapguide-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20120316/8b980a19/attachment.html