[mapguide-users] Major Feature Join Problems

[Jackie Ng]

Ok, some updates.

The database I was joining to was SQL Server 2000.

In the process of preparing the problem data package, I converted the
relevant portions of the SQL Server database to MS Access, under the
assumption of the original bug description (ie, the bug still occured
despite different databases)

However when I tested this with the MS Access database, the bug disappeared
(?)

So I went into further investigation into the SQL Server 2000 database.

The problematic feature join was between a SDF file to a SQL Server 2000
view. Just as a hunch, I dumped the contents of the view into a table, and
renamed the view and table so that the SDF was now joined to a table instead
of a view. 

When I looked at the layer again, the bug once again disappeared!

Which leaves me to the following conclusion...

There is a table/view inconsistency in SQL Server 2000 with regards to
feature joins.

As a result, I'll most likely leave the original ticket closed, and open a
new one instead. The only problem is the SQL Server database is 1GB (how
could I package that?????) I can't convert it into a different database
without invalidating the bug. I'll try and reproduce the problem with a
smaller sample data to see if my theory holds any weight.

- Jackie


Jackie Ng wrote:
> 
> Hi Jason,
> 
> I'm in the process of preparing this new problem package, which I'll
> attach to that ticket.
> 
> - Jackie
> 
> 
> JasonBirch wrote:
>> 
>> Hi Jackie,
>>  
>> I closed that under the assumption that it was a problem with the
>> SHP->SDF translation in Studio.  If you are seeing the problem under
>> different circumstances, please re-open the ticket.  If you have an
>> additional package that you could create to show the problem with this
>> new data, as well as detailed (so a robot could understand) steps to
>> reproduce, then that would be good.
>>  
>> Also, if you want to provide me with a link off-list to download the
>> original SHP files, I'd be happy to run them through FME, test for
>> invalid features, etc..., and give them back to you as SDF just in case
>> there's a problem with Map as well.
>>  
>> Jason
>> 
>> ________________________________
>> 
>> From: Jackie Ng
>> Subject: [mapguide-users] Major Feature Join Problems
>> 
>> 
>> 
>> I wasn't fussed about the ticket being filed invalid, because I was able
>> to
>> workaround the problem by exporting straight to SDF, instead of exporting
>> to
>> SHP -> convert to SDF at the load procedure.
>> 
>> 
>> 
>>  
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Major-Feature-Join-Problems-tf4716245s16610.html#a13482950
Sent from the MapGuide Users mailing list archive at Nabble.com.