[mapguide-users] Feature Joins Failing in MapGuide Open Source1.2.0

[James Card]

Running the MapGuide service on an account with network permissions does  
not help at all.

But this is even worse than I thought. Every layer I've attempted to  
create a feature join with has stopped working entirely after (seemingly)  
creating a valid join. The steps to reproduce this are:

1. Start with a valid SDF FeatureSource and LayerDefinition that are  
working properly (and doesn't include a feature join yet).

2. Create an ODBC Data Connection (I've used MySQL and SQL-Server, both  
with system DSNs and with connection strings).

3. Open your healthy FeatureSource (I've tried with polygon and polylines)  
and create a new feature join. Save and close the FeatureSource.

4. Open the LayerDefinition based on the FeatureSource you just added a  
join to. Immediately I receive an error message:

   Autodesk MapGuide Studio
   ---------------------------
   The feature source is invalid. Reason:
   An exception occurred in FDO component.
   SDF connect failed. File does not exist or cannot be opened in specified  
access mode.

    The SDF file still exists in the repository, its last-modified stamp  
has not been changed, and no external process has modified its permissions.

5. Reopen the FeatureSource with the new feature join. Editing the join  
does not work: the drop-down lists of fields from the FeatureSource and  
 from the Data Connection are both empty. Delete the join and trying to  
create a new one results in this error: "This current feature source has  
no feature classes, and cannot support joins."

All further attempts to work with that layer result in the invalid feature  
source message. I'm going to delete everything and install the package  
again so that I at least have a working map again.

-- 
James Card
California CAD Solutions, Inc.
209 578-5580


On Mon, 30 Apr 2007 07:12:22 -0700, Dave Wilson <dave.wilson at autodesk.com>  
wrote:

> What network ID do the other applications accessing the DSN connections
> use? MapGuide by default runs the service as SYSTEM which may not have
> network access to the files on the other server. If you change your
> service to log on with an account that has network and specifically
> share permissions to where the database files are on the other server
> that may help, assuming of course you haven't done this already.
>
> Regards,
> Dave
>
> -----Original Message-----
> From: James Card [mailto:James.Card at calcad.com]
> Sent: Friday, April 27, 2007 3:11 PM
> To: Dave Wilson; MapGuide Users Mail List
> Subject: Re: [mapguide-users] Feature Joins Failing in MapGuide Open
> Source1.2.0
>
> On Fri, 27 Apr 2007 13:29:37 -0700, Dave Wilson
> <dave.wilson at autodesk.com>
> wrote:
>
>> I would expect an error if it wasn't, but your MySQL must be 5.022 or
>> later because of an FDO requirement.
>
> It is MySQL 5.0.24.
>
>> The SQLServer should work. Could you try a connection string to
>> SQLServer instead?
>
> Using a connection string rather than a DSN makes no difference, for
> either the SQL_Server or the MySQL connection.
>
> --
> James Card
> California CAD Solutions, Inc.
> 209 578-5580