Skip to main content
Solved

Problem with postgis reader in fme 2019 (-infinity value of timestamp column)

W
Forum|alt.badge.img

Hello,

 

I just moved to fme 2019 and in this example I'm using workbench  FME(R) 2019.0.1.0 (20190506 - Build 19253 - WIN64)

 

 

I have very simple workspace: creator -> featurereader (postgis) -> gml writer

 

 

0684Q00000ArAy0QAF.png

 

When I run it I don't even get to the breakpoint. On reader there is log:

 

 

 

2019-07-18 21:46:06|   7.6|  7.1|FATAL |POSTGIS reader: An error occurred. FME will attempt to provide more information on the error, but this may cause the translation to be terminated

2019-07-18 21:46:06|   7.6|  0.0|INFORM|Successfully closed POSTGIS database reader

2019-07-18 21:46:06|   7.7|  0.1|INFORM|Successfully closed POSTGIS database reader

2019-07-18 21:46:06|   7.7|  0.0|FATAL |POSTGIS reader: stk::ex::bad_expected_access

 

 

 

I discovered that problem is with one row. In column of type:
timestamp with time zone  

value is:

-infinity

In version fme 2016 I don't have that problem. I executed that workspace with fme 2016 and 2019 and here I can see the difference in fme postgis reader version:

 

 

0684Q00000ArB0GQAV.png

 

I did the same using sql executor, not feature reader and result was the same.

 

 

0684Q00000ArAzJQAV.png

 

 

When I skipped that row using where statement, job was completed without any errors. 

 

 

 

Do you know how can I protect against that error?

Best answer by jovitaatsafe

Hi @witos,

I'm pleased to inform you that a recent update has implemented a fix for the issue reported as (FMEENGINE-61049), so that the translation no longer fails, and will now warn you that infinity is not supported and will default to null. You can find this update in FME 2019.2 (build 19749 or newer) from the beta downloads here. Thanks for letting us know about the issue!

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

7 replies

stalknecht
Contributor
Forum|alt.badge.img+19
  • stalknechtContributor
  • Contributor
  • July 19, 2019

My suggestion is to get rid of the infinity value. As a workaround you can copy the old reader from the 2016 workspace into the 2019 workspace.

itay
Supporter
Forum|alt.badge.img+17
  • itaySupporter
  • Supporter
  • July 19, 2019

Hi @witos,

Try adding a NullAttributeMapper transformer to map the infinity values not null.

Hope this helps,

Itay

W
Forum|alt.badge.img
  • witos
  • Author
  • July 19, 2019
itay wrote:

Hi @witos,

Try adding a NullAttributeMapper transformer to map the infinity values not null.

Hope this helps,

Itay

Should it be after reade? If yes then it will not work because I don't even hit a breakpoint. It fails on reader.

itay
Supporter
Forum|alt.badge.img+17
  • itaySupporter
  • Supporter
  • July 19, 2019
witos wrote:

Should it be after reade? If yes then it will not work because I don't even hit a breakpoint. It fails on reader.

Yes I see that now...then some value changing in de database (via SQL) before reading?

jovitaatsafe
Safer
Forum|alt.badge.img+11

Hi @witos,

 

 

Thanks for your question! It looks like the representation of infinity has changed since 2016 which is why you are seeing it work in 2016 but not in 2019. In the PostGIS reader documentation for FME 2019, under User Attributes, float4 and float8 have a note about not supporting special floating type values such as Infinity.

I think that @stalknecht's suggestions will be your best solution for now. I'll see if I can find out anything more on it, and I'll aim to get back to you early next week on it as the developer I need to talk to is currently away.

jovitaatsafe
Safer
Forum|alt.badge.img+11

Hi @witos,

We were able to reproduce the issue here and I've filed an issue in our tracking system (FMEENGINE-61049) as we shouldn't terminate the whole read process due to the invalid -infinity value. I'll let you know as soon as it has been addressed. Thanks for bringing this up!

jovitaatsafe
Safer
Forum|alt.badge.img+11
  • jovitaatsafeSafer
  • Safer
  • Best Answer
  • August 26, 2019

Hi @witos,

I'm pleased to inform you that a recent update has implemented a fix for the issue reported as (FMEENGINE-61049), so that the translation no longer fails, and will now warn you that infinity is not supported and will default to null. You can find this update in FME 2019.2 (build 19749 or newer) from the beta downloads here. Thanks for letting us know about the issue!

Reply


Helpful Members This Week

Community Stats

31,327
Posts
118,852
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

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
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.