Solved

Translation returns "FATAL: Expression false" ???

lifalin2016
Rank
Userlevel 1
Badge +22

Hi list.

In the curiosity department, I have a workspace, that seems to finish , but misses some data, adding a small FATAL error message "Expression: false":

 

2021-06-09 09_21_42-_202099029 Import RSF DanDas XML to LER 2.0 data model (H__user_GIS-teamet_FME WWhat triggers this ???

icon

Best answer by lifalin2016 15 June 2021, 10:24

View original
-- Cheers, Lars I.

5 replies

redgeographics
Rank
Userlevel 5
Badge +25

Do you have a SQL statement specified for after writing by any chance? Is the data actually being written?

lifalin2016
Rank
Userlevel 1
Badge +22

Yes, but wouldn't that run after all output has been written? In my case I should have 80K "ledning", but only gets 17K.

My SQL run after translation is fairly straight forward:

UPDATE [$(TARGET_SCHEMA)].[Afløbskomponent] SET [geometri] = [geometri].MakeValid() WHERE [geometri].STIsValid() = 0
UPDATE [$(TARGET_SCHEMA)].[Afløbsledning] SET [geometri] = [geometri].MakeValid() WHERE [geometri].STIsValid() = 0

 

-- Cheers, Lars I.
lifalin2016
Rank
Userlevel 1
Badge +22

Yes, but wouldn't that run after all output has been written? In my case I should have 80K "ledning", but only gets 17K.

My SQL run after translation is fairly straight forward:

UPDATE [$(TARGET_SCHEMA)].[Afløbskomponent] SET [geometri] = [geometri].MakeValid() WHERE [geometri].STIsValid() = 0
UPDATE [$(TARGET_SCHEMA)].[Afløbsledning] SET [geometri] = [geometri].MakeValid() WHERE [geometri].STIsValid() = 0

 

I did manage to get the correct output without encountering any errors, but I had to single-step the entire workspace !!

During my trials I encountered another peculiar error that I haven't seen before:

 

2021-06-09 12_25_25-Window

-- Cheers, Lars I.
hkingsbury
Rank
Userlevel 5
Badge +29

I did manage to get the correct output without encountering any errors, but I had to single-step the entire workspace !!

During my trials I encountered another peculiar error that I haven't seen before:

 

2021-06-09 12_25_25-Window

I believe that second error relates to the feature caching not finding a cached feature. I wouldn't worry about that one too much...

 

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd
lifalin2016
Rank
Userlevel 1
Badge +22

I'm closing this question, there seems to be no obvious explanations.

-- Cheers, Lars I.

Reply


Community Stats

28,694
Posts
109,434
Replies
36,545
Members
Terms & ConditionsCookie 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.