keep icon indicating copy to clipboard operation
keep copied to clipboard

Got error when run workflow

Open parvaj opened this issue 1 year ago • 3 comments

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.

parvaj avatar Mar 31 '24 16:03 parvaj

Hey @parvaj,

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

talboren avatar Mar 31 '24 16:03 talboren

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

talboren avatar Mar 31 '24 16:03 talboren

@parvaj is this still relevant?

talboren avatar May 13 '24 16:05 talboren