Any one got this error in Prefect 2.8.3 while star...
# ask-communityx
Xavier Babu
03/06/2023, 8:04 PMAny one got this error in Prefect 2.8.3 while starting the server? If so, please share the root cause.
195640.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 PMGH?
Xavier Babu
03/06/2023, 8:11 PMAny syntax error in profiles.toml?
Xavier Babu
03/06/2023, 8:16 PMDo we still store the config parameters in DB? If so, what is the table name?
z
Zanie
03/06/2023, 8:25 PM
GitHub
Zanie
03/06/2023, 8:25 PM
We don’t store config parameters in the database
x
Xavier Babu
03/06/2023, 8:26 PMI have two different environments in the same Linux server and have separate profiles.toml. Where exactly we store the default parameters?
Xavier Babu
03/06/2023, 8:28 PMprefect.server.services.flowrunnotifications - Unexpected error in: CompileError
This error relates to any config file?
Xavier Babu
03/06/2023, 8:29 PMWhat 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
Zanie
03/06/2023, 8:30 PM
I’m not sure I understand your issue without more details.
Zanie
03/06/2023, 8:30 PM
That error is coming from SQLAlchemy
Zanie
03/06/2023, 8:31 PM
It’s erroring during compilation of a SQL statement
x
Xavier Babu
03/06/2023, 8:31 PMok
Xavier Babu
03/06/2023, 10:15 PMI upgraded the system with 2.8.4 and it resolved the issue.
👍 1
Xavier Babu
03/11/2023, 2:42 PMZanie, 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)