Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Got error when run workflow #1024

Closed
parvaj opened this issue Mar 31, 2024 · 3 comments
Closed

Got error when run workflow #1024

parvaj opened this issue Mar 31, 2024 · 3 comments
Labels
Bug Something isn't working Stale Stale issues

Comments

@parvaj
Copy link

parvaj commented Mar 31, 2024

Describe the bug
requirement is get the data from postgres database and alert the message/notify to teams.
here is my yaml workflow file.
Attached the error message.
To Reproduce
Steps to reproduce the behavior:
id: query-postgres-and-notify-teams
description: Query postgres and notify teams
triggers:

  • filters: null
    type: alert
    owners: []
    services: []
    steps:
  • name: postgres-step
    provider:
    config: '{{ providers.jazzpost }}'
    type: postgres
    with:
    query: SELECT * FROM public.ticketinstance LIMIT 1
    actions:
  • name: trigger-teams
    provider:
    config: '{{ providers.jazzware }}'
    type: teams
    with:
    message: Got alert from postgres {{ steps.postgres-step.results.name }}

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
Error during workflow execution

(builtins.TypeError) Object of type datetime is not JSON serializable

[SQL: UPDATE workflowexecution SET results=? WHERE workflowexecution.id = ?]

[parameters: [{'results': {'trigger-teams': [], 'postgres-step': [[('996d081c-6c2d-4439-ba69-0e923fc5354c',

error_keeps_sql

Please help me to fix this issue. thanks.

@talboren
Copy link
Member

Hey @parvaj,

thanks for the issue! I’ll look in to it right away and update ASAP

@talboren
Copy link
Member

@parvaj how are you deploying Keep? Can you provide keep-backend logs?

@talboren talboren added the Bug Something isn't working label Apr 1, 2024
@talboren
Copy link
Member

@parvaj is this still relevant?

@talboren talboren added the Stale Stale issues label May 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working Stale Stale issues
Projects
None yet
Development

No branches or pull requests

3 participants