Skip to main content
Best Answer

Oracle writer column does not exist in table

  • August 10, 2021
  • 5 replies
  • 191 views
p.jeremie
Contributor
Forum|alt.badge.img+6

Hi,

 

I am updating an existing table (in fact updating/inserting/deleting with fme_db_operation, created with ChangeDetector).

 

All data is well updated, all coming from my revised source, on all columns of my destination table.

 

However, I have a lot of warning telling me that the column xxxxxx does not exist in table XXXXXXX.

In the database, the columns exist, of course.

 

I am using a FeatureWriter and the feature types have been imported from dataset, Oracle Spatial Object and selecting the tables.

All columns are not updated (some have the red triangle, other the green one).

 

Any idea why I get these warning, whereas the columns are well updated ?

Best answer by p.jeremie

Thanks! 😁

Oracle isn't my strong side I'm afraid, but I'll give it a shot. I can't see anything wrong with the process you mention and if I understand you correctly the data is in fact being updated where it should be.

 

The column names that are being reported as not existing are columns you are updating, correct?

I ended up using two writers, one for update/insert with all columns and one for delete with only the key.

This way I have no warnings.

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.

5 replies

p.jeremie
Contributor
Forum|alt.badge.img+6
  • p.jeremieContributor
  • Author
  • Contributor
  • August 12, 2021

No one have a clue ?

@Hans van der Maarel​ @ebygomm​, you often have great answers :)

redgeographics
Celebrity
Forum|alt.badge.img+62

No one have a clue ?

@Hans van der Maarel​ @ebygomm​, you often have great answers :)

Thanks! 😁

Oracle isn't my strong side I'm afraid, but I'll give it a shot. I can't see anything wrong with the process you mention and if I understand you correctly the data is in fact being updated where it should be.

 

The column names that are being reported as not existing are columns you are updating, correct?

FME rocks! \m/
p.jeremie
Contributor
Forum|alt.badge.img+6
  • p.jeremieContributor
  • Author
  • Contributor
  • August 12, 2021

Thanks! 😁

Oracle isn't my strong side I'm afraid, but I'll give it a shot. I can't see anything wrong with the process you mention and if I understand you correctly the data is in fact being updated where it should be.

 

The column names that are being reported as not existing are columns you are updating, correct?

@Hans van der Maarel​ Yes, I have only some columns I want to update in the table, the ones I kept (AttributeKeeper) before the FeatureWriter. So they are with the green triangle, whereas other columns are with red triangle.

All columns of the table (except the geometry one and the used key, 1 column in my case) are reported not existing.

I wonder if it has something to do with the characters case. I will check.

Edit : All attributes are already in UPPERCASE as in the database.

p.jeremie
Contributor
Forum|alt.badge.img+6
  • p.jeremieContributor
  • Author
  • Contributor
  • August 12, 2021

Thanks! 😁 

Oracle isn't my strong side I'm afraid, but I'll give it a shot. I can't see anything wrong with the process you mention and if I understand you correctly the data is in fact being updated where it should be.

 

The column names that are being reported as not existing are columns you are updating, correct?

I narrowed down the origin of the issue. It occurs only when I have some features to DELETE (fme_db_operation=DELETE).

For INSERT and UPDATE no warning.

Log snippet : 

2021-08-12 16:29:54|   0.9|  0.0|INFORM|Connected to ORACLE database `xxxxxxxxxxxxxx'
2021-08-12 16:29:54|   0.9|  0.0|INFORM|Using existing column `GEOMETRIE' to store geometry in table `SCHEMA.I_ZONE_VEGE_TEST'
2021-08-12 16:29:54|   0.9|  0.0|INFORM|Oracle table 'I_ZONE_VEGE_TEST' already exists. Using existing table
2021-08-12 16:29:54|   0.9|  0.0|WARN  |Column 'DATE_CREAT' does not exist in table 'I_ZONE_VEGE_TEST'
2021-08-12 16:29:54|   0.9|  0.0|WARN  |Column 'DATE_MAJ' does not exist in table 'I_ZONE_VEGE_TEST'
2021-08-12 16:29:54|   0.9|  0.0|WARN  |Column 'NATURE' does not exist in table 'I_ZONE_VEGE_TEST'
2021-08-12 16:29:54|   0.9|  0.0|WARN  |Column 'SOUS_TYPE' does not exist in table 'I_ZONE_VEGE_TEST'

 

p.jeremie
Contributor
Forum|alt.badge.img+6
  • p.jeremieContributor
  • Author
  • Contributor
  • Best Answer
  • August 24, 2021

Thanks! 😁

Oracle isn't my strong side I'm afraid, but I'll give it a shot. I can't see anything wrong with the process you mention and if I understand you correctly the data is in fact being updated where it should be.

 

The column names that are being reported as not existing are columns you are updating, correct?

I ended up using two writers, one for update/insert with all columns and one for delete with only the key.

This way I have no warnings.

Community Stats

32,181
Posts
122,172
Replies
39,855
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.