Skip to main content

Hi,

I must update a Oracle table. I use this parameters on the Writer:

Create Table: No

Truncate Existing Table:Yes

Writer Mode: INSERT

But the table is not updated. Can you help me?

How many features are arriving at the writer?

Can you post the log file here?


I don't receive errors. The log said:

Total Features Read 1026820Features Written SummaryTotal Features Written 0Translation was SUCCESSFUL with 3 warning(s) (0 feature(s) output)

I don't receive errors. The log said:

Total Features Read 1026820Features Written SummaryTotal Features Written 0Translation was SUCCESSFUL with 3 warning(s) (0 feature(s) output)
What are the 3 warnings?

 

 


What does the number on the connection to the writer say? Is there a number at all?

Just be aware that if no features hits the writer, the target table will not be truncated.


What does the number on the connection to the writer say? Is there a number at all?

Just be aware that if no features hits the writer, the target table will not be truncated.

I understood the problem...the sheet name of the excel reader changed.

 

Can I insert an option that don't consider the sheet name?

If you don't want the reader to consider the sheet name, use a single merged feature type when creating the reader:

If needed, you'll get the sheet name in "fme_feature_type".


If you don't want the reader to consider the sheet name, use a single merged feature type when creating the reader:

If needed, you'll get the sheet name in "fme_feature_type".

Thanks for your help.

 

 


Reply