Solved
oracle nonspatial writer not writing to table
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
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.
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.
+22- Contributor
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)?
+22- Contributor
- Best Answer
Another good option would be using the DatabaseUpdater transformer instead of the writer.
Documentation can be found here
I set a field called ASSETNUMBER for the Update Key Column field.
+22- Contributor
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).
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.
+22- Contributor
srayford wrote:
I used the databaseupdater transformer and it still did not update the table.
Can you share the log file?
+22- Contributor
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
1D:\FME workspaces\PrimaryGasValves\TEST\geodatabase_sde2oracle_nonspatial_log.ffsI suppose you do not have the option "Redirect to FFS file" set, like this:
Opening the FFS file in the Data Inspector can help determining the issue.
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!
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.