Skip to main content
Solved

FeatureWriter block feature when table qualifier is specify


I have two featureWriter fed by same feature. I want to write on a PostgreSQL database.

 

I specify one with a schemas (Table Qualifier) and the other not.

After that I want to use the result who was write to manage my foreign keys.

 

The summary is the same (2 features written).

 

Is it normal that when I specify a table qualifier, any of my feature can't be used after the FeatureWriter ?

Best answer by markatsafe

@matthieubarth Thanks for reporting this issue. There's no reason that the Output port should not pass features if the table Qualifier is set. I've reproduced the problem here and we should be able to get this fixed.

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

6 replies

Forum|alt.badge.img+2
  • Best Answer
  • December 4, 2019

@matthieubarth Thanks for reporting this issue. There's no reason that the Output port should not pass features if the table Qualifier is set. I've reproduced the problem here and we should be able to get this fixed.


ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • March 3, 2020
markatsafe wrote:

@matthieubarth Thanks for reporting this issue. There's no reason that the Output port should not pass features if the table Qualifier is set. I've reproduced the problem here and we should be able to get this fixed.

Is there a reference for this issue? @markatsafe


Forum|alt.badge.img+2
ebygomm wrote:

Is there a reference for this issue? @markatsafe

@ebygomm This should be fixed in FME 2020 (build 20168 and later if you want to test a 2020 bet release.)


ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • March 3, 2020
markatsafe wrote:

@ebygomm This should be fixed in FME 2020 (build 20168 and later if you want to test a 2020 bet release.)

Thanks, I'll take look


Forum|alt.badge.img+2

The core issue reported here - that features are not passed to the output port if there is a table qualifier - has been fixed in FME 2020.

However, depending on how you select the table name on the writer, the table qualifier might be incorporated into the table name, i.e. : mark.CellSignals. If this does occur, then the input and output ports will lose their table qualifiers in the port names and also, features may not be passed across to the output port.

If this does occur, then edit the Table Name as shown above - split the Table Name and Table Qualifier into the separate fields.

We'll try and get this address in a future release.


Forum|alt.badge.img+2
  • August 11, 2020

the issue is fixed in FME 2020.

If you are unable to upgrade to FME 2020, then a workaround is to add the qualifier to the table name. i.e. instead of using the table qualifier field, manually add the qualifer name to the table name field : myqualifier.mytable.


Reply


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