Skip to main content
Solved

DataUpdater not updating Oracle non spatial table

  • March 3, 2023
  • 3 replies
  • 24 views
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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • 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
  • sunsilk11Contributor
  • Author
  • Contributor
  • 66 replies
  • 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.

@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
  • sunsilk11Contributor
  • Author
  • Contributor
  • 66 replies
  • 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.

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

 

Community Stats

32,065
Posts
121,735
Replies
39,691
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.