I am having a problem reading data from my Oracle Database. I am getting an error "There is no algorithm for assigning the given source geometry to the given target geometry, they do not match."
What does this error mean and how can I work around it?
Cheers Ian
Thanks Jerry,
I found the problem. The data was uploaded from MapInfo Tables (using EasyLoader), and although the geometeries where polylines, some contained multiple polylines (as a geometry collection or multi section line). This is represented in Oracle as a MULITLINESTRING (as WKT). These are what was causing the error.
When I corrected the problem (by simplifing the geometries), and uploaded the data to Oracle, it all worked fine. I am however having trouble adding and modifing XFM data in a Oracle connection. I keep getting that the data is locked, and I can't seem to unlock it. There are no locks on the Oracle server. We are testing performing data maintenance without setting up the features through the GSA.
Ian;
If you are usign Oracle Spatial , this looks like you may have a SDO_GEOMETRY type defined in teh table and a feature geometry type that does not match. Please make sure:
These should take care of the matching of the geometry types between the Oracle Spatia ltable and the feature types.
If you are not using Oracle Spatial, just regular realational tables, then please provide more infromation. Version, table definition, feature definition.
HTH
Jerry