Skip to main content

Hi, has anyone had an issue with updating a non-spatial Oracle (19) table. The table has been registered in SDE, hence has OBJECTID also.

There is no failure, but the record is not updated. If I use an SDE writer with update operation, it works fine, but takes over an hour for 300K records. I am using FME Desktop 2022.1

Any ideas ?

@sunsilk11​ if your tables are versioned then it's very unlikely updating ArcSDE tables through a native database format will work because or the ArcSDE version tables.


@sunsilk11​ if your tables are versioned then it's very unlikely updating ArcSDE tables through a native database format will work because or the ArcSDE version tables.

@Mark Stoakes​  thanks for the response.

The sde table is not versioned. There is no archiving also.

Is there a way to debug this?


@sunsilk11​ if your tables are versioned then it's very unlikely updating ArcSDE tables through a native database format will work because or the ArcSDE version tables.

I found it. User error. An issue with databaseUpdater configuration.

 


Reply