https://prefect.io logo
Title
x

Xavier Babu

03/06/2023, 8:04 PM
Any one got this error in Prefect 2.8.3 while starting the server? If so, please share the root cause. 19:56:40.777 | ERROR | prefect.server.services.flowrunnotifications - Unexpected error in: CompileError('The ORM FromStatement construct only supports being invoked as the topmost statement, as it is only intended to define how result rows should be returned.')
1
z

Zanie

03/06/2023, 8:07 PM
I’ve never seen that! An issue on GH would be appreciated.
x

Xavier Babu

03/06/2023, 8:07 PM
GH?
Any syntax error in profiles.toml?
Do we still store the config parameters in DB? If so, what is the table name?
z

Zanie

03/06/2023, 8:25 PM
GitHub
We don’t store config parameters in the database
x

Xavier Babu

03/06/2023, 8:26 PM
I have two different environments in the same Linux server and have separate profiles.toml. Where exactly we store the default parameters?
prefect.server.services.flowrunnotifications - Unexpected error in: CompileError This error relates to any config file?
What do you want me to do with GH? Please elaborate.
z

Zanie

03/06/2023, 8:30 PM
Please file a bug report following our template
I’m not sure I understand your issue without more details.
That error is coming from SQLAlchemy
It’s erroring during compilation of a SQL statement
x

Xavier Babu

03/06/2023, 8:31 PM
ok
I upgraded the system with 2.8.4 and it resolved the issue.
👍 1
Zanie, Can you help me on my other Q, I opened separately. Dear Prefect Community, Please share an example to use my_completion_task_hook or my_completion_flow_hook using on_completion tag. I have the basic example from 2.8.3 release. What I am looking for is, is there a way to pass additional parameters along with task, task_run, state? For example, if I need to pass a specific error message in a task_failure_hook. Please help. If you need more details to help me, please let me know. (edited)