Skip to main content
  • EN

Hi FME-Community!

I got following situation withe FeatureJoiner:

 

Left-Income: point-geometry with some attributes

 

Right-Income: polygon-geometry with some attributes

 

Attribute Conflict Resolution: Use Left

 

Geometry Handling: Use Right

The goal is to get the attributes of the left income. Everything runs fine and looks good. But as soo as we want to write to Oracle we fail. When taking a closer look to the Joined-Output features the polgons have fme_geometry=fme_point. Is this an effect of "Attribute Conflict Resolution: Use Left" with "Geometry Handling: Use Right"?!

Moreover, if we reset fme-geometry to polygon (GeometryCoercer or GeometryValidator) we still cannot write to Oracle.

 

If needed I can prepare a workspace for that.

Thanks in advance!

 

Maria

Hi @gpt_executer, I was able to reproduce the same symptom as yours and found the GeometryRefiner will repair "fme_geomarty" and "fme_type" appropriately according to the actual geometry type.

I'd recommend you to report the bug to Safe support. I have reported another bug on the FeatureJoiner, so I wait for a hot fix or 2018.1...

Another solution that'll probably work is to use a AttributeKeeper and to keep all visible attributes.

 

At least this works in esri2esri (shape or geodatabase) transformations where the geometry is changed, but the fme_geometry / fme_type are not.

Hi @takashi, unfortunatly that doesn't help.

The OracleSpatial-Writer gives back these errors.

 

We even tried to use the FeatureMerger instead, but withe the same result.

 

Without the FeatureJoiner (or FeatureMerger) the geometries can be written to Oracle properly.

Another solution that'll probably work is to use a AttributeKeeper and to keep all visible attributes.

 

At least this works in esri2esri (shape or geodatabase) transformations where the geometry is changed, but the fme_geometry / fme_type are not.
I'll try that.

 

 

Looks like you found a good one here. The team is on it.

 

 

Looks like you found a good one here. The team is on it.

 

 

It might help if you could send us in a small sample & your workspace as well to support@safe.com

 

 

You could also consider to use a GeometryRemover for the features that enter the Left port in the FeatureJoiner. It should also remove the fme_type and fme_geometry and use the geometry properties of the features entering through the Right port.

Hi @gpt_executer, thank you for bringing this to our attention. I have filed a problem report on your behalf and attached this Community post to it. I was able to reproduce the point and polygon confusion when using different tables for the attribute conflict resolution and the geometry handling.

However, when I write to Oracle, I don't seem to get any issues. Are you able to send your reproduction workspace over? Either on here or through a support ticket (please reference this Q&A; post). Please include a sample of the data that is failing to write. We'd be very interested to see how the features you're trying to write behave when sent to the Oracle Writer.

Thank you once again for bringing this to our attention. I'm sorry that you've encountered this issue with the FeatureJoiner.

Hi @takashi, unfortunatly that doesn't help.

The OracleSpatial-Writer gives back these errors.

 

We even tried to use the FeatureMerger instead, but withe the same result.

 

Without the FeatureJoiner (or FeatureMerger) the geometries can be written to Oracle properly.
Hi @gpt_executer, what parameters do you have set in the FeatureMerger?

 

I've had the same problem joining data from a non-spatial Oracle source.

screenshot-featurejoiner-oracle-writer-build18284.png

Hi @gpt_executer, thank you for bringing this to our attention. I have filed a problem report on your behalf and attached this Community post to it. I was able to reproduce the point and polygon confusion when using different tables for the attribute conflict resolution and the geometry handling.

However, when I write to Oracle, I don't seem to get any issues. Are you able to send your reproduction workspace over? Either on here or through a support ticket (please reference this Q&A; post). Please include a sample of the data that is failing to write. We'd be very interested to see how the features you're trying to write behave when sent to the Oracle Writer.

Thank you once again for bringing this to our attention. I'm sorry that you've encountered this issue with the FeatureJoiner.

Hi @gpt_executer, I am pleased to let you know that the aforementioned problem report has been resolved. You'll find the fix in our latest betas (build 18453). You can download the beta here.

Have you tried removing the "oracle_" attributes before writing (BulkAttributeRemover with attributes to remove oracle*).

It seems like the oracle attributes still indicate the object to be a point and writing to Oracle will use those attributes and not the fme_geometry and fme_type if they exist..

Reply


Community Stats

30,469
Posts
115,712
Replies
38,289
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.