Question

PostgreSQL reader: bad_expected_access

  • 19 June 2020
  • 1 reply
  • 16 views

Badge +1

Hello everyone,

I encountered a similar issue as the one described in the following post:

https://knowledge.safe.com/questions/95574/problem-with-postgis-reader-in-fme-2019-infinity-v.html

 

Basically I had an invalid date in my PostgreSQL table (no idea how it got there). It had a value of 201910-11-10 which of course is not valid whatsoever.

 

FME 2020 ( Build 20238 - WIN64) throws an error when you try to read this table using a Reader, a FeatureReader or an SQLExecutor/creator.

I was able to bypass this by adding a where clause upon reading (e.g. mydatefield < '2021-01-01').

I'm not looking for a solution for my problem here. I just wanted to add this to the forum so that people who encounter a similar issue know how to solve it. The FME software currently throws an error which is not really useful for debugging purposes (POSTGRES reader::bad_expected_access).


1 reply

Userlevel 4

Thanks for sharing!

Reply