Skip to main content
Question

Oracle spatial writer in update mode.

  • August 23, 2013
  • 6 replies
  • 51 views
I
Forum|alt.badge.img+1
Hi,

 

 

I am trying to update a geometry of a feature stored in oracle spatial. I've set the writer mode to UPDATE also I've mentioned the key columns (combination of four colums is unque).

 

 

The workbench executes without giving any error, the log shows that it has written fatures but the geometry column does not change.

 

 

Please suggest if I am missing anything in this.

 

 

Regards

 

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

6 replies

fmelizard
Safer
Forum|alt.badge.img+20
  • fmelizardSafer
  • Safer
  • 3719 replies
  • August 23, 2013
Hi Imran,

 

 

Have you specified the target geometry column name? and made sure the update geometry contents is set to yes?

 

 

Itay

 

I
Forum|alt.badge.img+1
  • imran
  • Author
  • 14 replies
  • August 23, 2013
Yes Itay, I did that..
fmelizard
Safer
Forum|alt.badge.img+20
  • fmelizardSafer
  • Safer
  • 3719 replies
  • August 23, 2013
And the writer on none? Did you refresh the viewer?
I
Forum|alt.badge.img+1
  • imran
  • Author
  • 14 replies
  • August 23, 2013
Yes I Did..

 

And I am checking the output in the database itself.
fmelizard
Safer
Forum|alt.badge.img+20
  • fmelizardSafer
  • Safer
  • 3719 replies
  • August 23, 2013
A database also needs to be refreshed, but my guess is that you are doiing that too?

 

 

mmm I am running out of ideas then.....since you mention that the translation is succesful  I find it hard to believe that the update is not taking place.

 

 

I have many workspaces updating oracle data on a daily basis and it works like a charm.

 

 

Can you  provide more detalis? (log filsnap shot)
I
Forum|alt.badge.img+1
  • imran
  • Author
  • 14 replies
  • August 27, 2013
Hi Itay,

 

 

The problem was with the database server, 

 

Thanks for the reply.

Community Stats

32,084
Posts
121,842
Replies
39,724
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.