Solved

DataUpdater not updating Oracle non spatial table


Badge +6

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 ?

icon

Best answer by markatsafe 3 March 2023, 17:34

View original

3 replies

Badge +2

@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.

Badge +6

@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?

Badge +6

@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