Skip to main content
Question

Update smallworld with FME

  • November 24, 2023
  • 3 replies
  • 116 views

Hi everyone,

I'm new to Smallworld and FME working together.Β The only thing I'd like to achieve to update one attribute, not the geometry. I set fme_db_operation = UPDATE and I didn'tΒ give any geometry information.Β After running workspace i could see a few records being updated but translation failed with this message:

Β 

Number of Features: 1

Connecting to Smallworld on localhost:30000 using service FMENOFACTORY

Table: 'gis.point_of_interest'

NumberOfAttributes: 16

Processing a point

Error running translation.

Β 

Do you have any idea why this happens?

Β 

Many thanks

3 replies

hkingsbury
Celebrity
Forum|alt.badge.img+71
  • Celebrity
  • November 26, 2023

Does the smallworld writer have this field?

Β 

imageIf you don't want to update the geometry, you will need to set this to no. Even though you removed the geometry, your still telling the writer to update a point feature with a null geometry. This could be the cause of the issue


  • Author
  • November 27, 2023

Thank you for your answer.

Β 

My problem is that with Smallworld writer I don't have such options to set these things like I had with Oracle spatial. I only can give server name, port and alternative to use.


hkingsbury
Celebrity
Forum|alt.badge.img+71
  • Celebrity
  • November 27, 2023

Thank you for your answer.

Β 

My problem is that with Smallworld writer I don't have such options to set these things like I had with Oracle spatial. I only can give server name, port and alternative to use.

Unfortunately I don't have access to any smallworld environments to explore other options. It's probably best to reach out to support regarding this