Skip to main content
Solved

DataUpdater not updating Oracle non spatial table


sunsilk11
Contributor
Forum|alt.badge.img+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 ?

Best answer by markatsafe

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

View original
Did this help you find an answer to your question?

3 replies

Forum|alt.badge.img+2
  • Best Answer
  • March 3, 2023

@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
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • March 3, 2023
markatsafe wrote:

@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
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • March 3, 2023
markatsafe wrote:

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

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings