Workflow error in QuestDB node

Questions
1

Hi,
I have created a workflow to calculate OEE by fetching data from QuestDB. And this is my workflow:

The problem what I’m facing is, while clicking on “Execute Workflow”, it stops at QuestDB node and gives an error meassge as “ERROR: Invalid date”.

2021-10-29_143759
2021-10-29_1437591223×496 53 KB

2021-10-29_143855
2021-10-29_1438551087×535 38.6 KB

And once again when I execute the QuestDB node alone, where the error occurred, it executes and gives output.

2021-10-29_143934
2021-10-29_1439341084×517 24.3 KB

Is it the problem with fetching realtime data? Because, I have already created another workflow to calculate OEE for historical data in QuestDB.

3

Hi @Meghna_jose, welcome to our community!

I’m so sorry you are running into this behaviour. I did manage to reproduce this on my end. A simple workaround that did the trick was using parameters instead of injecting an expression into the query string like so (I have slightly adjusted the query to match the data in my QuestDB test instance):

image

Example Workflow

Would this work for you?

1 Like
4

Hi @MutedJam ,
It works for me. Thanks a lot for the help.