Skip to main content
Solved

oracle nonspatial writer not writing to table


srayford
Forum|alt.badge.img
I am using the oracle nonspatial writer in FME Desktop 2015 and I am trying to write to an Oracle table to update 2 fields. I do not see an error when the process finishes but I noticed that the changes are not reflecting in the table. I don't see any options to commit changes. How can I ensure that the changes are being committed? Do you know what would cause the changes to not be committed? Thanks for your help.

 

Best answer by erik_jan

Another good option would be using the DatabaseUpdater transformer instead of the writer.

Documentation can be found here

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

9 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • June 11, 2019

FME will automatically do a commit after finishing the transaction.

So, that is not the cause of not seeing the changes.

Have you set the key attribute, based on which to do the update?

Can you share a screenshot of the writer feature type (table definitions in FME)?


erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • Best Answer
  • June 11, 2019

Another good option would be using the DatabaseUpdater transformer instead of the writer.

Documentation can be found here


srayford
Forum|alt.badge.img
  • Author
  • June 11, 2019

I set a field called ASSETNUMBER for the Update Key Column field.


erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • June 11, 2019
srayford wrote:

I set a field called ASSETNUMBER for the Update Key Column field.

This looks good.

Do you have the attributes you want to update in the User Attributes tab?

Only those are needed.

(FME will create a SQL statement from this information).


srayford
Forum|alt.badge.img
  • Author
  • June 11, 2019
erik_jan wrote:

Another good option would be using the DatabaseUpdater transformer instead of the writer.

Documentation can be found here

I used the databaseupdater transformer and it still did not update the table.


erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • June 11, 2019
srayford wrote:

I used the databaseupdater transformer and it still did not update the table.

Can you share the log file?


srayford
Forum|alt.badge.img
  • Author
  • June 11, 2019
erik_jan wrote:

Another good option would be using the DatabaseUpdater transformer instead of the writer.

Documentation can be found here

log.txt This is the log file from my process in which I read from a SDE versioned table and write to an Oracle table


erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • June 11, 2019
srayford wrote:

log.txt This is the log file from my process in which I read from a SDE versioned table and write to an Oracle table

Looks like you use a Sampler t sample 3 objects for the Oracle table.

But all 3 objects end up in the log ffs file 

D:\FME workspaces\PrimaryGasValves\TEST\geodatabase_sde2oracle_nonspatial_log.ffs

I suppose you do not have the option "Redirect to FFS file" set, like this:

0684Q00000ArN52QAF.png

Opening the FFS file in the Data Inspector can help determining the issue.

 


srayford
Forum|alt.badge.img
  • Author
  • June 11, 2019
erik_jan wrote:

Another good option would be using the DatabaseUpdater transformer instead of the writer.

Documentation can be found here

Using the DatabaseUpdater transformer worked for me! Thanks eric_jan!


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